A
Adaliza
New to this; need some help on Excel 2003 vba
Here is the scenario:
Got two spreadsheets, I will like to search spreadsheet1 column (say
column I) for a value such as 20 until there is no more data in that column;
IF the value is found, search the spreadsheet2 for the row that has a
matching the value to the value found on the cell at column D in spreadsheet1
that corresponds to the row number where the value 20 was found .
When the matching value is found, I want to copy the values from the
cells in columns A to D only that corresponds to the row of the matching
value on spreadsheet2 and insert a new row at the spreadsheet1 above the row
where the value 20 was found and paste the values copied at columns A to D.
This needs to be a loop because there is a group of rows in between
each occurrence of 20 with different values at the cells where 20 is found.
Hope I explain this well enough for someone to help me.
Thank you.
Here is the scenario:
Got two spreadsheets, I will like to search spreadsheet1 column (say
column I) for a value such as 20 until there is no more data in that column;
IF the value is found, search the spreadsheet2 for the row that has a
matching the value to the value found on the cell at column D in spreadsheet1
that corresponds to the row number where the value 20 was found .
When the matching value is found, I want to copy the values from the
cells in columns A to D only that corresponds to the row of the matching
value on spreadsheet2 and insert a new row at the spreadsheet1 above the row
where the value 20 was found and paste the values copied at columns A to D.
This needs to be a loop because there is a group of rows in between
each occurrence of 20 with different values at the cells where 20 is found.
Hope I explain this well enough for someone to help me.
Thank you.