Need help for a macro to copy, paste and clear data

[Roco]

Sorry for this long explaination:

I have learned so much on this forum and have received so much help and appreciate every bit of it.

I'm here again looking for the same help that I have received so many time before.

This is a sample sheet that I work with each month for billing. I have a "clear Button" in column "A" down around cell 8&9 that clears the empty rows that are not needed. So the rows that remain each time a sheet is created could be more or less depending on the amount of data that will be on it.

Each month when I start a billing I do it on a percentage amount, which is entered in column "D" and it will show the amount completed in Column "F" that is going to be billed.

When the next month comes for the next billing I open the same file and "save as" with a new name.

Need a Macro to do this:
I copy the numbers that is in Column "H" and paste the value only in column "E" and than I clear the percentages in column "D" back to 0% before I can start a new billing. Column "I" keeps a running total of how much as been billed until in reaches 100%.

The macro would also need to do the same down below where Change Orders start.

[kev_]

This post has been deleted

[kev_]

This works but is based on following assumptions
1. looks at all rows 11 onwards
2. determines end of data by looking at columnA and finding last cell with anything in it
3. if there is a number > 0 in columnA it does what you want

Please Login or Register  to view this content.

NOTE
This macro will do bad things if you start putting anything in columnA for any of the other lines!!!