Käynnissä

Query Excel Sheet - Excel Expert Needed

I have an excel sheet which contains orders with stock availability. You need to create a query which finds products with high not in stock volume and puts this information within the excel sheet.

See attached [url removed, login to view] for reference:

A - Query taken from 'Old' Worksheet

B - Option to select which lines to query (e.g. Line 4080 - 4117)

C - Finds all rows with 'Not in Stock' or 'Incompleted' in Column F

D - Finds the products highlighted red in Column E, regardless of size (e.g. AJ4-20(10) where 10 is the size) - When highlighted Red, it means the item is not stock.

This information queried should be put on a new worksheet within the Excel file. See [url removed, login to view]

Product - Which Product was found Not in Stock

Not in Stock - How many times found Not in Stock

Lines - Which rows on the 'Old' Worksheet is the product shown not in stock

The resulting information should order the products found Not in Stock the most at the top. (e.g. Products found not in stock 10 times should be higher then products found not in stock 8 times)

If you are confident you can create this for me please make your bid. If you can create it before you bid and show screenshots to show it in action, it is more likely I will select your bid as the winner immediately, price depending.

Thank you!

Taidot: Excel

Näytä lisää: top query, n query, me excel, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, how can i expert in excel, file excel expert, expert with excel, excel 0 to expert, new excel, how to be expert in excel, excel sheet expert, sheet, price excel, need a excel expert, line sheet, jpg to excel, Expert Excel, EXCEL SHEET , excel sheet an, excel expert, d sheet, create excel worksheet

Tietoa työnantajasta:
( 22 arvostelua ) New York, United States

Projektin tunnus: #516111

Myönnetty käyttäjälle:

svet63

VBA developer since 1997. Can do. Regards, Svet.

65 $ USD 1 päivässä
(51 arvostelua)
6.3

28 freelanceria on tarjonnut keskimäärin 59 $ tähän työhön

vserv

Hi, Please see your PM

30 $ USD 5 päivässä
(57 arvostelua)
5.7
agihcam

Please refer to PMB.

50 $ USD 1 päivässä
(38 arvostelua)
5.1
DrTech76

Hi, a little chat maybe? Thank you. Regards, DrTech76

80 $ USD 0 päivässä
(23 arvostelua)
4.6
pyazlm

Better check PMB.

30 $ USD 1 päivässä
(30 arvostelua)
4.4
ranbir123

Pls check the PMB.

80 $ USD 0 päivässä
(12 arvostelua)
4.4
mahfuzmurshed

Please see PM.

30 $ USD 0 päivässä
(46 arvostelua)
4.1
nmppatel

I am a VBA expert, I have very good experience with EXCEL VBA macros. I have completed many projects on GAF in EXCEL skill. I will provide quick & professional service.

30 $ USD 1 päivässä
(9 arvostelua)
3.7
bkragul

Hi, Please check your PMB..

30 $ USD 0 päivässä
(8 arvostelua)
2.9
monica365

Hi, This can be achieved creating a macro in MS Excel. Thanks! Monica

30 $ USD 3 päivässä
(3 arvostelua)
2.7
skujuira

Dear Mr./Ms., North America graduated and Microsoft certified professional. Please refer your PMB. Regards

110 $ USD 3 päivässä
(2 arvostelua)
2.7
Abikris

Hi, Check your PMB please. Kris

30 $ USD 0 päivässä
(5 arvostelua)
2.5
codezero786

check your PMB

30 $ USD 0 päivässä
(3 arvostelua)
2.3
SSYES

Hi, Please can you check my Private Messages Thanks.

100 $ USD 1 päivässä
(1 arvostelu)
2.0
excelmodeler

Hi I have developed similar models while working as a financial anayst. I would like to develop it for you. Thanks Manoj

50 $ USD 2 päivässä
(1 arvostelu)
1.4
ruimaxwell

Hi Please read my PM Thanks

120 $ USD 2 päivässä
(1 arvostelu)
1.0
mlov83

please check pm for 1 simple question. i can get this done for you very quickly.

100 $ USD 5 päivässä
(0 arvostelua)
0.0
tilankak

Dear Sir. This letter is to express my interest in the job position listed on above. I possess more than 6 years of experience in working with Excel and VBA. The job mentioned by you can be easily done using VBA. Lisää

50 $ USD 7 päivässä
(0 arvostelua)
0.0
milagrosmorre

show me the instruction and the file

60 $ USD 1 päivässä
(0 arvostelua)
0.0
dimp01

giv me a chance...

60 $ USD 3 päivässä
(0 arvostelua)
0.0
arielae

I would be analysing the data you have provided and will come with the answer within the next seven days

30 $ USD 7 päivässä
(0 arvostelua)
0.0