pile-it Mark
Board Regular
- Joined
- Jan 10, 2006
- Messages
- 125
i have a workbook that i use to send trips to accounting. I have cobbled this together over many years and thought i would try to automate more of it. the data is transferred from written sheets, i just automated the math. new year new sheet, there has to be a better way.
i have asked questions on other posts concerning the relevant ideas.
the only micros i have ever used were given to me from this forum. VBA is a foreign language. i have managed with formulas to this point.
i have a master tab that i copy and add the trip information to. somewhere between 60 and 250 tabs will be added over the year. individual trips.
what i am trying to accomplish:
Cell C2 i would like to be in the Left footer of the individual tabs, this is different for each sheet
cell N4 i would like to post in the center footer. i have read the posts about the micro to do that and have tried to copy them with no success. this is different for each sheet.
i would like line 2 cells B:AE to be added to the totals pages. currently i just create links to the individual cells. this line just pulls the totals off the sheet to a common area.
i thought i could use VLookup to grab mileage off the distance tab, but i am struggling trying to search e12 and f 12 to put the distance in j22 from the Distance table B3:E318 the number is in column 4
e13 & f13 would go in k22 they wont all be filled usually.
i would appreciate any help or comments. including formula changes. i need to learn VBA
Thanks,
Mark
a copy of the workbook is located in dropbox link below.
https://www.dropbox.com/s/2w9lr6u80j0i9p6/Mr Excell test.xlsm?dl=0
i have asked questions on other posts concerning the relevant ideas.
the only micros i have ever used were given to me from this forum. VBA is a foreign language. i have managed with formulas to this point.
i have a master tab that i copy and add the trip information to. somewhere between 60 and 250 tabs will be added over the year. individual trips.
what i am trying to accomplish:
Cell C2 i would like to be in the Left footer of the individual tabs, this is different for each sheet
cell N4 i would like to post in the center footer. i have read the posts about the micro to do that and have tried to copy them with no success. this is different for each sheet.
i would like line 2 cells B:AE to be added to the totals pages. currently i just create links to the individual cells. this line just pulls the totals off the sheet to a common area.
i thought i could use VLookup to grab mileage off the distance tab, but i am struggling trying to search e12 and f 12 to put the distance in j22 from the Distance table B3:E318 the number is in column 4
e13 & f13 would go in k22 they wont all be filled usually.
i would appreciate any help or comments. including formula changes. i need to learn VBA
Thanks,
Mark
a copy of the workbook is located in dropbox link below.
https://www.dropbox.com/s/2w9lr6u80j0i9p6/Mr Excell test.xlsm?dl=0