Hi guys
Im brand new to coding etc - I can record macros pretty well but i want to get into this side of things
Im currently trying to create a macro that will copy 2 hidden (hidden due to having concantenation formula the user doesnt need to see) cells on a specified row (is there anyway to create a window where the user can specify the row the info will come from) (columns N & O) and then move to another sheet ("Round up") to paste the 2 cells in the next blanks in Columns A & B
im really struggleing with the selecting of the row required and the moving down the column to paste in the next blank sheet
any help would be greatly appreciated.
regards
Ben
Im brand new to coding etc - I can record macros pretty well but i want to get into this side of things
Im currently trying to create a macro that will copy 2 hidden (hidden due to having concantenation formula the user doesnt need to see) cells on a specified row (is there anyway to create a window where the user can specify the row the info will come from) (columns N & O) and then move to another sheet ("Round up") to paste the 2 cells in the next blanks in Columns A & B
im really struggleing with the selecting of the row required and the moving down the column to paste in the next blank sheet
any help would be greatly appreciated.
regards
Ben