I have several worksheets cont6aing the same table and the same information but each worksheet represents a different clinic. tach worksheet is one agency. I need to create a summary table of only one questions (questions 9). Is there a way to set up a reference code to make the same cell across worksheet in my final table. Something like F4. The last worksheet is the table I want. Any thoughts?
Thank you,
Marvin
With an macro to consolidate the data on the consolidated sheet.
After that a filter on question 9.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This is great! thanks.. but I need the entire number of the clinic. That is the title of thetables. ex 0307 REGION IV-STDRHPTTAC. How can I do this. Thanks in advance...
you could make (once) a VLookup table on sheet1 with all (full) names.
After that you can use VLookup on the consolidated file.
Notice: you get merged cells in your file !!
I dont know how to do this. Can you help me?
See the attached file.
With VLookup.
Thank you so much! I appreciate it!
Thanks for the reply and rep.
Glad I could help.
If your problem is solved, will you mark it as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks