Find Jobs
Hire Freelancers

VB CODE FOR EXCEL TO CREATE REPORT SUMMARY

$10-30 AUD

Completed
Posted over 5 years ago

$10-30 AUD

Paid on delivery
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

About the project

23 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$15 AUD in 1 day
4.0 (1 review)
0.0
0.0
23 freelancers are bidding on average $26 AUD for this job
User 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 in 0 day
4.9 (500 reviews)
7.5
7.5
User 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 in 1 day
4.9 (460 reviews)
7.7
7.7
User 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 in 1 day
5.0 (36 reviews)
6.7
6.7
User 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 in 1 day
5.0 (61 reviews)
6.5
6.5
User 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 in 1 day
4.9 (93 reviews)
6.1
6.1
User 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 in 3 days
4.6 (35 reviews)
5.3
5.3
User 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 in 1 day
5.0 (16 reviews)
4.9
4.9
User 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 in 2 days
5.0 (46 reviews)
4.7
4.7
User Avatar
I just did same project 2 days back. I can do it immediately.
$30 AUD in 1 day
5.0 (18 reviews)
4.0
4.0
User 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 in 0 day
4.5 (4 reviews)
2.5
2.5
User 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 in 1 day
4.8 (10 reviews)
2.5
2.5
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Excel proficient
$25 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User 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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can program in VBA. I need to use at least 100 characters so this sentence is here for that purpose.
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User 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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
kingswood, Australia
5.0
1
Payment method verified
Member since Feb 9, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.