Require Macro to find cell and copy selection of data to last empty cell in column A

[spi]

Here's my problem.

I have a spreadsheet but all of the data is on the first two rows, the column headers are repeateded when the data is repeated. What I have to do is find a column containing the word Username and then copy the cell below along with the next 12 cells on that row.

This information has to then be posted in the last blank Cell in column A.

Here's what I have so far.

Please Login or Register  to view this content.

If anyone has any comments or questions please don't hesitate to contact me. I would sincerely appreciate any assistance you can give.

[Leith Ross]

Hello spi,

Welcome to the Forum!

From what I see, the code does what you ask. What do you want it do differently? in the future, it is good practice to post your workbook and any files associated with your macros. This will greatly speed up the process of finding a solution by eliminating the need to recreate your data for testing.