I have a ton of data in one excel file organized into several tabs. The format (organization/labels/headings, etc) and placement (columns/rows) in each tab is exactly the same, the only thing changing are the numbers. I am doing exactly the same processing and calculation to each set. It would save me an enormous amount of time if I could propagate my formulas and formatting from the first set through all the rest but I'm not sure how to do that without a bunch of "ctrl+c"-ing and cell target editing. I'm sure this can be done without writing a macro, so any advice would be incredibly appreciated.

If I weren't under a time crunch I'd have put this in another section, but thanks in advance for any help. If it matters, I'm using Excel 2007

11/27/2012 1:50:16 PM

group sheets, enter formula(s), drag as needed, profit.

11/27/2012 2:04:45 PM

depends what processing you are doing... if everything is cell referenced, then copy and paste won't require any cell changes

[Edited on November 27, 2012 at 2:06 PM. Reason : also this^]

11/27/2012 2:06:29 PM

^

^^

11/27/2012 2:15:33 PM

as long as you don't have any $'s in your formula, you should be able to just copy and paste what is in one tab to another tab without any changes.

Select all the calculations on the first tab an then all you have to do is make sure that the calculations portion in the subsequent tabs begins in the same row/cell as the previous one. All of your information should link perfect for each row and column if you do that.

11/27/2012 2:16:51 PM

There are lots of $s, also plots and tables

The group sheets trick is handy though...will certainly help in cutting down the repetition

Thanks all

11/27/2012 2:20:34 PM

Quote :

"group sheets, enter formula(s), drag as needed, profit."

11/27/2012 2:22:06 PM

could have written a macro to do this in far less time than it took to post and wait for responses. even with little to no experience. just saying.

[Edited on November 27, 2012 at 2:25 PM. Reason : jank]

11/27/2012 2:25:47 PM

^^^ if you do the group method, as long as the $-referenced cells are done properly and in the same spot on each respective sheet it should work properly across all sheets with just entering formulas and dragging as necessary.

[Edited on November 27, 2012 at 2:30 PM. Reason : ]

11/27/2012 2:30:22 PM

Man I don't know how I've been using excel as long as I have and I didn't know about grouping sheets like that

Though I suppose I don't typically have this amount of data formatted like this

11/27/2012 2:44:18 PM

grouping sheets is incredibly useful.

it is also incredibly dangerous.

11/27/2012 2:46:47 PM

yeah I'm spot-checking as I go along

11/27/2012 2:52:42 PM

Yeah, I use excel all the time and I'm the go-to guy in my department for putting together calculation spreadsheets and what not (though I am nowhere near an expert) but I still didn't learn about grouping until last year

The main reason is like you said though: I'm not normally working on too many things that have data formatted in a way to use it.

[Edited on November 27, 2012 at 3:18 PM. Reason : ]

11/27/2012 3:17:43 PM

any way to do the same thing for plots?

11/27/2012 3:32:12 PM

definitely macro for plots

[Edited on November 27, 2012 at 3:39 PM. Reason : record the first one, change sheet names, ... ,profit]

[Edited on November 27, 2012 at 3:39 PM. Reason : double edit: RECORD THE FORMATTING TOO!]

11/27/2012 3:38:03 PM