copy range from worksheet

[romanzero]

Greetings,

I am new to VBA in Excel so pardon any newb questions...

I would like to create a "footnote" type funcion where a user's input would be entered into a cell - copied to an adjacent worksheet - and then replaced with a footnote number.

In addition two other cells on the same row would need to be copied to the adjacent worksheet as well.

Example

Col_A Col_B Col_C Col_D
text 1234 abcd Notes1

With a command button the user would copy the values from columns A,C, and D (not B) to a the adjacent worksheet. Whatever notes were entered in column D would be replaced with the number "1" on the original worksheet.

This seems pretty straight forward to me, except that there will be multiple rows (inconsistant across reports), so I am not sure how to refernce the column.

Any help would be greatly appreciated.

 

[Loomah]

Hi
Try using the macro recorder to do this once. You can then try to edit the code yourself or, if you post back with your recorded code I'm sure someone will help you with any looping structure etc that you will need if there are more rows to copy.

I say this because the best way to learn is by using the recorder. That's how I started and I'm sure the same goes for many others in this forum!

Good Luck!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​