In Progress

Need an Excel VBA for simple box inventory list

Need a simple Excel VBA. Using Excel 2010.

This Excel spreadsheet is used to inventory paper files that are stored in boxes.

First the application must look at column D and E in the attached ‘InBox’ sheet. These represent two different box numbers. It needs to make sure the SKP Num and Box Num change numbers at the same time, on the same row. These numbers will NOT necessarily be in numerical sequence. If there is an instance where the numbers change on different rows, then an error message of sorts needs to prompt me where (what row) the error is occurring. (I will manually go in and make the correction myself.) And if all numbers (SKP Num and Box Num) change numbers at the same rows, then proceed to the next step.

Next it should write onto a new sheet the unique numbers, SKP Num along with it’s corresponding Box Num. See example on BoxInformation sheet. Then, next to the unique box numbers should be written the first file in the box and the last file in the box – both on the same row as its corresponding box numbers. I’ve yellow highlighted the first file and last file information on the InBox sheet for your reference.

Please ask me if you have questions. Hopefully, I explained this simple project well.

Debbie

Skills: Data Processing, Excel, Visual Basic for Apps

See more: need excel vba simple box inventory list, excel vba inventory application, inventory vba, inventory excel vba, write paper for me, i need a paper written, ask excel, excel vba inventory sheet, what is vba in excel, what is vba, vba time, vba for, vba error, me vba, excel vba with, excel vba and, excel 2013 vba, vba e, VBA and excel, simple excel, project on vba, excel/vba, excel inventory, data correction, d box

About the Employer:
( 6 reviews ) Lockhart, United States

Project ID: #4239842

Awarded to:

Gooroo

*Look NO FURTHER Miss!* YOUR MACRO IS DONE!!!!!

$30 USD in 0 days
(10 Reviews)
3.8

22 freelancers are bidding on average $42 for this job

bharanisrihari

Hello, Excel VBA expert ready to start. Please check PM for details. Thanks!

$40 USD in 1 day
(59 Reviews)
6.3
svet63

Hi Debbie. It's all crystal clear. Just one question. When you say 'write onto a new sheet the unique numbers' - is this new sheet always present or it has to be created every time? Thanks, Svet.

$60 USD in 1 day
(56 Reviews)
6.2
koolsidz

Excel Whiz here ;) Please see PMB for more details

$50 USD in 0 days
(86 Reviews)
5.5
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet con More

$40 USD in 1 day
(38 Reviews)
5.3
deepbluetech

I am an Excel macro expert. Let me know.

$50 USD in 1 day
(83 Reviews)
5.2
FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$30 USD in 1 day
(39 Reviews)
5.2
slavisatosic

Hello, I am offering you to make this VBA macro by tomorrow. Please see private message for details.

$50 USD in 1 day
(54 Reviews)
5.1
amcsummers

Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person yo More

$45 USD in 1 day
(36 Reviews)
4.9
jal540

I have done many custom VBA projects and have excellent ratings.

$50 USD in 4 days
(9 Reviews)
4.2
satsin7

Hi I have been using excel for past 15 years and also done VBA macros to automate tasks like these. Please check my profile and you will find 100% time completion record and 5.0 feedback on each of my assignments he More

$30 USD in 1 day
(11 Reviews)
4.0
diegogarcia0531

Hi, I can do the project, MS Excel VBA expert, I understand your needs. I am looking forward to work with you Best Regards Diego

$50 USD in 1 day
(9 Reviews)
3.9
FreeLAS

VBA Expert

$30 USD in 0 days
(11 Reviews)
3.8
edatawiz

Hi - Please check your PM to know about my experience and skills

$41 USD in 1 day
(10 Reviews)
3.6
vikashgadia

excel macro expert let start ur project

$40 USD in 2 days
(13 Reviews)
3.5
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement

$30 USD in 2 days
(16 Reviews)
3.5
HosElectro

experienced programmer ready to start ryt away

$40 USD in 2 days
(3 Reviews)
3.3
adim

More than 10 years experience in Excel and VBA.

$45 USD in 2 days
(5 Reviews)
3.3
jaylancer43

Lets get going..!!

$50 USD in 1 day
(5 Reviews)
2.7
bubu77

Hi, Ms Excel expert having 8+ yrs of IT experiance. Plese see your PM for a sample application.

$30 USD in 2 days
(1 Review)
2.0
rbtinf

Hello. I have an experience in VBA macros development and integration.

$30 USD in 1 day
(1 Review)
1.1