azulsky1229
New Member
- Joined
- Jun 8, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- Mobile
Say I have an invoice template and data sheet in one workbook. And I would like to link service date with client name and amount all from same row to the invoice automatically. How would I
1. link 3 cells (not necessarily consecutive) from the same row so they move/update together. Like Joe Blow reschedules from 5-4-21 to 5-29-21 and the amount he’s gonna pay for that service has also changed.
2. I’d like to be able to update/change the info on my data sheet and have it reflect on the invoice automatically.
I’m new to excel, doing HighlightRow vba is the most complicated thing I’ve done so far. So please be very specific.
1. link 3 cells (not necessarily consecutive) from the same row so they move/update together. Like Joe Blow reschedules from 5-4-21 to 5-29-21 and the amount he’s gonna pay for that service has also changed.
2. I’d like to be able to update/change the info on my data sheet and have it reflect on the invoice automatically.
I’m new to excel, doing HighlightRow vba is the most complicated thing I’ve done so far. So please be very specific.