Forum Discussion
Fill question
Might I be so bold as to suggest that what you appear to have is a poor design to begin with, so it might be a mistake to do more to extend that poor design.
It's hard to be sure, but you might be making a common mistake here, trying to do on one sheet, in one area of that one sheet, three essentially different parts of data processing:
- Input
- Calculation or processing
- Output
So before you go any further, would you be willing to put this all into the bigger picture, perhaps even (since you have made-up names in your sample) share the workbook and let us see the full context and make suggestions. At the same time, describe the overall purpose for collecting this data in the first place. Is this aimed at creating bills or invoices? Tracking payments against those bills/invoices? etc.
Post a copy of that workbook here at the bottom of a message box. Here's what you should see if/when you reply here with the full edit feature, and you can drag or drop here.
Or put it on OneDrive or GoogleDrive and paste a link here that grants access.