Hi,
I have to calculate the total of a unique item listed in column E and display its total in column G for the first unique item and then make the remaining unique items with a 0 in column G
I have attached an example showing the data before runnning VBA and after VBA is applied.
Excel 2003 is being used.
Thanks for any help,
David
You can use a worksheet function to get those values
Put this in G3 and copy down as needed.
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Thanks for your help GeneralDisarray, Do you know how to put it in VBA as its part of a larger project?.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrog that's great.
Again thank you both for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks