Please see attachment.
Looking for a formula to put in the Summary sheet Column A, that looks at Column A amounts in Sheet1, 2 & 3. Puts them in this Summary sheet in Column A. If there are duplicates the amounts will not be included in the Summary sheet.
Please see sheet 1 and 2 on the attached. I believe this can be modified to fit your needs.
Xx7, I'm open to correction, but I don't think you're going to get a formula to operate across multiple sheets like that. Is copying/pasting the data from each of the Column As to the Summary sheet, then using Excel's functions to remove the duplicates a runner?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Run this code in your workbook.
The code with an ' is not running (and are not neccessary for your question).
Please Login or Register to view this content.
Last edited by oeldere; 06-06-2013 at 02:38 PM. Reason: change text
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.
For me personally I would use VBA since who knows you might have more than 200 tabs
Please Login or Register to view this content.
Great, thanks! I will use VBA. Didn't know this existed..
Please Login or Register to view this content.
You could change the red text in e.g.
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