Payroll report macros

Tom Stockton

New Member
Joined
Dec 7, 2010
Messages
22
I work for a municipality that is starting to do our payroll estimates for next year. I would like to automate a number of functions that I do manually every time we get another payroll run to review. I'm going to attach a small file which contains a few things I try to fix first. If this works out there are a few more things we do to the file as we review and conduct "what-if" work. If you are interested in trying to fix these first few issues please let me know.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
The first thing I do is remove unwanted data. There are unwanted rows in some records (data is in the boxes I added) and unwanted data on the left side for some records. This comes from page breaks in the program where the data lives. I have filled the cells with yellow. As I see it the key pointers are the asterisks in the right column. There are 2 at the end of the record and one near the top, with two in between.

The first thing I need is a reminder of how to attach the excel file.
<o:p></o:p>
Please take a look at this and let me know what you think.

Thank you
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,122,206
Messages
5,594,832
Members
413,943
Latest member
Dhornsby21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top