I've got a basic 10 column table that i am using to gather length measurements.
Each column has 18 rows. I have the same table on several different sheets.
I'm using a measuring device that transfers the measurement directly into excel and then auto advances to the next cell in the column.
ex. i cursor select cell A1, press the button on the measuring device, it populates cell A1 and advances the cursor to cell A2, on and on.
What I want to do is as follows:
when i reach the end of the column, ex. cell A18, rather than manually selecting cell A1 on the next sheet, I would like to have the cursor automatically position itself in cell A1 on the next sheet after a value is entered into A18 on the first sheet, and again to the next sheet and the next until all the A columns are populated. Following population of column A on all the sheets, I will manually go back and select cell B1 on the first sheet and repeat the process, then on to C1 etc until the cells are all populated.
Is this possible?
I'm not well versed in macros or VBA so i'm not sure if this is something that can be done with those tools...
Thanks for your help
Jeff