Find Jobs
Hire Freelancers

VB CODE FOR EXCEL TO CREATE REPORT SUMMARY

$10-30 AUD

Slutfört
Publicerad över fem år sedan

$10-30 AUD

Betalning vid leverans
Hi I need a REPORT generated from a stock on hand. I can do this manually however I would like awesome well described code that with one click of a button will generate my report. I will give you the Stock On Hand report that I get each morning. What I want is the code that will create a new sheet and display to me all locations where there is only ONE pallet of type '3' (All this will be discussed moving forward). This list should be sorted in location order and presented cleanly. More details presented when we discuss For a well experienced programmer (I am a programmer too).....this project should take no more than half hour.
Project ID: 17497181

Om projektet

23 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
$15 AUD Om 1 dag
4,0 (1 omdöme)
0,0
0,0
23 frilansar lägger i genomsnitt anbud på $26 AUD för detta uppdrag
Använd avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$50 AUD Om 0 dag
4,9 (500 omdömen)
7,5
7,5
Använd avatar
Hello , I have read your project description and understood your requirement. I have 2.5 years experience in Excel VBA. I can complete task within time with 100% accuracy. With Regards, Bhaskar
$25 AUD Om 1 dag
4,9 (460 omdömen)
7,7
7,7
Använd avatar
Hi, This is Gopal.I am a book-keeper and accountant. I have gone through your project description and understood that it’s a data extraction and formatting work on excel. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than 5 years. Hence, I have expertise on SAP, Tally ERP9, Quick Books, MYOB, ZOHOBOOKS, XERO, MS Access, MS Word and MS Excel. Recording daily transaction or Book-keeping, Maintaining Books of Accounts, Reconciliation and finalisation of accounts are major areas of my job profile. I would like to draw your kind attention on few of my excel skills:- Maintaining and organizing data, Data Management, Data Entry. Formula development, VLOOKUP, HLOOKUP, LOOKUP, IF, INDEX, SUM. Pivot Table Development and Management Process Improvement Develop and implemented standard operating procedures to bridge data gaps and resolve related issues. Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Hence, I request you to grant me an opportunity to serve you by executing and finishing the project giving my level best and so that I could establish myself on this platform though I am new at freelancer. Looking forward for your positive response. Thanks
$25 AUD Om 1 dag
5,0 (36 omdömen)
6,7
6,7
Använd avatar
I have a lot of expertise on this kind on job, I just starting on freelancer thats why my fee is low, but my work is great
$15 AUD Om 1 dag
5,0 (61 omdömen)
6,5
6,5
Använd avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$25 AUD Om 1 dag
4,9 (93 omdömen)
6,1
6,1
Använd avatar
Hi, I am expert VBA programmer. I’ve reviewed your file and being financial analyst I am well versed with this work. Kindly share further details with me over chat. Regards Awais Jehangir
$15 AUD Om 3 dagar
4,6 (35 omdömen)
5,3
5,3
Använd avatar
Hi, I read your description and also reviewed the attached file. I will need more details regarding this "only ONE pallet of type '3'" and what it means in the attached spreadsheet. Please contact me for more details. Thanks!
$30 AUD Om 1 dag
5,0 (16 omdömen)
4,9
4,9
Använd avatar
Hi.... I'm really interested to create the report for you. Button or function from excel macro maybe will make you interested. I'm an excel and macro expert. I hope we'll discuss further. Thanks
$30 AUD Om 2 dagar
5,0 (46 omdömen)
4,7
4,7
Använd avatar
I just did same project 2 days back. I can do it immediately.
$30 AUD Om 1 dag
5,0 (18 omdömen)
4,0
4,0
Använd avatar
hi, I HAVE ALL THE SOLUTIONS FOR YOUR QUERY. I CAN HELP YOU IN YOUR PROJECT. I HAVE A GREAT UNDERSTANDING OF EXCEL. I am an expert at VBA, MACRO, FORMULA. I have 9+ years of experience. You will get the best and accurate and best services within the time frame. Thanks
$25 AUD Om 0 dag
4,5 (4 omdömen)
2,5
2,5
Använd avatar
Hi, I'm very expert with excel and VBA, I use it often to implement office automation tools. I'm interested in your project. I'd like to deepen some requirements, e.g. is the Stock On Hand report an excel file you get every day? In this case we can create a new excel file, where you load the data in a first sheet by selecting the source file and then filter the data and shows the result in a second sheet (all by pressing one or 2 buttons). About data... what is the column that identifies a location? I hope to be contacted, best regards Andrea
$20 AUD Om 1 dag
4,8 (10 omdömen)
2,5
2,5
Använd avatar
I have a great knowledge of the excel and the word. My typing speed is also very good with high accuracy and I want to believe you that I will complete your work by time and within time. * Reason for Choosing me: I believe in perfection, I might charge less but I am confident about my work and my deliverable, I don't bid if I can't guarantee 100% dedication from my side.
$25 AUD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Can you import this data into a datagridview and then filter it as you want ... I can do this in vb.net 2010 or later. Greetings, Alexandre Gonçalves
$25 AUD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Excel proficient
$25 AUD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I work with that everyday and I'm sure I can solve your problem. The 2 days to do it is due to my lack of time today. Contact me if interested.
$15 AUD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I can program in VBA. I need to use at least 100 characters so this sentence is here for that purpose.
$10 AUD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello, Do you really want to automate this, or would you consider a simpler task of adding a new column heading in "U" called "Count", then in the cell U2 enter this formula and copy it down. =COUNTIFS($A$1:$A$18447,A22,$P$1:$P$18447,3) Then add a filter and select 1. Of course it isn't as sexy as a push of a button macro solution. This I could do for you but would need to discuss in more detail before awarding the project to me. My bid of $10 is only because I don't have any history on this site and would be doing this project to really be paid by the posting of a positive review upon completion. Very best regards, Graham
$10 AUD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
kingswood, Australia
5,0
1
Verifierad betalningsmetod
Medlem sedan feb. 9, 2017

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.