formula to bring value from another sheet with different spaces
 

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

formula to bring value from another sheet with different spaces
 

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

formula to bring value from another sheet with different spaces
 

Have you tried that, Therese? Did it give the result that the OP requested?
--
David Biddulph

"Therese" wrote in message
...
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

formula to bring value from another sheet with different space
 

i tried your formula but when i copy it on my sheet1 A6 it gives me zero i
dont know how to adjust the formula. Can you please help me with that.

"David Biddulph" wrote:

Have you tried that, Therese? Did it give the result that the OP requested?
--
David Biddulph

"Therese" wrote in message
...
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

formula to bring value from another sheet with different space
 

hi
i had tried that before it doesnt work due the the spaces.
thanks though

"Therese" wrote:

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

formula to bring value from another sheet with different space
 

The formula I gave in reply to your previous question was
=IF(MOD(ROW(),6)<1,"",OFFSET(Sheet2!D$1,(ROW()-1)*4/6,0))

For your revised question the answer is presumably
=IF(MOD(ROW(),5)<1,"",OFFSET(Sheet2!D$3,(ROW()-1)*3/5,0))

There isn't anything complicated in the formulae. The functions used are
IF, MOD, ROW, and OFFSET, all of which are standard Excel functions. If you
don't understand the syntax, look at Excel help for the relevant function.
It'll tell you the syntax of the function, and show examples.
--
David Biddulph

"veena" wrote in message
...
i tried your formula but when i copy it on my sheet1 A6 it gives me zero i
dont know how to adjust the formula. Can you please help me with that.

"David Biddulph" wrote:

Have you tried that, Therese? Did it give the result that the OP
requested?
--
David Biddulph

"Therese" wrote in message
...
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

formula to bring value from another sheet with different space
 

Hi
Oh I see...misunderstood the question.
:-)
Therese

"David Biddulph" wrote:

Have you tried that, Therese? Did it give the result that the OP requested?
--
David Biddulph

"Therese" wrote in message
...
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