Hello everyone!!!!
I was hoping to get some help with a worksheet I have been working on for some times now.
I have a VBA macro which creates worksheets from a template and then populates a summary sheet once the user inputs some data in the newly created worksheets. The sheets that are created are being governed by a list which I have on a third sheet which I called Tools. The list is up to 10 rows long but it is not necessary for the user to have all 10 sheets created.
Unfortunately I have 10 columns in my summary sheet, so that once the sheets are created the information will go from each individual sheet on to my Summary sheet in a column dedicated to that particular sheet (have I confused you already??). My problem is that if not all 10 sheets are created, then the column corresponding to the missing sheets comes back with "=REF!" error. This because the summary sheet cannot get data from a sheet that does not exhists.
What I would like to do is to be able to bypass the error in any possible way, so that I can get averages of all numeric data coming from the other columns.
Any help would be greatly appreciated.
Nicola69
Bookmarks