Đã hoàn thành

Looking to have numbers corrected and accounted for

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.

Kĩ năng: Excel, Xử lí dữ liệu, Nhập liệu, PHP

Xem nhiều hơn: auto generate numbers excel number generated excel sheet, nice looking numbers, working project model class xi maths, describe discuss working memory model, d animations for products, d model/render 9 images for a new product, i am looking to get a working facebook page with pictures etc to promote my new website and product launch, looking for a developer working with google sheets, looking for sales reps working on commission only, 3d model d, 3d model d orbital, looking for a job working at home, looking for java developers working in germany inbox, looking for vietnamsese female working online freelancer, menmbhkn 3d model d cad 2015, geospecial object identification or analysis ? I am looking for someone to create a model for scoring density of tree and bush c, working longer than contracted hours, non working science model, john deere model d history, numbers collaboration not working

Về Bên Thuê:
( 32 nhận xét ) Lindenhurst, United States

ID dự án: #21886846

Được trao cho:

rashedkhanrubel

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.

$30 USD trong 1 ngày
(39 Đánh Giá)
4.6

27 freelancer đang chào giá trung bình $126 cho công việc này

Eagles90

Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in l Thêm

$200 USD trong 1 ngày
(169 Nhận xét)
8.1
Webxpert4u

*******PRICE NEGOTIABLE. *********I will use formulas to find and sum data of every reference. Every reference in main sales tab. And a macro to find those part # that are in original data but in main sales tab I chec Thêm

$200 USD trong 1 ngày
(318 Nhận xét)
8.1
uhjk

Hello, I can export this to .csv file and then make calculations with php and send you back. I can do in 1-2 hours at most.

$50 USD trong 1 ngày
(896 Nhận xét)
8.3
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] Thêm

$155 USD trong 3 ngày
(166 Nhận xét)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Thêm

$135 USD trong 1 ngày
(231 Nhận xét)
6.9
asadkhan3533

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

$117 USD trong 1 ngày
(164 Nhận xét)
6.6
lkhelladi

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.

$211 USD trong 1 ngày
(33 Nhận xét)
5.6
razvancotofana

Hello, I am an excel and VBA professional and I would be happy to assist you with your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Raz Thêm

$100 USD trong 7 ngày
(18 Nhận xét)
5.3
imranulhasn

Hi I am “Imranul” free here for your project and can start immediately. I read your ☑️ numbers corrected and accounted for Project description and I am confident that no one can do better than me with this project. Thêm

$250 USD trong 10 ngày
(36 Nhận xét)
5.1
rIbrarahmed

Hi, I am very good in accounting and finance having 6 years of working experience in a multinational organization. Apart from that we have a team of skilled CA, ACCA, MBA's People and all are well experienced. we done Thêm

$40 USD trong 1 ngày
(26 Nhận xét)
4.8
liujianmin

Hi, Glad to apply to your offer. I have gone through your job description in depth, and now I am sure that I can develop what you want exactly to your expectations, OR more. I have been through many frameworks that bo Thêm

$140 USD trong 7 ngày
(28 Nhận xét)
4.7
AlexeyKala

⭐ No problem ⭐ I have read your description carefully and very interesting for your project. I am sure I can give you perfect results on time and I can keep good communication with you every day, including holidays Thêm

$140 USD trong 7 ngày
(12 Nhận xét)
4.4
PixelAgeShell

Hey This is Shelley! It will be done within 3-4 hours let me know when do you want me to start ?

$250 USD trong 1 ngày
(12 Nhận xét)
4.2
ninestar801

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Thêm

$140 USD trong 7 ngày
(18 Nhận xét)
4.0
mc180400570

Hi Sir Thanks for reading of my response. I understand you need a Excel Data Entry Expert for your project. I have 12 years experience as data entry, web research, e-commerce, excel/spreadsheet, Word and social media m Thêm

$140 USD trong 3 ngày
(2 Nhận xét)
3.1
shoaibihsan

I have taken a close look at the details of your project and I am very confident that I can easily complete your project as to your requirements within 3 days. Please award me the project and I'll be on it. I look fo Thêm

$200 USD trong 7 ngày
(2 Nhận xét)
1.3
AfagGafarova

hi! I read what you need and I can help you with that. Contact for further details and send the copy of document

$55 USD trong 2 ngày
(0 Nhận xét)
0.0
nisarhussain039

Dear Hiring Manager, I have 2+ years of experience working with Ms Excel and MS Office tools. I have been doing administrative work like typing material from one source to other for long time as free lancer. I am hav Thêm

$50 USD trong 1 ngày
(0 Nhận xét)
0.0
jessilen

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.

$200 USD trong 2 ngày
(0 Nhận xét)
0.0
nurulsyahera79

Hello Sir, I am writing in response to your advertisement. After carefully reviewing the skill requirements of the job description, I feel that I am a suitable match for the job. I’ve held several data entry positions Thêm

$60 USD trong 7 ngày
(0 Nhận xét)
0.0