C
Corey
I have a timesheet setup that is in a worksheets range of (A1:U42), but
including the TimeSheet layout i have Forumla's that extend to the Ranges of
(A1:BX78).
What i want to do is have the data stored in this work sheet, BUT each New
TimeSheet stored in the worksheet ALSO.
So(if this is the best method), how can i code successfully a copy of the
range(A1:BX78), and this Copy placed at the TOP of the worksheet, and moving
the previous timesheet down in the worksheet. But i still NEED the Formulas
to work for the New Copied timesheet.
This way i can have a list of previous and current timesheets to refer to at
a later stage.
How many ranges of (A1:BX78) with Hundreds of Formulas(EXCEL FILE = 315kb
with ONLY 1 worksheet and 1 range) could excel handle?
Thousands or Hundreds of the ranges specified?
I need a point in the right direction to accomplish this.
I know there is limitations to the number of Worksheets in excel, so i do
not want to create a new worksheet for each timesheet, therefore my
reasoning is to copy/paste the range above the previous in a single work
sheet.
***********************
(Can this be done also deleting the values in the COPIED range, yet NOT
DELETING the Formulas)?????
***********************
your assistance is appreciated
Regards
Corey
including the TimeSheet layout i have Forumla's that extend to the Ranges of
(A1:BX78).
What i want to do is have the data stored in this work sheet, BUT each New
TimeSheet stored in the worksheet ALSO.
So(if this is the best method), how can i code successfully a copy of the
range(A1:BX78), and this Copy placed at the TOP of the worksheet, and moving
the previous timesheet down in the worksheet. But i still NEED the Formulas
to work for the New Copied timesheet.
This way i can have a list of previous and current timesheets to refer to at
a later stage.
How many ranges of (A1:BX78) with Hundreds of Formulas(EXCEL FILE = 315kb
with ONLY 1 worksheet and 1 range) could excel handle?
Thousands or Hundreds of the ranges specified?
I need a point in the right direction to accomplish this.
I know there is limitations to the number of Worksheets in excel, so i do
not want to create a new worksheet for each timesheet, therefore my
reasoning is to copy/paste the range above the previous in a single work
sheet.
***********************
(Can this be done also deleting the values in the COPIED range, yet NOT
DELETING the Formulas)?????
***********************
your assistance is appreciated
Regards
Corey