| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drag across multiple data sets
Hi, i am looking to drag my calculation across cells in excel.
I have a two page set up. Calculation in cell 1, sheet 1 = 4 cells across on sheet 2 I want to drag the formula across my cells on sheet 1 so that Cell 1 sheet 1 = Sheet 2 Cells 1 - 4 Cell 2 Sheet 1 = Sheet 2 Cells 4 - 8 Cell 3 Sheet 1 = Sheet 2 Cells 9 - 12 etc... also Cell 10 Sheet 1 = Sheet 2 cell 4 Cell 11 Sheet 1 = Sheet 2 cell 8 Cell 12 Sheet 1 = Sheet 2 cell 12 etc... This would make things alot easier, REALLY dont want to have to do these by hand 1000 times :) Hope some one can help. Thanks Giddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One regression through multiple data sets | Charts and Charting in Excel | |||
| Charting multiple off-sheet data sets | Charts and Charting in Excel | |||
| Multiple Data Sets | Excel Discussion (Misc queries) | |||
| How to show multiple data sets on one bar chart | Charts and Charting in Excel | |||
| How do I pull in multiple data sets at once? | Excel Discussion (Misc queries) | |||
Threaded Mode
