turnern2
03-14-2007, 09:21 AM
Hi,
I would like some help, please...
I need to process downloaded data on various reports. I have a macro that 'looks' at the data in a column (look-up) and processes the data in another column (target). The look-up and target columns will be different each time the data is downloaded and the column titles will be different in each download / report.
So, what I would like to do is have a user form present the user with two list boxes, each populated by the column headers in row 1 and allow the user to select the 'look-up' column in listbox1 and the 'target' column in listbox2...
Any ideas?
I would like some help, please...
I need to process downloaded data on various reports. I have a macro that 'looks' at the data in a column (look-up) and processes the data in another column (target). The look-up and target columns will be different each time the data is downloaded and the column titles will be different in each download / report.
So, what I would like to do is have a user form present the user with two list boxes, each populated by the column headers in row 1 and allow the user to select the 'look-up' column in listbox1 and the 'target' column in listbox2...
Any ideas?