Copying from one sheet to another if there is a value in a specific cell.

Maybe:

Please Login or Register  to view this content.

That copied everything from Sheet 5 Column D to Sheet 5 column A.

Correction. To every Sheet after that as well.

I think this was my fault with the explanation.

I need to copy Column D4,E4, and F4 down (if there is a value in Column F) from just the 5th worksheet. And then, just on the last worksheet paste into column A4, B4, C4 and down.

Sorry about the confusion.

Try:

Please Login or Register  to view this content.

Ok, works perfect. Except for one thing. In this example, there is a value in cells 4 through 249. And 323. In this application there will always be the bulk ones at the top together, then a bunch with no value, and maybe some with value in F at the bottom.

Are you refering too the destination sheet. Can you provide a sample of the 5th Sheet and the Last Sheet after the macro is run?

test3.xlsx

Let's see if this works.

So as you see, there are values in Sheet5 from 4-249 and 323. But it only copies over to Last sheet. 4-249.

OK. Maybe:

Please Login or Register  to view this content.

Sorry, still the same output.

Please explain your requirements "I need to copy Column D4,E4, and F4 down (if there is a value in Column F) from the 5th worksheet". If you check your row 323 there should be a value there?

Ahh. Yes, you are right, didn't see that down there, So then I just need to add to my macro to delete the blank rows to get 323 up with the rest of the cells. Thank you.

Does this give you the output you want??

Please Login or Register  to view this content.

Perfect. Thank you very much.

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.