Stationary Management System

CLOSED
Bids
38
Avg Bid (USD)
$97
Project Budget (USD)
$30 - $250

Project Description:
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 required:
Data Entry, Excel, Visual Basic
Additional Files: SMS.xls
Hire subhashnaval
Project posted by:
subhashnaval India
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire gvyshnya
$ 100
in 4 days
Hire piyushdpatel
$ 100
in 3 days
Hire TCar
$ 75
in 1 days
Hire Kubwaj
$ 220
in 5 days
Hire TushVaid
$ 50
in 2 days
Hire ExcelVBA101
$ 100
in 4 days
Hire MradulSharma
$ 50
in 5 days
Hire rtek84
$ 30
in 4 days
Hire aryznaiyzphilmla
$ 75
in 5 days
Hire KaplunEnterprise
$ 500
in 5 days