Can this be done, and if so....how?
Worksheet 1 is for data entry and will have the following row names
A1 = Date
A2 = Reading 1
A3 = Reading 2
The info will be entered periodically on Sheet 1. So I would enter the data alongside the names. Cell B1 I will enter the date. Cell B2 Reading 1 and Cell B3 Reading 2. The entered data is then copied into Worksheet 2 where the historical info is stored. So my column names will be
A1 = Date, B1 = Reading 1, C1 = Reading 2.
So the first time I enter my data into Worksheet 1, whatever date I enter into B1 would be copied into blank cell A2. Whatever data I enter into Worksheet 1 cell B2 would be copied into blank cell B2. And whatever data I enter into Worksheet 1 cell B3 would be copied into blank cell C2.
Next time around, I enter my data into Worksheet 1 to the same cells B1, B2 and B3. Whatever date I enter into B1 would be copied into the next blank cell A3. Whatever data I enter into Worksheet 1 cell B2 would be copied into the next blank cell B3. And whatever data I enter into Worksheet 1 cell B3 would be copied into the next blank cell C3. The original data entered would remain unchanged.
The data entry will be repeated, with the new data being copied to blank cells and the old data remaining unchanged.
Or is there another way?
Worksheet 1 is for data entry and will have the following row names
A1 = Date
A2 = Reading 1
A3 = Reading 2
The info will be entered periodically on Sheet 1. So I would enter the data alongside the names. Cell B1 I will enter the date. Cell B2 Reading 1 and Cell B3 Reading 2. The entered data is then copied into Worksheet 2 where the historical info is stored. So my column names will be
A1 = Date, B1 = Reading 1, C1 = Reading 2.
So the first time I enter my data into Worksheet 1, whatever date I enter into B1 would be copied into blank cell A2. Whatever data I enter into Worksheet 1 cell B2 would be copied into blank cell B2. And whatever data I enter into Worksheet 1 cell B3 would be copied into blank cell C2.
Next time around, I enter my data into Worksheet 1 to the same cells B1, B2 and B3. Whatever date I enter into B1 would be copied into the next blank cell A3. Whatever data I enter into Worksheet 1 cell B2 would be copied into the next blank cell B3. And whatever data I enter into Worksheet 1 cell B3 would be copied into the next blank cell C3. The original data entered would remain unchanged.
The data entry will be repeated, with the new data being copied to blank cells and the old data remaining unchanged.
Or is there another way?