| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link multiple columns to multiple worksheet totals / functi
Hi,
I havea work book with 13 worksheets ... 12 worksheets for Jan to Dec. They are all identical structure, with vaying perfomance data entered. I have created a 13th worksheet to summarise key information for each month. One column per month. There are some complex formulas to display the result I want, which work ok for the column I have created them on. I now want to copy over the formulas in each column to correspond with each month ... without having to type each formula again. In other words ... Summary worksheet column Jan = data collected from worksheet Jan I would like to copy these formulas so that Summary worksheet column Feb = data collected from worksheet Feb ... and so on. I'm guessing there is an easy way to do this .. but I cannot figure it out! Can anyone help please? Thanks Chieftan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to link totals on multiple worksheets into one total | Excel Worksheet Functions | |||
| Repeat same data entry to multiple worksheets without Group Functi | Excel Discussion (Misc queries) | |||
| Counting totals between multiple columns for like items | Excel Worksheet Functions | |||
| Totals f(x) text values in multiple columns and cells | Excel Discussion (Misc queries) | |||
| Summary of Multiple Worksheet Running Sum Totals | Excel Worksheet Functions | |||
Threaded Mode
