| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 77199 | 2007-03-02 01:10:00 | Another Excel Help Please request | Greg (193) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 529272 | 2007-03-02 01:10:00 | I use Excel for monthly invoicing my customers. I use a template sheet I created. There's about six variable cells I fill in for each customer each month. But occasionaly I miss one. Is there a way to highlight the cells I need to change without that highlight appearing in the finished sheet that I email to my customers? Thanks for any help. |
Greg (193) | ||
| 529273 | 2007-03-02 02:28:00 | I'd have a macro using InputBoxes to grab data and input into the correct cells. That way you won't be missing any cells. Example below: Sub MacroName() info1 = InputBox ("Entry1:","Entry1 Title") info2 = InputBox ("Entry2:","Entry2 Title") With Worksheet("enter sheet name here") .Range("A1") = info1 .Range("D5") = info2 End With End Sub Substitute "enter sheet name here" with the name of the sheet (obviously) Substitute "A1" / "D5" with the cell reference(s) you wish to enter the information into. Repeat the inputbox and range lines for each cell you need to insert information for. |
Antmannz (6583) | ||
| 529274 | 2007-03-02 09:19:00 | You could use Format > Conditional Formatting.... to high light the cell until you enter data into it. | Rob99 (151) | ||
| 1 | |||||