Hi,
I have a main sheet where i would fill in cells with certain information into cells that are arranged in different positions on the sheet, ie not in uniformed rows or columns.
I have these values copied to anther worksheet to form a new record into an exisiting dynamic range.
To do this I use a macro that copies each individual cell (there are 23) and places them into the correct columns of a given row. This works fine. However, when I run this the macro navigates between the worksheets 23 times which is not easy on the eye. Is there a way to get the macro to do the process without jumping back and forth?
A second issue is how do I get the macro to find the last row to then start adding the cells along the new row? Currently, I begin the macro by inserting a new row at the top just below the headers row and then just fill in the cells from left to right into specific cell locations along row B. Once complete, I get it to do an A-Z sort on the first column at the end of the macro run.
any ideas please?
Cheers Rob.
Bookmarks