Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Merge to Excel from data in an Excel file

Is it possible to merge data from an Excel file into an Excel file?
  #2   Report Post  
Posted to microsoft.public.excel.misc
D. D. is offline
external usenet poster
 
Posts: 53
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Merge to Excel from data in an Excel file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Merge to Excel from data in an Excel file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge two excel file data (no changes made to the file)? Gem Excel Discussion (Misc queries) 1 January 29th 09 02:19 PM
How do I import and merge Excel data into a master project file? Sentry16 Excel Discussion (Misc queries) 0 June 11th 07 03:39 PM
using an excel spreadsheet as the data file for a mail merge pamelaClaire New Users to Excel 3 March 20th 07 05:24 PM
I want to transfer a data base file into Excel then do mail merge Jan Excel Discussion (Misc queries) 3 July 7th 06 08:58 PM
Word Mail Merge with Excel as data file HT New Users to Excel 2 July 13th 05 11:39 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"