Hello AB33, thanks very much for your answer.
I have been playing with my sheet since my last post and found out that the very first time I run the code, it will do it correctly (import headings to the respective sheets). How ever, if I update something in my master sheet and run the code again, headings do not import, meaning that the line above does not rerun.
Else, I have one more issue:
Is there a way to further develop the program above to sum up column ''areal'' in each sheet, and put the result just under the last data in column ''areal''??
I have been trying by adding the following line under the (ActiveSheet.Range (''A1:H1''). value....) syntax, but it is not working for some reason:
In advance, thanks very much for your help.
Bookmarks