Combining worksheet tabs

[Larry Fish]

First worksheet is under tab a and second worksheet is tab b.


would like to combine cells a1..b15 from tab b to cella16..b30 of tab a.



Thanks for the help in advance

Larry

 

[erik.van.geit]

Hello, Larry,

could you explain please what you mean by "combine" ?

kind regards,
Erik

 

[Larry Fish]

I wand to take data from Btab and have it appear on Atab of the same file.

 

[erik.van.geit]

try this
click in a cell (A16 of tab a)
type =
click on other tab
click in a cell (A1 of tab b)
ENTER
the contents of A1 on tab b will be in A16 of tab a
and you can see the syntax: how to write the formula

would this give you a start ?