LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 116
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Coping formulas carper1975 New Users to Excel 2 June 18th 09 09:15 PM
Coping formulas computexcel Excel Discussion (Misc queries) 2 August 11th 08 12:01 AM
Coping formulas Jordan Excel Worksheet Functions 4 December 1st 05 05:20 PM
coping formulas from one cell to another greg Setting up and Configuration of Excel 2 October 23rd 05 07:29 AM
coping a formulas to another cell. Sierrafsws Excel Worksheet Functions 1 July 22nd 05 06:55 PM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"