Merging worksheets into one

[Edward Owen]

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]

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

Or do you want to do it for worksheets

 

[Edward Owen]

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

I'll check it out! Thanks!

 

[fran1977]

Hi all,

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

I am trying to find a way of looking up values in one worksheet t
populate another...... i.e. if a certain value in column A exists i
one worksheet match it to a value in a particular column in a secon
worksheet - then return a corresponding value in another column fro
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 th
second worksheet. Hence it all falls apart because i'm using specifi
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 fastrated Welsh lass

Thank you in advance
:confused

 

[fran1977]

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]

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]

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]

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]

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?

 

[fran1977]

I have yes it's odd, but will try again

Thanks for getting back to me - will let you know
Thanks so much
Fran