I'm enclosing a workbook with same data for City 1 and City 2 for different companies. In sheet7, I want my required data layout structure. How do i link sheet7 with sheets City 1 and City 2 in a manner that any change in source sheets City 1 and City 2 reflect in sheet7. I don't want to use array formula to do that when i use transpose it just copy the data but not linking the data.
Last edited by leo73pk; 10-23-2017 at 07:48 AM. Reason: Solved
Best Regards,
Hamza
It is the greatest of all mistakes to do nothing because you can only do little - do what you can.
Try the following formula in C4 (Sheet7)
=INDEX('City 1'!$A$2:$K$6,MATCH(C$2,'City 1'!$A$2:$A$6,0),MATCH($B4,'City 1'!$A$2:$K$2,0))
In D4:
See the attached file.=INDEX('City 2'!$A$2:$K$6,MATCH(C$2,'City 2'!$A$2:$A$6,0),MATCH($B4,'City 2'!$A$2:$K$2,0))
I'm not looking forward to any formula. I know i can get values by using lookups and index match functions. I'm just asking about linking sheets
Your request does not make sense. Your thread title is about linking data, but then you talk about co[ying in and pasting: which is it?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have enclosed the sheet with sample data and required result in Cell range C4:F6 of Sheet7. It is being done by manually linking cells with source sheets City 1 and City 2. I just want to know that can it be done automatically without using formulas?
Only by using VBA. Shall I move the thread for you?
Removed by SA
Last edited by shukla.ankur281190; 10-23-2017 at 01:29 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Shukla - the OP has stated twice now, and very clearly, that he does not want a formula solution.
Eventually find solution by following the steps mentioned in below link:
https://excel.tips.net/T002652_Trans...d_Linking.html
As you asked for a non-formula solution, I don’t think anyone would have suggested that, but glad you have solved it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks