eckert1961
New Member
- Joined
- Aug 16, 2002
- Messages
- 36
Hello,
I have an Excel 2007 workbook and what I want to do is to have code that will loop through the cells in Column B, most of which are blank. When it finds a cell with text in it I want the contents to be extracted and copied to a new sheet. The next part of this would be to determine the range from the start of the search to the cell that contains the text and then do a sum of the Costs in column I.
For example: The search would begin at B7 and text would be found in B149. The range would be B7:B149. The code then would use this range but change it to I7:I149 and sum the costs in column I. Both the text and the sum would be entered in a new Sheet.
Test $12,000.00
Once entered I would need the code to continue on to the end of the data in Sheet1.
Any assistance would be greatly appreciated. Thank you.
Regards,
Chris
I have an Excel 2007 workbook and what I want to do is to have code that will loop through the cells in Column B, most of which are blank. When it finds a cell with text in it I want the contents to be extracted and copied to a new sheet. The next part of this would be to determine the range from the start of the search to the cell that contains the text and then do a sum of the Costs in column I.
For example: The search would begin at B7 and text would be found in B149. The range would be B7:B149. The code then would use this range but change it to I7:I149 and sum the costs in column I. Both the text and the sum would be entered in a new Sheet.
Test $12,000.00
Once entered I would need the code to continue on to the end of the data in Sheet1.
Any assistance would be greatly appreciated. Thank you.
Regards,
Chris