I have an excel sheet with sales data that I had sorted and summed. The data got corrupted so I need osmeone to go in and retabulate the "Main Sales tab".
I want the raw data from the "Original data" tab, only date range 9/2/2018-9/3/2019 represented on the "Main sales tab" page.
The columns on the "Original data" tab are column G - vendor part # and column F [login to view URL] is the only data I want represented on "Main sales tab".
When you look at the Main sales tab you will see the data is organized in two area. All of the data should be in the section below V127 Door totals. This should be all of the "Vendor part #'s" sorted by product type from the original data tab. I need all of these numbers repopulated with new totals from the original data tab because I no longer know what products are accurate or not. Then I need the data to also show up next to the Vendor part # in column D.
So the data under V127 should be every model number from the Origianl data tab while the data in Column D6 through F116 is a summary of some of the vendor part numbers on the list.
So this project is to give me corrected quantity/ sales numbers for each vendor part #.
If there are any vendor part numbers that do not show up on my list in the main sales page they should be put onto the tab "missing vendor part #'s" I will determine what to do with them after. These items that go onto this tab should have all of the info in the row on the "Original data" tab.
I am lookin gto have this back very quickly as I need to be working on it.
Hi, I have understand the project requirement & interested to organize the numbers and summary for this project. I will do it within 1 hour. Please send a message so we can discuss more & start the project. Thanks.
27 freelanceria on tarjonnut keskimäärin 126$ tähän työhön
Please review my profile as I have relevant skills and experience required for this project. Kindly send me a message to discuss further details. Thanks, Asad khan
Hello, I'd be glad to process the excel data as per your requirements. Iam ready to start working right now for faqt delivery. Looking forward to chat with you soon for more details. Best regards.
I am very efficient at scripting and can write a script to re-adjust the data as you need. It will take me around a day to write the script and that will sort it all out.