enter data in single worksheet, appear in multiple

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with 40 sheets inside. Each sheet corresponds to a separate voting district, but the formats are identical. Records are entered into the proper sheet depending upon the voters precinct.

What I would like to do is have a 41st sheet that has the same format, but combines each of the other 40 sheets into one long list. I could obviously just enter each record on the regular sheet as well as the 41st sheet, but there is a lot of info and would save much time if it could be done just once. Is this possible without a lot of code?
 
You could try a pivot table with multiple consolidation ranges, though 40 sheets might be more than it could cope with.

You could link the 40 sheets into different blocks on your summary sheet and hide or filter out the empty rows.
 
Hi
I would do this differently :-)
- enter all the data in one single sheet
- add a column for your voting district
use 'Data - Filter' for showing only the relevant parts
 
that's actually not a bad idea at all, thanks.

the biggest problem with any solution i come up with is the formatting of the existing document. there are merged cells and each record actually takes up two lines so i'm having trouble grouping the two lines as a single record.... excel wants to treat each line as a record and filter/sort that way which of course doesnt work for me.
 
I suggested the same thing... but was met with a "thats how it has to be, so make it work like that" type of answer.

i'm also working on an Access file to accomplish the task, but involves much more understanding which none of them have... so i can probably accomplish it but if i'm not around to make changes, no one will understand it. They're barely Excel literate.

In any case, thanks for the help!
 
Back
Top