Can anyone just explain VBA of this Sheet posted by watersev(expert)

[john321]

Please any of can explain this in detail it would be of great help.

Thank you,
John.

[Richard Buttrey]

As mentioned in my PM reply to you should not PM members. Am I the only one to have received a PM?

Your post is timed at 5:03 PM local and yet your PM which says you are getting frustrated that there has been no response is timed only 23 minutes later. There is no service level agreement here, we all give freely of our own time. You do yourself no favours by being so impatient. Please note.

[john321]

ok agreed

...................

[shyamhappy]

Hi John

Give me some time I look into the code and explain you how code works

__________________________________________________________________________________________________________________________________________
if you think some one has helped, please click * to add to reputation.


“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison

[john321]

hello,

don't mind saying but I am still trying to understand this code but an't able to pls help.

[Richard Buttrey]

Perhaps the originator of the code could explain.

There are usually several ways of achieving Excel solutions. I always use standard Excel functionality first wherever it's possible and then only resort to macros where they are needed to do things that only they can do.

In this case I would simply have created a master payslip that contained VLOOKUPS in all the cells that looks up the or details in the salary sheet.

I would then have written a simple looping macro that worked down the list of salary numbers on the salary sheet between the range of numbers wanted, and for each row copied the master payslip to a row 11 rows below the last one (adding two blank rows every third iteration) and changed the SLNO.

The code would be no more than a handful of rows.

A second one line macro could erase all payslip records ready for the next week.

[watersev]

hi John, the code creates all salary slips in array, pastes them to the sheet and adds formating. It's an option to make it, there are as in most cases other ways to achieve the same result. One of them is shown in the above post by Richard Buttrey