Käynnissä

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

Taidot: tietojenkäsittely, Excel, Visual Basic for Apps

Näytä lisää: 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

Projektin tunnus: #4239842

Myönnetty käyttäjälle:

Gooroo

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

30 $ USD 0 päivässä
(10 arvostelua)
3.8

22 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön

bharanisrihari

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

40 $ USD 1 päivässä
(59 arvostelua)
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 1 päivässä
(56 arvostelua)
6.2
koolsidz

Excel Whiz here ;) Please see PMB for more details

50 $ USD 0 päivässä
(86 arvostelua)
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 Lisää

40 $ USD 1 päivässä
(38 arvostelua)
5.3
deepbluetech

I am an Excel macro expert. Let me know.

50 $ USD 1 päivässä
(83 arvostelua)
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% Lisää

30 $ USD 1 päivässä
(39 arvostelua)
5.2
slavisatosic

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

50 $ USD 1 päivässä
(54 arvostelua)
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 Lisää

45 $ USD 1 päivässä
(36 arvostelua)
4.9
jal540

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

50 $ USD 4 päivässä
(9 arvostelua)
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 Lisää

30 $ USD 1 päivässä
(11 arvostelua)
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 1 päivässä
(9 arvostelua)
3.9
FreeLAS

VBA Expert

30 $ USD 0 päivässä
(11 arvostelua)
3.8
edatawiz

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

41 $ USD 1 päivässä
(10 arvostelua)
3.6
vikashgadia

excel macro expert let start ur project

40 $ USD 2 päivässä
(13 arvostelua)
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 2 päivässä
(16 arvostelua)
3.5
HosElectro

experienced programmer ready to start ryt away

40 $ USD 2 päivässä
(3 arvostelua)
3.3
adim

More than 10 years experience in Excel and VBA.

45 $ USD 2 päivässä
(5 arvostelua)
3.3
jaylancer43

Lets get going..!!

50 $ USD 1 päivässä
(5 arvostelua)
2.7
bubu77

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

30 $ USD 2 päivässä
(1 arvostelu)
2.0
rbtinf

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

30 $ USD 1 päivässä
(1 arvostelu)
1.1