I am new to VBA, and stuck in this project im working on. I use Excel 2007
I have 3 sheets, first one New Data, second one Static Data, third New Columns.
Basically, in sheet New Data I will have my new data set.
In sheet Static Data I will have 10 differents key words in cells E4 to E9. I want to be able to add new variables to be found, thats why it has to search for the text in cells in Column E and not for a specific text o value.
What I need to do is search in the headers of the New Data -Thus Row 1 of sheet New Data-, find where the 10 key words from the sheet Static Data are (or however many I want to have in column E of sheet Static Data) , and once found copy the column where its located and paste it one next to the other in the third sheet, New Columns.
To sum up, loop through the range of values with text on column E sheet Static Data until it finds it in row 1 on sheet New Date, copy paste the column where the text is found to sheet New Columns, until it reaches the end of the cells with text in column E on the sheet Static Data.
Any of your help is appreciated guys!
thanks in advance