Hi all, I am very new to this and have searched the forums looking for an answer but can't find something that puts it all together!
I have several workbooks that hold a column of data (all the workbooks have the data in the same column) and I want to be able to include a button on each workbook that when clicked, copies this data to another workbook (the master). The trick is that I want the user to be able to choose where the data will be copied to in the 'master' workbook. Ideally I would like the user to have a drop down menu of 'headers' they can choose which will determine the column the data will be copied to. For example the 'master' may have different countries as the headers (Italy might be column K) and if the users selects 'Italy' then the data will be copied into this column.
I haven't included any of the patched up code I tried to pull together because although I can get parts of it to work, when I try to put those parts together I get all sorts of errors. If anyone has done this before and can help I would be very grateful!