Combining worksheet tabs

Larry Fish

New Member
Joined
Jan 24, 2005
Messages
13
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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, Larry,

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

kind regards,
Erik
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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 ?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,674
Messages
5,573,598
Members
412,537
Latest member
Mohamed_5966
Top