Hi,
I'm very new in the VBA world but I know some less/more things about the code, but right now I'm looking
for solution for the new challenge which is very difficult for me ..or maybe I unable to find the answer which maybe is very easy.
I have one file with 3x spreadsheets :
- 1st spreadsheet(1) is with the DATA with about 12 columns of data and 400-600 rows. First row is the header, the rest rows are the data.
- 2nd spreadsheet(2) it's a target for the DATA (from nr1) - it's a 8 columns table with the header.
- 3rd spreadsheet(3) is the ten cells-table with the "criteria" , eg there is 5 cells with a 5 words, the rest 5 cells are empty (If there will be need for the other criteria it will appear in the table.
The challenge:
I'm looking for the right code which will be looking in (1) for the correct rows where in column A will be match with the criteria from table in (3)
and if there will be correct rows , then the code will copy them to the (2) but not the whole rows but only the values from the 8 first columns ( information in columns 9-12 are not needed, but they need to stay in (1) ).
Could someone can help me with the code or will help in finding the right solution ?
Bookmarks