Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

Hi Experts,

I am trying to copy values from Get Data tab to F-28 tab but only for the rows that I place an "X" in column I on Get Data tab. I have attached the file I am working on. I would like to have a button to click which does the copy and paste. On the F-28 tab I would like for there to be no blanks in the copy paste, i.e., If copying lines 2, 4, 6 from Get Data then paste into 2, 3, 4 on F-28 tab. I need the paste to start on line 2 on F-28 tab. Thank you very much in advance for any help.

Click the button I've added to the "Get Data" sheet in the attached, et voila!

Keep in mind this is VERY basic code I've written. It does what you want, but it's got no bells and whistles.

As with most things in Excel, this is ONE way of doing it. There are no doubt many many others.

Should get you going though.

Hope it helps.

BSB

Maybe:

Please Login or Register  to view this content.

Hmmm... I may be late to the party, but here is what I came up with -- not sure why mine is so much longer.

Please Login or Register  to view this content.