I have specific values within a large number of worksheets. Each worksheet is in a unique file.
I would like to be able to copy each of these values (one at a time) and drop (paste) them in the same cell in a new worksheet. Each time I paste the new value, I want to add it to the previous value I dropped there. So if I dropped 1, 2, 3, 4 in the same cell, I want the sum (10).
Is there a way to format the cell to accomplish this .... or will I need to manually sum?
Thanks!!
I would definitely want to see some sample workbook(s) and some expected output from the action (ie- before action, after action) before I could offer any useful formula for this, BUT, I expect you will need VBA to accomplish what you are describing..
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks