Macro to add items with value to another tab

[ricdamiani]

Hi there,

Can you please help me building a macro that adds items with value in a list to a different tab?

See attached Example spreadsheet demonstrating in more details.

Thanks!

[WideBoyDixon]

I went with this macro assigned to the button:

Please Login or Register  to view this content.

Also attached.

WBD

[ricdamiani]

Thanks WBD, but I'm having problems to implement it on my real sheet.

I tried to reproduce my real spreadsheet with the attached new example, and you can see that after you run the macro, the items and the quantities are in different rows in the "New PO" tab. Can you help me fixing that?

Also, when I have my real spreadsheet with all the data and formulas, this macro takes around 5 seconds to complete (counter productive when going through hundreds of items). Is there a way to make it faster? I have a similar macro that copy & paste and run super fast, but it does not look at blank cells. The code is:

Please Login or Register  to view this content.

[WideBoyDixon]

Try this instead:

Please Login or Register  to view this content.

WBD

[ricdamiani]

It's almost good, but the clear contents line is giving me error because columns X and Y are merged.

Interesting that your first macro did not have this error, so I'm wondering if it is possible to clear contents using the logic in the first code?

Thank you!

[WideBoyDixon]

Change this one line to use 2 instead of 1:

Please Login or Register  to view this content.

WBD