Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi,
I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi jeanmarie711
Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi ROn,
Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi jeanmarie711
See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi Ron,
Thank you for you answer. However, I do have one more question. I saw the post above mine you responded to titled "Gather data from multiple excel files into one master." It sounds from reading that post, that we are both asking the same question, but there are different answers. Possibly, I am confusing workbook/worksheets? I am assuming they are filling out a worksheet, since there is only one spreadsheet being filled out? Can you explain further? Thank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
A Excel workbook can have one or more worksheets.
If you say worksheets then my answer to you is correct if you have four different workbooks see my reply in the other thread -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi Ron, Thank you for you answer. However, I do have one more question. I saw the post above mine you responded to titled "Gather data from multiple excel files into one master." It sounds from reading that post, that we are both asking the same question, but there are different answers. Possibly, I am confusing workbook/worksheets? I am assuming they are filling out a worksheet, since there is only one spreadsheet being filled out? Can you explain further? Thank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi Ron,
THank you for taking the time to answer my questions. I actually just sat with the person that is requesting help and realized that I misrepresented what they were asking for. We actaully want to take seperate spreadsheets {worksheets} and merge into seperate tabs into one master workbook. I would like each tab to be labeled by the manager/role they are covering {some mangers cover different rolls and have seperate tabs for each roll, meaning seperate spreadsheets also}. Seeing as though each worksheet will be merged into each sererate tab, will it make a difference how each manager has it set up? Each job roll has differnt requirements and some are in fact different, but I don't think this will matter. Let me know if you need more information. Thanky ou, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
If I understand you correct
You have a few workbooks and want to copy all worksheets in this workbooks into a new workbook Correct ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi Ron, THank you for taking the time to answer my questions. I actually just sat with the person that is requesting help and realized that I misrepresented what they were asking for. We actaully want to take seperate spreadsheets {worksheets} and merge into seperate tabs into one master workbook. I would like each tab to be labeled by the manager/role they are covering {some mangers cover different rolls and have seperate tabs for each roll, meaning seperate spreadsheets also}. Seeing as though each worksheet will be merged into each sererate tab, will it make a difference how each manager has it set up? Each job roll has differnt requirements and some are in fact different, but I don't think this will matter. Let me know if you need more information. Thanky ou, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi Ron de Bruin,
Yes. I want to merge the seperate workbooks, each containing at least one worksheet, into one workbook. I would like each worksheet to still remain its own and am not looking to merge them all into one worksheet. I hope this is more clear. Thank youi, Jeanmarie "Ron de Bruin" wrote: If I understand you correct You have a few workbooks and want to copy all worksheets in this workbooks into a new workbook Correct ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi Ron, THank you for taking the time to answer my questions. I actually just sat with the person that is requesting help and realized that I misrepresented what they were asking for. We actaully want to take seperate spreadsheets {worksheets} and merge into seperate tabs into one master workbook. I would like each tab to be labeled by the manager/role they are covering {some mangers cover different rolls and have seperate tabs for each roll, meaning seperate spreadsheets also}. Seeing as though each worksheet will be merged into each sererate tab, will it make a difference how each manager has it set up? Each job roll has differnt requirements and some are in fact different, but I don't think this will matter. Let me know if you need more information. Thanky ou, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Excel Worksheets
Hi jeanmarie711
There is a example in the download on this page http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi Ron de Bruin, Yes. I want to merge the seperate workbooks, each containing at least one worksheet, into one workbook. I would like each worksheet to still remain its own and am not looking to merge them all into one worksheet. I hope this is more clear. Thank youi, Jeanmarie "Ron de Bruin" wrote: If I understand you correct You have a few workbooks and want to copy all worksheets in this workbooks into a new workbook Correct ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi Ron, THank you for taking the time to answer my questions. I actually just sat with the person that is requesting help and realized that I misrepresented what they were asking for. We actaully want to take seperate spreadsheets {worksheets} and merge into seperate tabs into one master workbook. I would like each tab to be labeled by the manager/role they are covering {some mangers cover different rolls and have seperate tabs for each roll, meaning seperate spreadsheets also}. Seeing as though each worksheet will be merged into each sererate tab, will it make a difference how each manager has it set up? Each job roll has differnt requirements and some are in fact different, but I don't think this will matter. Let me know if you need more information. Thanky ou, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 See http://www.rondebruin.nl/copy2.htm Or on MSDN http://msdn.microsoft.com/en-us/library/cc793964.aspx Download the example workbook to test -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi ROn, Each of them will be filling out their own worksheet. THank you, Jeanmarie "Ron de Bruin" wrote: Hi jeanmarie711 Workbooks or worksheets ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jeanmarie711" wrote in message ... Hi, I have a spreadhsheet for training compliance that will be filled out by 4 different managers and they will be logging the compliance for their respctive employees. I want to create something that will allow us to quckly merge each of these spreadsheets into one. What is the easiest, quiest way to handle this situation so that if their manager would like to do this, they will have the capability without alot of extra work and direction. Each spreasdsheet will be set up with the same headers. Thank you, Jeanmarie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Two Worksheets | Excel Worksheet Functions | |||
merging worksheets | Excel Discussion (Misc queries) | |||
Merging worksheets | Excel Discussion (Misc queries) | |||
Merging worksheets | Excel Worksheet Functions | |||
Merging worksheets | Excel Discussion (Misc queries) |