Hello,
I would like to combine sheet1 and Sheet2 into a Master Data sheet called SUMMARY.
I have common data between both Sheets in column A.
I would be glad if you guys could help me. I've attached my project.
thanks
Hello,
I would like to combine sheet1 and Sheet2 into a Master Data sheet called SUMMARY.
I have common data between both Sheets in column A.
I would be glad if you guys could help me. I've attached my project.
thanks
See if this is what your up to.
run the macro AddAllDataOnTheFirstSheet()
the pivot table will automatic refresh
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.
Thank you so much, but I want the data in sheet "SUMMARY" to look like in the attached file.
so data in the columns (D,E) is from sheet1 , data in the columns (A,B) is from sheet2 and the data in the column C is the common data.
and what are you gonna do if you have the data like you showed?
Count it / compare it / print it?
how do you see in the summary sheet which data is from which sheet?
I just want to print it that why.
I dont need the sheet name. I will have other data to add later if the print out will be the way I am asking.
I already know that columns (D,E) is from sheet1 , columns (A,B) is from sheet2
I can't help you enough with that.
Its okay. thank you for trying.
Anyone can help???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks