hmmm..If the row needs to be free then I was thinking he could insert a row at the top and put an X say in D1. However There might be some other figures in that column which shouldn't be included to the calculation. Lets say the range start D12163 and d9 and d10 have got some figures which shouldn't be included so he needs to select D12163. Is that possible to guide the user asking like "Please highlight the range in each worksheet to calculate the figures"? If there are 5 worksheets then he would select that specific range in each worksheets then macro would create the summary tab? Is it possible like that or I'm making it too complicated?

many thanks!

Quote Originally Posted by sijpie View Post
The user only would need to give the column. Finding the last entry in a column is very easy. But you have to decide if the user does that on his/her own or if the macro has to guide it (which means more clicks). What is your preference? I can also do it that the macro will flag up and ask the user for those sheets which he hasn't marked the column. But then I need to know if the user is entering the column letter in a fixed cell (say A1, or B1 depending on headers), or if he is marking with an X in a fixed row (this needs to be a free row, depending on headers).

Let's start with making the process work for one workbook, with a number of sheets with not necessarily the same layout.