latinsbest
04-01-2013, 03:50 PM
I have two spreadsheets
NP Calculator
SUBJECT (This is any spreadhseet renamed to subject that has the same column setup just different data)
I would like to have a button calculate information from SUBJECT and record the information on NP Calculator. The button will be on NP Calculator.
The command button should look into A2:A10000 (Serial Numbers) and B2:B10000 (Data) and whatever cell on B is empty the A cell will be recorded into NP Calculator A2:A10000.
For example let's say (SUBJECT) B5 has no Data then A5 will be recorded into (NP Calculator) A2.
The next number will be recorded into A3 and then A4 and so on.
Both spreadsheets will be using (sheet1). Thank you in advance.
NP Calculator
SUBJECT (This is any spreadhseet renamed to subject that has the same column setup just different data)
I would like to have a button calculate information from SUBJECT and record the information on NP Calculator. The button will be on NP Calculator.
The command button should look into A2:A10000 (Serial Numbers) and B2:B10000 (Data) and whatever cell on B is empty the A cell will be recorded into NP Calculator A2:A10000.
For example let's say (SUBJECT) B5 has no Data then A5 will be recorded into (NP Calculator) A2.
The next number will be recorded into A3 and then A4 and so on.
Both spreadsheets will be using (sheet1). Thank you in advance.