Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Coping Cross Tab Formulas
I have a workbook that contains 1 tab for each day of the month and a status
tab that I want some of the info on the individual tabs to roll up to. On the status tab I have a row that has 31 columns and I want to populate each cell in the row with info from 12 of the tabs but each cell needs to read from a different tab. The cells are the same order as the tabs. I know how to build the formula in each cell individually but is it possible to copy from one cell to the next (click and drag) the formula and have the tabs in the formula to progress with each cell? I hope that is not too confusing -- Bigm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coping formulas | New Users to Excel | |||
Coping formulas | Excel Discussion (Misc queries) | |||
Coping formulas | Excel Worksheet Functions | |||
coping formulas from one cell to another | Setting up and Configuration of Excel | |||
coping a formulas to another cell. | Excel Worksheet Functions |