• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA paste range of functions

V

Viya

New Member
Hello,

I have a sheet where column A is ID of Product. In each cell of the next 6 columns (C-H) is formula.

First line of cells with formulas always exists.

I need create macro - if in a cell IDProduct exists copy the first line and paste it opposite the cell with IDProduct. AND if IDProduct doesn't exist delete all formulas except first line.

Does somebody know how create it?

Thank you!!!!
 
Hi, Viya!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!
 
Hi, Viya!
A few doubts:
a) You say column A with product ID and 6 columns from C:H, but in your sample file product ID is in column C and there're only 4 columns from D:G.
b) What do you intended to mean by "paste it opposite the cell with IDProduct"?
Regards!
 
You must log in or register to reply here.
Back
Top