Excel - transfer information from file

Andy - Apr 12, 2012 at 06:47 AM
 Andy - Apr 13, 2012 at 12:12 PM
Hi there!

I have run into some problems when transferring information from one Excel file to another. I have a big Excel file with a lot of information which I want to split into two seperate files, however, I want to keep working in the "big" excel sheet and hopefully the two other sheets will get automatically updated...

I have tried the "copy sheet" function, but this doesn't enable me to copy certain rows and columns of the "big" Excel sheet.

I hope it makes sense to you Excel wizards :-)

Looking forward to getting my hair back....


1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 12, 2012 at 10:11 PM
your requiremnts are not clear . you are uising "file" and "sheet".

how to separate the main sheet

suggest keep both the main data and split data in the same workbook but in different sheets (three sheets) so manipulation is easy

try this
in the main sheet highlight the first part to be copied
edit copy
go to the second sheet and highlight A1

similarly from main sheet to third sheet .
Thanks so much!!!!!!!