Closed

Excel Macro VBA reconciliation spreadseet

We are looking for a person who is able to write a simple VBA Excel macro.

We are accountants and would like to use a VBA macro to reconcile Purchase Day Book (all business expenses that have a receipt) to a payments made through the business bank account/s. Identify which expense receipts were paid through business bank account and which ones were paid using different payment methods. But we only interested to find all payments made through the bank account to which a correspondence entry has been recorded in the Purchase Day Book.

What the macro should do:

First objective: the macro must be able to identify the identical data (numerical values) in a column L of the worksheet PDB (see attached file) with a facility to exclude some rows (this sample would be rows 98-101 and 361-364) to a data in a column F on the worksheet BANK 1, also with a facility to exclude some rows (not in this example). Facility to change columns which are required to run macros must be incorporated in the VBA macro as on different spreadsheets column will be different to the example given to you.

Second objective: once the identical data in the required columns in both worksheets has been identified, the identified data in each worksheet the data should be replicated in the custom indicated columns. In the attached file after running macros PDB column K MUST Equal column L in the BANK 1 worksheet.

Since expense allocation to different columns is automated (see sorting column O), rather than replicating data in the L column, macro should just have a facility just to write required column number in the Sort Column O. User should be able to tell macro which number to write in the sort column.

Third objective: identified and allocated data on the two separate worksheets should be within 30 days period (data column A always A on all our spreadsheets) is included in the worksheet to each entry. If time lapse is more than 30 days but data is identical, then the cell with the data should be filled with let say RED colour. Ideally, the macro should have a facility to adjust time gap settings manually.

That pretty much it.

Skills: Graphic Design, HTML, PHP, Website Design

See more: what is sorting data, what is data sorting, what graphic design always do, what do accountants do, graphic design worksheets, graphic design worksheet, graphic design 101, c&f bank, c and f bank, business for accountants, accountants required, accountants for business, what is vba in excel, what is vba, what is macro in excel, vba time, vba and macros, find in vba, looking for accountants, graphic design for worksheets

About the Employer:
( 0 reviews ) Ethiopia

Project ID: #6982447

13 freelancers are bidding on average $127 for this job

KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Just reply with 'Yes' and We will come up with a. Detail project plan with our comments/queries. b. Best-feasible-real COST & TIMELINE We will provide you a. Best More

$242 USD in 15 days
(669 Reviews)
8.4
maverick44000

Hi. I am Usman and I shall be able to design a VBA macro based Excel sheet according to mentioned specifications. All the three objectives shall be implemented. Please discuss before awarding the work. Regards.

$160 USD in 2 days
(3 Reviews)
5.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive More

$150 USD in 7 days
(28 Reviews)
4.9
valentinnovakov

Hello, Please provide the sample spreadsheet. I can edit my bid when I know all details. Best regards, Valentin Novakov

$250 USD in 3 days
(22 Reviews)
4.3
zExcel

A proposal has not yet been provided

$135 USD in 2 days
(7 Reviews)
3.9
petrovp

Good day, I can write such a macro for you, though I could not find the attachment which you refer. Please send it. My macro will have a form where you can specify columns to use, rows to exclude, time gap and other pa More

$30 USD in 2 days
(10 Reviews)
3.2
wiisetech

Hi, I have read the full description. I can do this work for you. I have recently done a macro. I will do it according to your requirements. I will give u a working and fast macro. So waiting for your reply to start More

$133 USD in 2 days
(2 Reviews)
3.0
prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$155 USD in 3 days
(4 Reviews)
2.4
cgullapalli

Hi, I am good at excel and macros. I will produce the results with great accuracy. Can you please give permission to discuss further on this to star the work. Looking forward for your reply.

$60 USD in 2 days
(1 Review)
0.0
HafrateMed

Hi. I have a storng experience in VBA/Excel and contributed to many lead projects in the field. I have read your description and I'm sure that I can meet all your requirements. The three objectives of the Macro can More

$35 USD in 4 days
(0 Reviews)
0.0
OniNeko

Thank you for the complete explanation of your needs, I have built literally over 100 similar automated reports, it will only take about 2 hours to do (including testing) and I won't be happy with the finished product More

$40 USD in 1 day
(0 Reviews)
0.0
boriscikotic

Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: h More

$155 USD in 3 days
(0 Reviews)
0.0
bicaig

Hello, I can help you with this task. I have exeprience with VBA and Excel Just contact me. Regards, Gabriel Bica

$111 USD in 3 days
(0 Reviews)
0.0