Hi all,
Can anyone help with this one. I'm working between 2 worksheets, a list of data held in worksheet 'Store' and some empty cells in worksheet 'Input'.
I'm hoping to add some VBA code to the end of an existing macro to do the following:
Find the last cell/row in the worksheet 'Store', copy the contents from cells B & F, and then paste them into cells A6 & B6 on the worksheet 'Input'.
Hopefully this should mean as my 'Store' sheet is populated, the last row of the sheet is always displayed on the 'Input' sheet.
I'm using it as a kind of display back to user the last row input.
Thanks all
*EDIT* I should point out, column A on Sheet 'Store' is prepopulated to the end, so the find last cell forumla needs to check column B.
Can anyone help with this one. I'm working between 2 worksheets, a list of data held in worksheet 'Store' and some empty cells in worksheet 'Input'.
I'm hoping to add some VBA code to the end of an existing macro to do the following:
Find the last cell/row in the worksheet 'Store', copy the contents from cells B & F, and then paste them into cells A6 & B6 on the worksheet 'Input'.
Hopefully this should mean as my 'Store' sheet is populated, the last row of the sheet is always displayed on the 'Input' sheet.
I'm using it as a kind of display back to user the last row input.
Thanks all
*EDIT* I should point out, column A on Sheet 'Store' is prepopulated to the end, so the find last cell forumla needs to check column B.
Last edited: