VBA to check values from one sheet and copy only content to another sheet

VBA to check values from one sheet and copy only content to another sheet

Hi folks

I have been trying for the last 5 days x 10 hours to solve my problem. Google searched, VBA tutorials tried, etc.

Here is the scenario:

Sheet called "lager" which contains a lot of data and sheet "update" where the content should be copied to.

In "Lager" sheet - there is a lot of blanks in the column "A" (well - blank in that case that there is a formula in cells, but no content). ie:

Please Login or Register  to view this content.

Problem - HOW do I copy all content from "Lager" to "update" - but SKIP every blank in column A - so the result in sheet "update" will be:

Please Login or Register  to view this content.

I have 10 columns in "Lager" sheet that needed to be copied to "Update" sheet - but the code shall look in column A, and if any blank - skip the entire row and go to next - if it finds some content - copy it to "update" sheet - and so forth.

Does it make sense? English is not my native language....

Kindly regards - and thank you for trying to help me.
Thomas

Maybe:

Please Login or Register  to view this content.

Thanx for your effort. But it does not seem to work properly.

I have two sheets - "Lager" and "update" - and in the "lager" sheet - i have Columns A - J with content in. But if Column A is blank in some cells - skip it and go to the next.

Can you still help?

What doesn't work properly? Can you attach a sample file which has data. I tested it on some dummy data I made up.

Hi John

Thank you for helping me. I really appreciate it!

I have linked to a dummy file here: http://www.hitta.fo/excelforum/dummy1.xlsx

I hope it give some sense to you. I want to copy all content from the "Lager" sheet, into my "Update" sheet - but no blanks as you can see there is in the Lager sheet.

Hey John - did you gave up? :-)

Anyone who can point me at the right direction to get this solved?

Works for me on your sample. Did you select sheets Lager first?

Please Login or Register  to view this content.

Hi John

Awesome.. And yes the Lager sheet is selected first. I will check out your code right now... i'll be back ;-)

YES! IT works! Thank you a bunch!!

I will notice your name in my "helpful people" list. :-)

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.

Thank you again John - I have now made the thread marked "Solved".

Is it possible to get in touch with you if i have another problem - and i want you to get paid?

If you have a problem with the solution in this thread, just re-post (you can PM me as well). If you have another problem then start another thread. Never mind about paying. These forums are voluntary. Thanks for the rep.