I am using the macro facility of excel to retrieve data in a row using hlookup but unfortunately it retrieves only one info and not the entire data row which includes over 20 rows of data. Can you tell me how or what I should use instead of Hlookup to program this> I have many other worksheets that require the same data retrieval info.
It basically looks for a year and then should retrieve the row of data (financial data) that is under the require year. I have a multitude of years that it must get which is not a big problem but I need to retrieve all the data under that row and place it in another worksheet under a specific row.
thanks very much for yours assistance.