Macro for copy and paste

[gav_69]

Hey Guys,

I think this is a fairly easy question but I cant figure it out. Please see attached, this is a pretty simple example, See column A, if i want to put a 1 beside column A as long as a cell is populated in column A how do i do that.
Is there a simple macro i can use.

THanks for any help,
Gav.

[sweep]

Hi,

Try this?

Please Login or Register  to view this content.

[gav_69]

Thanks for the help, that worked great, just one more question if i want it to insert text and not numbers how do i do that. I tried changed it to show text but it is coming out blank

Please Login or Register  to view this content.

[sweep]

Without quotes you're trying to set the cell value to the variable EQ, which is empty. Try this:

Please Login or Register  to view this content.

[gav_69]

Awww jesus sorrry i should have know that, completely forgot I needed to wrap test with quotes.

Thanks a mill man.

[gav_69]

Can i pick your brain one last time i promise, from your code above if i want to put in column B a description that goes for example gavin1 in cell B1, gavin2 in cell b2 and so on and on, till there is a description for every populated cell in column A. So if there is 200 cells populated in A, B should be gavin1 right down to gavin200. is that possible.

Thanks very much for the above help

[sweep]

Yup, like this:

Please Login or Register  to view this content.