HI,
can anybody tell me that i have two workbooks. iand i want to synchronize data from Book1.xls,Sheet1! to book2.xls,sheet1! but i have many zones of working, i want i just get the complete data of zone A.
Zone A is shown in many cells, just get data of cells found Zone A.
Please help.
=[Book2]Sheet1!$A$1Originally Posted by sfhussain
or
=[Book1]Sheet1!$A$1
hit the = sign in sheet 1 and go to sheet2 and select a cell and then hit enter
Your title is very confusing
hi, well first of all thanks for reply, ok let me clear the scenerio when i really wantand what my title says.
I have a workbook named book1.xls
example of excel file
A B C D E
Abc Zone A Date Etc etc
Abc Zone B Date Etc etc
Abc Zone B Date Etc etc
Abc Zone A Date Etc etc
Abc Zone A Date Etc etc
now i want the complete data of book1.xls contain Zone A in my other book named book2.xls.
so how do i do this? it may use looping.
Note: Files can be provided on demand!
http://www.excelforum.com/attachment...4&d=1173865150
Has an example of filtering and copying to another sheet
you can change the destination by altering the code so it copies to another workbook
I have enlarged the area to do that in the code below, Alt F11 gets you into the VBA editor
In the example workbook enter one of these words
CHEESE
OLIVES
pickles
rice
TOMATO
in the blue cell and click the button
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks