joeny0706
02-15-2019, 09:19 AM
I think this will be an easy macro for someone to create I am just running out of time to research because my boss has me wanting to complete ten task at once.
If anyone wants to help I would very much appreciate it.
I need vba code to rename the sheet to "input" and also row one to match the below. They need to be two separate macros. I need to name thesheet before my other macros run then I need to name the rows after the othermacros run. I already have 8 macros to run with this but they require the sheet and row one to be named correctly. I have just been doing it manually. I am creating this so when I leave this job others will be able to complete the task with as lite steps as possible.
I need row one to be
Invoice Date
Invoice Number
Account Name
Item
Qty
H) Discount Price
I) line class
J) class
K) template
again thanks
If anyone wants to help I would very much appreciate it.
I need vba code to rename the sheet to "input" and also row one to match the below. They need to be two separate macros. I need to name thesheet before my other macros run then I need to name the rows after the othermacros run. I already have 8 macros to run with this but they require the sheet and row one to be named correctly. I have just been doing it manually. I am creating this so when I leave this job others will be able to complete the task with as lite steps as possible.
I need row one to be
Invoice Date
Invoice Number
Account Name
Item
Qty
H) Discount Price
I) line class
J) class
K) template
again thanks