B
Benjamin
The title is a bit cryptic but in essence I want to create something similar
with the data I have.
1. Data is categorized in columns with its own label/legend. This data is
updated every day with new information being added to the end of each column.
2. Data is also part of a larger spreadsheet.
3. Data needs to move to a new spreadsheet in the same workbook.
4. The new spreadsheet must only have selected column from original
spreadsheet in same workbook.
Now it gets tricky...
5. The new spreadsheet shows a history of the past 5 days update I have done
of the selected labels/legends.
CAN I GET THE SPREADSHEET AS I ADD A NEW ENTRY AT THE BOTTOM OF THE COLUMN
COPY THE NEW ENTRY TO THE NEW SPREADSHEET BUT ALSO MOVE YESTERDAY'S DATA ONE
SPACE BACK AND THERFORE DAY 5 DROPS OF THE SPREADSHEET?
I have been told to write a macro for this - but I have no clue as to how
and hwere to start. By the way I am on 2003...
Help me!!
with the data I have.
1. Data is categorized in columns with its own label/legend. This data is
updated every day with new information being added to the end of each column.
2. Data is also part of a larger spreadsheet.
3. Data needs to move to a new spreadsheet in the same workbook.
4. The new spreadsheet must only have selected column from original
spreadsheet in same workbook.
Now it gets tricky...
5. The new spreadsheet shows a history of the past 5 days update I have done
of the selected labels/legends.
CAN I GET THE SPREADSHEET AS I ADD A NEW ENTRY AT THE BOTTOM OF THE COLUMN
COPY THE NEW ENTRY TO THE NEW SPREADSHEET BUT ALSO MOVE YESTERDAY'S DATA ONE
SPACE BACK AND THERFORE DAY 5 DROPS OF THE SPREADSHEET?
I have been told to write a macro for this - but I have no clue as to how
and hwere to start. By the way I am on 2003...
Help me!!