reptilematt
New Member
- Joined
- Nov 23, 2009
- Messages
- 2
Revised title: "Trying to make Macro to automatically fill cells from seperate column, print, then loop with next consecutive values from seperate column."
Hi,
I have an "automated" billing system that I made with =INDEX and MATCH functions.
There are 4 spreadsheets:
1. "Bill"
2. "Tenants"
3. "Electricity
4. "Graph"
Sheet 1 "Bill" has 2 sperate bills per page with an input box for each bill that allows the user to type in a specific apartment number and have the system fill the rest of the information (ex. names, electricity use, price, etc).
I'm trying to write a Macro to have the computer automatically fill the two cells, PRINT, then loop to fill the cells with the next consecutive values from a seperate column/table.
Is something like this possible without having to use the Record mechanism? I can do it with Record, but I have to go through 300 or more bills!
Any help would be appreciated.
Hi,
I have an "automated" billing system that I made with =INDEX and MATCH functions.
There are 4 spreadsheets:
1. "Bill"
2. "Tenants"
3. "Electricity
4. "Graph"
Sheet 1 "Bill" has 2 sperate bills per page with an input box for each bill that allows the user to type in a specific apartment number and have the system fill the rest of the information (ex. names, electricity use, price, etc).
I'm trying to write a Macro to have the computer automatically fill the two cells, PRINT, then loop to fill the cells with the next consecutive values from a seperate column/table.
Is something like this possible without having to use the Record mechanism? I can do it with Record, but I have to go through 300 or more bills!
Any help would be appreciated.