Hello,
This is my first post.
A quick bio: I use Excel often at work. However, I only know how to do the basic arithmetic formulas. I use Excel mainly to keep track of serialized oilfield equipment which can vary from the hundreds to tens of thousands.
I often make transmittal sheets to reflect what equipment we've sent out to a customer and records of receipts of what equipment was returned from that customer.
I need to know if there's a macro I can make (or if you can help me make) to populate these serial number spreadsheets. I already have a macro setup where it would select 50 cells down, then cut. From there I would go to the other serial number sheet to paste. But it can still be time-consuming at times.
I have to put them on a template of serialized sheets of 400 serial numbers per page in order to make it look presentable. I also have to print them out to give to give to customers.
Here's what the sheet of what the file would be with all serial numbers lined up in a single column:
Here's the "serial number" sheet that I need to populate that would need to remain in a presentable fashion:
[/URL][/IMG]
Notice that each sheet is in sets of 400 serial numbers.
The first page goes from 1 to 400, the second page goes from 401 to 800. It keeps repeating itself that way.
I appreciate yall's help on this.
This is my first post.
A quick bio: I use Excel often at work. However, I only know how to do the basic arithmetic formulas. I use Excel mainly to keep track of serialized oilfield equipment which can vary from the hundreds to tens of thousands.
I often make transmittal sheets to reflect what equipment we've sent out to a customer and records of receipts of what equipment was returned from that customer.
I need to know if there's a macro I can make (or if you can help me make) to populate these serial number spreadsheets. I already have a macro setup where it would select 50 cells down, then cut. From there I would go to the other serial number sheet to paste. But it can still be time-consuming at times.
I have to put them on a template of serialized sheets of 400 serial numbers per page in order to make it look presentable. I also have to print them out to give to give to customers.
Here's what the sheet of what the file would be with all serial numbers lined up in a single column:
Here's the "serial number" sheet that I need to populate that would need to remain in a presentable fashion:
Notice that each sheet is in sets of 400 serial numbers.
The first page goes from 1 to 400, the second page goes from 401 to 800. It keeps repeating itself that way.
I appreciate yall's help on this.