“ADD” macro

Hi Guys,

Once again need your expertise and would appreciate any help.

The goal here is also very simple: copying some cells (as per below) in Tab 1 and pasting them in "New POs" tab in the first available row.

I have attached an example spreadsheet and I steps would be:

1) In Tab 1, copy cells B6, B7, C21, D21 and E21 (in this order)
2) In New POs, past them in the first available row.

Thanks guys,

Rick

Originally Posted by ricdamiani

Hi Guys,

Once again need your expertise and would appreciate any help.

The goal here is also very simple: copying some cells (as per below) in Tab 1 and pasting them in "New POs" tab in the first available row.

I have attached an example spreadsheet and I steps would be:

1) In Tab 1, copy cells B6, B7, C21, D21 and E21 (in this order)
2) In New POs, past them in the first available row.

Thanks guys,

Rick

12?

Please Login or Register  to view this content.

"In New POs, past them in the first available row."
Is only the value needed or do you want to copy the format to ??

Originally Posted by jindon

12?

Please Login or Register  to view this content.

Hi jindon,

Yes, 12 is correct.

Thanks for the suggestion but I removed the Msg box asking if "I really want to add", I think will be quicker without it.

But was thinking if the following could be changed:
- a confirmation message box after added saying "ADDED"
- also after added, values in cells C21, D21 and E21 are deleted

Any chance on getting this changed?

Thanks,

Rick