Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to merge data from an Excel file into an Excel file?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Feb 5, 5:03*pm, ILoveMyCorgi
wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just tried to do this and it did not work for me. I think it's better if i
just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It should work. Tell us what you did (the steps you went through), and
provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Didn't know where to even begin. I had two worksheets -- one with data the
other with the form. I went to edit then Move or Copy Sheet, a box popped up, I selected worksheet containing the list I wanted in the form, clicked on the Create a copy box, then OK. The result is a copy of the form instead of the data being placed in the fields within the form. I thank you for your help. Susan "Fred Smith" wrote: It should work. Tell us what you did (the steps you went through), and provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, at least now you know how to copy sheets.
Now you need to tell us what you mean by "merge" sheets. What does your data look like, and what does your form look like? Regards, Fred. "ILoveMyCorgi" wrote in message ... Didn't know where to even begin. I had two worksheets -- one with data the other with the form. I went to edit then Move or Copy Sheet, a box popped up, I selected worksheet containing the list I wanted in the form, clicked on the Create a copy box, then OK. The result is a copy of the form instead of the data being placed in the fields within the form. I thank you for your help. Susan "Fred Smith" wrote: It should work. Tell us what you did (the steps you went through), and provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Excel spreadsheet set up to be a form. I need to replace columns
A2, B2, and C3 down to row 800 with new data contained in the second worksheet. I hope I am making myself clear with my explanation. "Fred Smith" wrote: Well, at least now you know how to copy sheets. Now you need to tell us what you mean by "merge" sheets. What does your data look like, and what does your form look like? Regards, Fred. "ILoveMyCorgi" wrote in message ... Didn't know where to even begin. I had two worksheets -- one with data the other with the form. I went to edit then Move or Copy Sheet, a box popped up, I selected worksheet containing the list I wanted in the form, clicked on the Create a copy box, then OK. The result is a copy of the form instead of the data being placed in the fields within the form. I thank you for your help. Susan "Fred Smith" wrote: It should work. Tell us what you did (the steps you went through), and provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, now we know what you need to do, but you haven't given us any details.
Without details, we can only provide vague answers. If you're not happy with copying the sheet, why not just copy the columns. Will that work for you? Regards, Fred. "ILoveMyCorgi" wrote in message ... I have an Excel spreadsheet set up to be a form. I need to replace columns A2, B2, and C3 down to row 800 with new data contained in the second worksheet. I hope I am making myself clear with my explanation. "Fred Smith" wrote: Well, at least now you know how to copy sheets. Now you need to tell us what you mean by "merge" sheets. What does your data look like, and what does your form look like? Regards, Fred. "ILoveMyCorgi" wrote in message ... Didn't know where to even begin. I had two worksheets -- one with data the other with the form. I went to edit then Move or Copy Sheet, a box popped up, I selected worksheet containing the list I wanted in the form, clicked on the Create a copy box, then OK. The result is a copy of the form instead of the data being placed in the fields within the form. I thank you for your help. Susan "Fred Smith" wrote: It should work. Tell us what you did (the steps you went through), and provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you for all your time; I appreciate it. I wound up just copying the
columns to the worksheet containing the form and it worked. I was worried that the formatting would go away but it did not. Thanks again. Susan "Fred Smith" wrote: Well, now we know what you need to do, but you haven't given us any details. Without details, we can only provide vague answers. If you're not happy with copying the sheet, why not just copy the columns. Will that work for you? Regards, Fred. "ILoveMyCorgi" wrote in message ... I have an Excel spreadsheet set up to be a form. I need to replace columns A2, B2, and C3 down to row 800 with new data contained in the second worksheet. I hope I am making myself clear with my explanation. "Fred Smith" wrote: Well, at least now you know how to copy sheets. Now you need to tell us what you mean by "merge" sheets. What does your data look like, and what does your form look like? Regards, Fred. "ILoveMyCorgi" wrote in message ... Didn't know where to even begin. I had two worksheets -- one with data the other with the form. I went to edit then Move or Copy Sheet, a box popped up, I selected worksheet containing the list I wanted in the form, clicked on the Create a copy box, then OK. The result is a copy of the form instead of the data being placed in the fields within the form. I thank you for your help. Susan "Fred Smith" wrote: It should work. Tell us what you did (the steps you went through), and provide more detail on what "did not work" means. Regards, Fred. "ILoveMyCorgi" wrote in message ... I just tried to do this and it did not work for me. I think it's better if i just copy the spreadsheet and paste in Word then merge from there... or is this the round-about way of doing this? "D." wrote: On Feb 5, 5:03 pm, ILoveMyCorgi wrote: Is it possible to merge data from an Excel file into an Excel file? You can place sheets into another workbook with move or copy sheets, this is located in the edit file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I merge two excel file data (no changes made to the file)? | Excel Discussion (Misc queries) | |||
How do I import and merge Excel data into a master project file? | Excel Discussion (Misc queries) | |||
using an excel spreadsheet as the data file for a mail merge | New Users to Excel | |||
I want to transfer a data base file into Excel then do mail merge | Excel Discussion (Misc queries) | |||
Word Mail Merge with Excel as data file | New Users to Excel |