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 [login to view URL] 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.
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
100% Satisfaction Of Deliverable
"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 projects I've completed. Thanks