Find last Cell in Column and enter formula

[ashley72788]

Hi Everyone,

I have a workbook running a macro that copies rows into a worksheet each time the macro is ran. I added the following columns to the worksheet - they're currently blank:

Column P - Date Added
Column Q - Added By (using Environ)

I want this information to be added when the rows are copied over so I can capture the user and the date the information was added to that sheet.

Each time the macro is ran, 20-30 rows are added to the sheet so I am unsure how to find the first blank cell in columns P and Q and then enter the formulas to populate this information until there is no longer data in the row.

I figure I can use a combination of find the first blank column/last row to copy the formula's down but have no idea how to write that.

Any help is appreciated!

Thank you!

[davesexcel]

try it out,
The range to copy is just an example, I don't know how you are copying the range from the other sheet.

Please Login or Register  to view this content.

[ashley72788]

Hello!

Thank you for the reply I'm copying the data using this formula:
I'm not sure how to incorporate your formula with this one, any ideas?

Please Login or Register  to view this content.

[davesexcel]

Replace my copy code with your copy code

[ashley72788]

I tried, it wasn't working

[davesexcel]

Please Login or Register  to view this content.

[ashley72788]

Thank you !!!!!