Hello all I have 2 spreadsheets one titled KEENEYS This one contains all of the information that needs to go onto the other one titled Postage OFFICE SUPPLIES. What I need a a simple 1 click solution for transporting all of the information from the KEENEYS to the other spreadsheet. Then calculate all of the totals. This may require a total redesign. Currently the way I do it is manually on the OFFICE SUPPLIES work sheet go into each individual tab and type in the items from the KEENEYS spreadsheet that is calculated to go to the front page (OFFICE SUPPLIES TAB). I would like a macro set up to do this for me. I need each tab entered into the Macro. However some months we do not have supplies for each department so if the department does not have any supplies I would like the macro to simply skip it. I mention this because Macros I have set up before will stop in the middle of the process if something is missing.
All of the information currently on the spreadsheet is from Febuary so when you test and play around with this please erase all of that information and at the end of everything I need the totals from the KEENEYS spreadsheet to match the totals from the OFFICE SUPPLIES SPREADSHEET. Please pay no attention to the POSTAGE TAB no work needs to be done on that one.
I am not sure if this can be done but it would be nice if instead of having 15 different tabs to have the OFFICE SUPPLIES TAB/POSTAGE TAB and then 1 more tab that contains all of the individual department data BUT have each department able to be selected from a drop down menu. OR if it is simplier to be able to easily hide/view all of the tabs except OFFICE SUPPLES and POSTAGE. If you need any further clarification please advise me.
*Please note that on the Office Supplies Tab row 24D titled PLUG the information that goes into this is from the department GENERAL OFFICE & SUPPLY CABINET on the KEENEYS spreadsheet.
Please be advised this project will go to the person with the BEST PRICE and can prove to me that they know what they are doing.
Need this done ASAP I think this is a small enough project that can be done under $30 however thats the minimum that I am able to select.