Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging worksheets into one
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. |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging worksheets into one
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging worksheets into one
No, I meant individual spreadsheets, but typed worksheets in the subject
line by mistake. I'll check it out! Thanks! "Ron de Bruin" wrote in message ... 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" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
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 fastrated Welsh lass Thank you in advance -- fran1977 ------------------------------------------------------------------------ fran1977's Profile: http://www.excelforum.com/member.php...o&userid=34540 View this thread: http://www.excelforum.com/showthread...hreadid=543008 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
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 ------------------------------------------------------------------------ fran1977's Profile: http://www.excelforum.com/member.php...o&userid=34540 View this thread: http://www.excelforum.com/showthread...hreadid=543008 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
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 ------------------------------------------------------------------------ fran1977's Profile: http://www.excelforum.com/member.php...o&userid=34540 View this thread: http://www.excelforum.com/showthread...hreadid=543008 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
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 -- fran1977 ------------------------------------------------------------------------ fran1977's Profile: http://www.excelforum.com/member.php...o&userid=34540 View this thread: http://www.excelforum.com/showthread...hreadid=543008 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
"fran1977" wrote in
message ... 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging worksheets into one
I have yes it's odd, but will try again Thanks for getting back to me - will let you know Thanks so much Fran -- fran1977 ------------------------------------------------------------------------ fran1977's Profile: http://www.excelforum.com/member.php...o&userid=34540 View this thread: http://www.excelforum.com/showthread...hreadid=543008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Worksheets | Excel Discussion (Misc queries) | |||
Merging of Worksheets | Excel Discussion (Misc queries) | |||
Merging multiple worksheets | Excel Worksheet Functions | |||
Merging multiple worksheets into one, with ongoing data entry | Excel Discussion (Misc queries) | |||
Keep Format After Merging Worksheets Using CopyFromWorksheet Macro | Excel Discussion (Misc queries) |