Help Using Macros to Format Summary and Statements

[rudy90]

Hi good morning.

I am looking for a bit of help with Macros. I have some basic Excel knowledge and know how to use some formulas.
I've tried to look into macros but its a bit more time consuming then I thought. I would appreciate if someone can help me out a bit.

For work I create a weekly Excel workbook.
Here I create multiple Contractor Settlement Statements over 20.
Then I have a summary sheet with the list of contractors, orders completed, gross pay, net pay, commission.

Its simple formatting, but it start getting time consuming, repetitive and annoying after a while.

I would like to create a macro that can format the summary page and individual sheets when created.
Also to have it pull info from the new sheets to the summary page.

End of year I would like to have 1 workbook per week, then pull all summary info into 1 master summary.

If anyone can help with this I would really appreciate it.
Attached are some examples of my sheets.

[PaulM100]

If your sheets format will always be the same(I am assuming that driver 1, 2 and 3 are based on sheets a, a(2), a(3)), then you can use a vlookup formula with indirect. See the file attached. B,C,E: =VLOOKUP(B$1,INDIRECT("'"&$F2&"'!"&"A:B"),2,0)
D: =VLOOKUP(D$1,INDIRECT("'"&$F2&"'!"&"G:H"),2,0)

[rudy90]

Yes correct. Wow that's awesome thank you very much for that.
I wasn't aware of how that formula worked.
So no need for a Macro for the workbook, just leave a blank template and copy for future use as needed?

[PaulM100]

Yes. And you could play with this to return the sheet names instead of typing them: https://www.howtoexcel.org/tips-and-...k-without-vba/
But you need to make sure that you have the same format everywhere. Right now, a (2) percentage will return an error, as you've change the references and your percentage is in G column

[rudy90]

Ok. I've been using this kinda format for a couple years already with a few changes here and there.
But thats cause I haven't figure out these formulas properly yet.

Yeah I was noticing that. I just fixed that.
Again thank you.
LOL I've been trying to this simple thing out for some time already. But it seemed so complex.