H

I have a spreadsheet that contains a lot of information about client personal, loan & account details

I have created a macro that turns all this information into individual statements for each client in a new worksheet

What I would like to do if possible, is to have a progress bar that shows how much is done and is left to do as the process is being carried out. Currently, a new worksheet openms but, apart from the hour glass, it does not look like anything is happening and may cause another user to try and stop or restart the process

Any help wopuld be greatly appreciated.

By the way, all the work done creating the macro was done with lots of help from people on these Excel communities as I am not a programmer in any shape or form, so with this in mind, please give as much information as you possibly can if the problem can be solved

Many thank

Malcolm