Pulling data

[christinekenny]

Hi,

I am trying to pull data from various parts of a spreadsheet to combine into one so it reads as a whole notice. I am very new to excel and when I try I keep getting error notices. I could not add an attachment so this was the best way i could do it.

Any help would be greatly appreciated.

Thanks

SHEET 1

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ROW[/TD]
[TD]COL A[/TD]
[TD]COL B[/TD]
[TD]COL C[/TD]
[TD]COL D[/TD]
[TD]COL E[/TD]
[TD]COL F[/TD]
[TD]COL G[/TD]
[TD]COL H[/TD]
[TD]COL I[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DATE[/TD]
[TD]DJ[/TD]
[TD]THEME[/TD]
[TD]SPONSOR[/TD]
[TD]START TIME SL[/TD]
[TD]START TIME[/TD]
[TD]END TIME[/TD]
[TD]SUBJECT LINE[/TD]
[TD]NOTICE BODY[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Oct 14[/TD]
[TD]Muse[/TD]
[TD]50's Sock Hop[/TD]
[TD]WS Creations[/TD]
[TD]6pm SLT[/TD]
[TD]6:00 PM[/TD]
[TD]8:00PM[/TD]
[TD]Best in CELL C1 with DJ CELL B1 @ Sensual Delights CELL E1[/TD]
[TD]SHEET 2 B1[/TD]
[/TR]
</tbody>[/TABLE]

SHEET 2

[TABLE="width: 500"]
<tbody>[TR]
[TD]ROW[/TD]
[TD]COL A[/TD]
[TD]COL B[/TD]
[TD]COL C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][TABLE="width: 190"]
<tbody>[TR]
[TD="class: xl65, width: 190"]50's Sock Hop @ W/DJ SHEET 1 CELL B1 @ SHEET 1 CELL E1 SLT
Toss on your bobbi socks & poodle skirts then head down to where DJ will be spinning the tunes you want to hear!

Sponsored by SHEET 1 CELL D1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Is this what you want?

Book1
	A	B	C	D	E	F	G	H	I
1	14-Oct	Muse	50's Sock Hop	WS Creations	6pm SLT	6:00 PM	8:00PM	Best in 50's Sock Hop with DJMuse @ Sensual Delights6pm SLT	50's Sock Hop @ W/DJ Muse @ 6pm SLT Toss on your bobbi socks & poodle skirts then head down to where DJ will be spinning the tunes you want to hear! Sponsored by WS Creations
Sheet1

Cell Formulas
Range	Formula
H1	="Best in "&C1&" with DJ"&B1&" @ Sensual Delights"&E1
I1	=Sheet2!B1

Book1
	A	B	C
1		50's Sock Hop @ W/DJ Muse @ 6pm SLT Toss on your bobbi socks & poodle skirts then head down to where DJ will be spinning the tunes you want to hear! Sponsored by WS Creations
Sheet2

Cell Formulas
Range	Formula
B1	="50's Sock Hop @ W/DJ "&Sheet1!B1&" @ "&Sheet1!E1&" Toss on your bobbi socks & poodle skirts then head down to where DJ will be spinning the tunes you want to hear!"&CHAR(10)&CHAR(10)&"Sponsored by "&Sheet1!D1

 

[christinekenny]

Thank you so much, this is exactly what I wanted and learnt something in the process.. thank you again