Merging worksheets into one

Edward Owen · 05-17-2006, 01:30 PM

Is it possible to take 3 or 4 identical spreadsheets, each identical in
design, but with unique data and merge them into one?

This would be used to count votes in a local election. There would be
approximately 46 precincts in the spreadsheet, and four people would have
identical copies on networked computers. They would enter precincts one at
a time as they are called in, with results for each precinct ONLY being
entered by one of the four operators.

I'd then like to merge (or add them together) to get running totals.

I hope this makes sense, and thanks for any advice.

Ron de Bruin · 05-17-2006, 01:50 PM

See this for workbooks
http://www.rondebruin.nl/copy3.htm

Or do you want to do it for worksheets

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Edward Owen" <elo(killthespammers)[email protected]> wrote in message news:%[email protected]...
> Is it possible to take 3 or 4 identical spreadsheets, each identical in design, but with unique data and merge them into one?
>
> This would be used to count votes in a local election. There would be approximately 46 precincts in the spreadsheet, and four
> people would have identical copies on networked computers. They would enter precincts one at a time as they are called in, with
> results for each precinct ONLY being entered by one of the four operators.
>
> I'd then like to merge (or add them together) to get running totals.
>
> I hope this makes sense, and thanks for any advice.
>

Edward Owen · 05-17-2006, 01:55 PM

No, I meant individual spreadsheets, but typed worksheets in the subject
line by mistake.

I'll check it out! Thanks!

"Ron de Bruin" <[email protected]> wrote in message
news:[email protected]...
> See this for workbooks
> http://www.rondebruin.nl/copy3.htm
>
> Or do you want to do it for worksheets
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Edward Owen" <elo(killthespammers)[email protected]> wrote in message
> news:%[email protected]...
>> Is it possible to take 3 or 4 identical spreadsheets, each identical in
>> design, but with unique data and merge them into one?
>>
>> This would be used to count votes in a local election. There would be
>> approximately 46 precincts in the spreadsheet, and four people would have
>> identical copies on networked computers. They would enter precincts one
>> at a time as they are called in, with results for each precinct ONLY
>> being entered by one of the four operators.
>>
>> I'd then like to merge (or add them together) to get running totals.
>>
>> I hope this makes sense, and thanks for any advice.
>>
>
>

**fran1977** · 05-17-2006, 02:27 PM

Hi all,

I am new to this and need some serious help with my working life. Hope you can help.....please.

I am trying to find a way of looking up values in one worksheet to populate another...... i.e. if a certain value in column A exists in one worksheet match it to a value in a particular column in a second worksheet - then return a corresponding value in another column from one worksheet to another.

I have attempted this using IF statements between the two worksheets, however.... the values being looked for are not always present in the second worksheet. Hence it all falls apart because i'm using specific rows ( I think).
The formuls I'm using looks something like

=IF(A1=Sheet2!A1,Sheet2!B1,"None")

Hope someone can advise me on what I'm doing wrong

From a distrught and fustrated Welsh lass

Thank you in advance

**fran1977** · 05-17-2006, 02:37 PM

Just a bit I forgot, incase in can help some on help me.

In this specific task I am try to carry out all values possible exist in the first worksheet (the one I am try to populate). There will never be a value I am trying to match in the 2nd worksheet that is not in the first.

E.g.

All values exist in column A of worksheet trying to populate.

Some of these values may not be present in the second worksheet with the corresponding value I am trying to merge.

But the second worksheet will never have any additional values that don't match back to what I am looking for

Hope this maks sense

thanks again All

**fran1977** · 05-18-2006, 04:11 AM

Hi all,

I am new to this and need some serious help with my working life. Hope you can help.....please.

I am trying to find a way of looking up values in one worksheet to populate another...... i.e. if a certain value in column A exists in one worksheet match it to a value in a particular column in a second worksheet - then return a corresponding value in another column from one worksheet to another.

I have attempted this using IF statements between the two worksheets, however.... the values being looked for are not always present in the second worksheet. Hence it all falls apart because i'm using specific rows ( I think).
The formuls I'm using looks something like

=IF(A1=Sheet2!A1,Sheet2!B1,"None")

Hope someone can advise me on what I'm doing wrong

From a distrught and fustrated Welsh lass

Thank you in advance

Pete_UK · 05-18-2006, 04:45 AM

You need to use VLOOKUP( ). Assuming the data you are searching for is
in Sheet2 columns A to F down to row 250, and that the item you are
searching for is in A1 of Sheet1, then try this formula in B1 of
Sheet1:

=IF(ISNA(VLOOKUP($A1,Sheet2!$A$1:$F$250,1,0),"None",VLOOKUP($A1,Sheet2!$A$1:$F$250,2,0))

The formula can be copied down. You can also copy across, but you will
need to change the parameter 2 to suit the column number that you want
to derive the data from - you could change this to COLUMN() if you want
to get data from the corresponding column in the table.

It searches the column Sheet2!A1:A250 looking for an exact match with
Sheet1!A1. If it finds an exact match, then it returns the
corresponding data from column 2 of the table. If there is no exact
match then VLOOKUP would return #N/A - the first part of the formula
detects this and returns the word "None".

Hope this helps.

Pete

**fran1977** · 05-18-2006, 07:37 AM

Hi Pete

Thanks ever so much for the advise it is fantastic can't believe how helpful this is in my quest.

I just have anoth quick question I have tried out your suggestion and it doesn't appear to like the "None" bit for some reason. However, I have tried different things but to no avail.

May be it is a quick question you could andswer for me? please

Many Many Thanks
Fran

David Biddulph · 05-18-2006, 09:35 AM

"fran1977" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Pete
>
> Thanks ever so much for the advise it is fantastic can't believe how
> helpful this is in my quest.
>
> I just have anoth quick question I have tried out your suggestion and
> it doesn't appear to like the "None" bit for some reason. However, I
> have tried different things but to no avail.
>
> May be it is a quick question you could andswer for me? please

If it's objecting to the "None", did you remember to put it in quotes?
--
David Biddulph