So here what im trying to do.
When a number is entered into the "Quantity" column on any given sheet, i want the entire row from which the number is entered to be placed onto the "total sheet", which i plan to have set up as a print page. Could anyone help?
Where on the total sheet should the data be copied?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for the reponse. I actual found a code that works exactly the way i want it to.
Please Login or Register to view this content.
Now im trying to find a way to sum up the numbers in column "F" on the "total sheet" for duplicate items in column "B".
See attached
Ive tried using a pivot table, but im not having any luck.
Last edited by davesexcel; 03-01-2012 at 09:34 PM.
Did you try using subtotals?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks