Dear All,
I need a code wherein if you enter the data in the column D named as "Data" in the sheet Abc, the same data should be displayed in the column H named as "Data" in the sheet named Xyz.
Both the sheets have Id's in common but not in the same order.
I have attached the spreadsheet for the same, please help me on this.
Regards,
Chiru
In H8 Cell of Xyz sheet
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi,
Thank you for your reply.
I dont want the formula to be displayed in the H8 Column of Xyz sheet, i want the data to be displayed in the formula bar instead of formula.
Can you please help me on this.
Regards,
Chiru
Hi Chiru
I've added a Dynamic Named Range to Sheet Xyz. This Code is in Sheet Abc Sheet Code Module. It appears to do as you require. Let me know of issues.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Dear Jaslake,
Thank you so much for the help.
The code which you provided is working fine when you enter any data in abc sheet its reflecting in the xyz sheet.
But if you delete the data which you entered in the sheet abc, its not reflecting in the sheet xyz. I basically add or delete the data in the sheet abc the same should be reflected in the sheet xyz.
Can you please help me on this.
Regards,
Chiru
Hi Chiru
Are you referring to deleting an entire row or are you referring to clearing contents?
clearing the contents
Hi Chiru
This works (in a fashion). You'll need to break it and then tell me how you broke it so we can write Code to fix how you broke it
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