Hi
Will it work if you write =Sheet2!D1 inSheet1!A1, and then copy the formular
downwards?
Therese

"veena" wrote:

i have 2 sheets in a workbook. I want Sheet 1 column A to bring in the value
from sheet 2 column D. The problem is the data on Sheet 2 in column D has 3
spaces between each sku and on sheet 1 column A the spaces between each item
to be 4 so i for example i want a formula in Sheet 1 in row1 than in row6
picking up the item from sheet 2 from row D3 and than D6 and so on.
Sheet1 Sheet2
1 1009655
2
3 1009655
4
5
6 1009685 1009685
7
8
9 1008654
10
11 1008654
thanks