microsoft excel, organize and combine rows and their values

Inaendelea Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua
Inaendelea Kulipwa wakati wa kujifungua

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

Excel Kutengeneza Data Microsoft Office Visual Basic Uingizaji Data

Kitambulisho cha Mradi: #24631767

Kuhusu mradi

14 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

vlayausa

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.

$30 USD kwa siku 1
(Maoni 146)
5.9

14 wafanyakazi huru wanazabuni wastani wa $26 kwa kazi hii

P0L

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.

$30 USD kwa siku 1
(Maoni 381)
7.5
hdlan

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

$15 USD kwa siku 1
(Maoni 44)
6.3
RavinduJayzz

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

$30 USD kwa siku 1
(Maoni 49)
6.0
abdulkarim97

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

$30 USD kwa siku 1
(Maoni 22)
4.6
AhmedRagab321

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 --------------------------------------------------- Zaidi

$20 USD kwa siku 1
(Maoni 3)
2.4
jinug

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

$30 USD kwa siku 1
(Maoni 0)
0.0
ukb31

Hi there, I have read your project description and I am interested in your project, I've 4 Years Experience doing all these stuff. I will provide you 100% satisfaction with unlimited revisions. So, Just hit the chat b Zaidi

$10 USD kwa siku 7
(Maoni 0)
0.0
litanababan98

Saya pernah menjabat sebagai sekretaris di beberapa even.

$30 USD kwa siku 1
(Maoni 0)
0.0
sultanmahmud416

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 Zaidi

$15 USD kwa siku 1
(Maoni 0)
0.0
wamweni

If you’re looking for accuracy and efficiency ,I’m your girl!

$25 USD kwa siku 1
(Maoni 0)
0.0
ekarabel

Hi I am a data analyst working for data analysis project in Melbourne. Lastly, I made a analysis on family violence and collected a huge amount of data from different sources some of which are confidential. By using th Zaidi

$20 USD kwa siku 1
(Maoni 0)
0.0