worksheets question

  • Thread starter Thread starter Bacchus
  • Start date Start date
B

Bacchus

Hello again

Just wondering.

I am going to be working with 12 different worksheets. One for every month.

I am on the first one now and want to duplicate the look and formulas to
each monthly worksheet. Can someone let me know how this is done?

thanks
 
Bacchus,

This one comes up all the time. Consider putting all the data in one sheet,
with an extra column to indicate the month of each record. Later you'll
likely want to do all kinds of stuff across all the data (Pivot table
totals, pulling certain records (rows) that span the months, sort the table
differently for various purposes, Subtotals, etc. etc. etc.) Essentially
impossible with the data spread over separate worksheets -- piece of cake
when it's in one. An Autofilter can easily reduce the sheet to any given
month when desired.

Consider this carefully. It will likely work out better later.
 
Fully agree with Earl! The number 1 problem Excel users create for
themselves is spreading out related data.

Always use as few sheets as possible for raw data and set it out in a
classic table format. That is, headings across row 1 of the table and
all related data directly underneath.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Back
Top