Cell A2 is a product description. Cell B3:B5 contain the individual transactions, B6 is the total of B3:B5. I would like the totals (B6) to calculate in a cell adjacent to A2 (description). The problem is the data extracted is an inconsistent number of rows; sometimes it is 2 rows with a total and sometimes it is a single row without a total. My file is extracted from another program.
I've attached a sample workbook. The cells referenced above do not refer to the cells in the workbook.
Hi, welcome to the forum
OK then sorry, but I just have to ask...if they dont refer to your sample, why even include them? Why not make the references match what is in the file - because from your file, I have no clue what you are trying to achieveThe cells referenced above do not refer to the cells in the workbook.
Have you looked at using Subtotals...Data/Outline/Subtotals
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, welcome to the forum
OK then sorry, but I just have to ask...if they dont refer to your sample, why even include them? Why not make the references match what is in the file - because from your file, I have no clue what you are trying to achieveThe cells referenced above do not refer to the cells in the workbook.
Have you looked at using Subtotals...Data/Outline/Subtotals
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-form...ent-cells.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks