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..
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.