Retrieve varying data range

[tomp]

I have a 'Source' workbook/worksheet with, say 20 rows and 5 columns of data.

I need to retrieve a varying subset of the sheet for use in a 'Report' workbook.

If I wanted to retrieve a specific range of data, say rows 5-8, the reference to the Source workbook/worksheet for the a1 cell might look like [SourceBook]Worksheet!e1 and the d5 cell for the retrieved data might look like [SourceBook]Worksheet!h5

In the Report workbook, I would like the user to be able to simply enter the starting row for the data in the 'Source' workbook, say 'c', and have the Report workbook calculate the reference necessary for the data to start in cell a1.

Can that be done? What would the 'general' reference for a1 in the 'Report' workbook look like?

[davesexcel]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!