microsoft excel, organize and combine rows and their values
$10-30 USD
Paid on delivery
The attached excel file represents inventory forecasted to be needed for our sock company. The problem is, there is variants organized by 3 pairs, 6, 9, 12, and 15 pairs. Each has its own row for each SKU, and each row has an EST value. We need to consolidate the rows and combine the EST, but the EST need to be multiplied based on pairs (i.e. 12 pair black Large socks has EST that needs to be multiplied by 4 before it is added to the 3 pairs row and consolidated - the the 12 pair row would be deleted)
We want the end doc to have all EST values consolidated and the 3,6,9,12, 15 pair rows consolidated into the 3 pair rows (with correct multiplication of EST value before its added back to the 3 pairs)
Please provide a sample so I can see if you understand what needs to be done
Project ID: #24631767
About the project
Awarded to:
Hello, I didn't make an example, but I fully understand your request and I am proficient with Excel and VBA. I would love to help with this project. Please contact me for more information.
14 freelancers are bidding on average $26 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hello, I’m from Vietnam with a lot of experience in Excel and data entry. I have combined items and updated EST values already. Let’s discuss if you’re interested. Duong
Hey there! I’m an excel expert and I can complete the excel sheet according to your requirement with 100% accuracy. Send me a message so we can tall about this and I’ll send a sample as well. Regards, Ravindu
Hello there This is Kader and I understand what you want. So please message me for good work and I will finish it in some hours. Thanks
Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see my work in the profile --------------------------------------------------- More
Hi I read your project and understand the file has an formula error. Please give me the project and I will do this end product with alot The formula that can calculate theyour exact value of EST
Dear Sir, I am particularly interested in this job as I believe it will give me a great experience. With fast and good interpersonal, analytical and presentation skills, I am a great candidate for this job, with my q More