Hi I'm looking to create a macro to save time in my busy schedule.
My manager has handed me the task of creating a weekly report which can take a lot of time out of my day. I have been informed that a macro would be the best choice to reduce that time, but wouldn't even know were to start...
Information
I download 3 different spreadsheets, then use filters and lookup tables to determine how many quotes have been issued by a person. I do this for 3 different stages Initial quote, design, construction.
After I have filtered and used pivot tables on all the data I take all the data and fill out a 'scorecard' with all the data I have found.
I know this is very confusing, so I will attach a sample spreadsheet to this thread.
The PROJECT No. is the most important number and is followed all the way through each spreadsheet. and the section in yellow in the scorecard is where all my information goes.
I had to remove a lot of information for security reasons, but I have left the correct length of each sheet, if this helps.
I don't even know if anyone can assist I have been looking at websites but don't find any of it helpful so just looking for a second pair of eyes to tell me if this is possible or even worth while... or how to do it lol
Thanks
Dave
Bookmarks