Lengkap

Excel Macro Basic Coding skills required

I have a master sheet which collates files from a chosen folder. I need some changes/additions to the existing code.

1>Attached Sheet Master

2>Attached Sheet Sample 1 (DR 17th)

3> Attached Sheet Sample 2 (RR 18th)

Sample 1 and sample 2 will always be in the same format. Currently i have shown only two sheets. in real life I will have multiple number of sample sheets. also the number of columns filled in the sample sheet will vary. Sample sheets are locked with password 'lb'

Save sample sheet in a folder and master sheet in a different location. ON sheet1 of master execute the macro, and this collates data from sample1 and sample 2 sheets in a new tab on master sheet..

Changes required

1> Everytime when data gets collated in master sheet the new tab where data is collated should be equal to todays date

2> column A cell 1 of master sheet (on the tab where data is collated) has the file name of the sample [url removed, login to view] file name should be present in column A all the way down till there are data points for that particular sample sheet

3> For data points of each sample sheet which gets collated in master sheet, if the value in column I is 0, that particular row should be deleted (shift up, so that there are no gaps between)

4> Any completely Blank rows within a sample data collated in the master sheet should get deleted. If you use the current sheet you will see a blank row in row8

5>Journal number column should be filled. every sample data set should have an incremental journal number starting 10001. once a journal number has been assigned, it should update the jounal number in the journal tab in master. The next time when the master is run again, it should pick up from the last journal number, add 1 and use this journal number for the next samples. Each sample should have a unique journal number

6> There should be a blank line in between each sample consolidated in master

7> Except for the 1st sample, headers for each sample should be deleted

8> For each sample consolidated in the master sheet, sum up the values in column I. If the values don't add up to ZERO (0) then that journal number should be updated in Sum Error tab. If no errors in sum, then sum tab to be hidden. If error the sum tab is unhidden and user get a msgbox after execution of macro, "There are errors in your sum" and the activesheet after end of macro should be sum error sheet

Once macro is executed, the master sheet should save itself. Journal number tab should be hidden.

I am also attaching sheet final master to show how the final output after your code should look like (this sheet is called final output).

Please read the requirements carefully. My budget is INR 2500 only. So if you bid above that I will not be considering your bid.

Needs to be delivered by Monday Morning without exceptions. Hence absolutely detailed instructions, if I am not available to answer queries online.

Kemahiran: Excel, Visual Basic untuk Aplikasi

Lihat lagi: basic coding skills, skills required i writing academic research in educational psychology, basic photoshop skills required, excel macro vba coding, visual basic coding search engine excel, visual basic excel macro function optimization, excel macro coding option buttons, visual basic excel macro import export 2007, visual basic excel macro import export, voorbeeld excel macro visual basic scripts, excel visual basic macro paste clipboard, excel visual basic macro download yahoo stock prices, excel visual basic macro, excel macro copy paste visual basic, visual basic excel macro next row

Tentang Majikan:
( 1 ulasan ) Mumbai, India

ID Projek: #16746159

Dianugerahkan kepada:

aminw

Sounds like a project right up my alley. I can deliver by Monday morning. Let me know if you want to proceed

₹2500 INR dalam 2 hari
(3 Ulasan)
3.7

5 pekerja bebas membida secara purata ₹2361 untuk pekerjaan ini

The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Lagi

₹5555 INR dalam sehari
(51 Ulasan)
5.6
sahama988

"Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar proje Lagi

₹1300 INR dalam 5 hari
(0 Ulasan)
0.0
osmanaydin

Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,

₹700 INR dalam sehari
(0 Ulasan)
0.0
sanjibpanja

A proposal has not yet been provided

₹1750 INR dalam 2 hari
(0 Ulasan)
0.0