Excel Custom Function/Macro/Script

Here's what I'm looking at. Check out the image first.

Part Number FONHAND QTYREQD Job Number DATE Allocation Job Number 2

01-3059B 5 2 5973 8/15/2018 2 5973

01-3059B 5 2 5974 8/15/2018 1 5974

01-3059B 5 2 5986 7/30/2018 2 5986

01-3059B 5 1 6393 9/6/2018 0 6393

Column 1, Part Number 01-3059B has 5 Quantity ON HAND (FONHAND Column 2). However, different quantitites are required on different job numbers. So, from Column 3, we can see that there are 7 quantities (2+2+2+1) required on 5973, 5974, 5986, 6393.

So, if there're 7 QTYRQRD while 5 FONHAND, we're short by 2.

I want you to write a custom Macro or a custom excel function which does that for me.

What I want Excel to do is, sort the QTYREQRD by DATE, and allocate them by First Come First Serve.

For example that we have here, Job Number 5986 required (QTYREQRD) 2 of these parts on July 30th, 2018, so, I want to Allocate 2 quantities first to that job. After that, I'll have just 3 remaining (while required would be 5).

So, I'll move to next DATE which is 8/15/2018 on both 5973, 5974. So, allocate 2 to 5973 and 1 to 5974 (or vice versa, doesn't matter if they've the same date). And finally allocate 0 (as we've 0 on hand after previous allocations) to Job 6393.

Final result should look like last 2 columns (Allocation & Job Number 2).

Beceriler: Veri İşleme, Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: excel macro script reference, macro script excel, macro script update database excel, excel top ten macro script visual basic, vba macro script difference excel, excel macro script insert data spreadsheet, php excel macro script, free macro script excel, macro script excel example, sample macro script excel, excel macro script sample, excel macro script comments, perl macro script excel, macro script excel tutorial, excel macro script, excel cut paste using macro script, macro script insert cells excel, read excel macro script, excel auto enable macro script, excel custom email macro

İşveren Hakkında:
( 1 değerlendirme ) Clarion, United States

Proje NO: #17579171



Hi, This will be the easy macro for a experienced user. I will develop function, which when run will ask you to select the input file. Once file selected, it will perform operation and leave file with required out Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(233 Değerlendirme)

Bu iş için 11 freelancer ortalamada $30 teklif veriyor


Hi, Had a look at the example provided. Shall deliver the Excel macro meeting your requirement within a day. Kindly confirm and provide sample file. Cheers, Arul

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(217 Değerlendirme)

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(134 Değerlendirme)

Hello, I am proficient with Excel and VBA and would love to help you with this project. I checked the image and I understand what you need. Please contact me for more information.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(133 Değerlendirme)

Hi, Being experienced in working on several excel related projects for functions/macro etc. and related tasks, i can help you with script you need for working on parts, quantity as per your description. Waiting f Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(80 Değerlendirme)

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(64 Değerlendirme)

i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me for [login to view URL]

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

Hi, I am VBA Developer...Expertised in VBA Macros & Web Scraping I can Scrape Any Website..either static or dynamic also i will finish any web scraping & Excel macro task in 1day only & also experianced in ecomme Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

Hy Sir, I am an excel Macro Expert. I have read your description and I want to work for you. Details can be discussed in Inbox. Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

Hey, I have completed Advance excel, SQL & VBA & this is my day to day work, i would like to complete this project please give me chance to help here.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

I am very experienced in Excel, macros, and VBA. I'd be glad to help you with this project. I'd like to get a bit more information about the project first and I can detail how I can be of help to you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)