How Can I copy the contents from Sheet 1 to Sheet 2

[clemkonan]

I have a sheet 1 called spec general and at b6 there is a product identity called Hot chocolate. I need to capture this name on sheet 2.

When I use = spec general ! b6 excel tries to correct it and opens it a folder dilog called "Update"

I was assuming my spacing was off or that I had to use " spec general" rather than simply spec general but no luck

If I try the same concept with the sheet named sheet1 , Eureka it works, go figure.

I know I am messing up but not sure where.

 

[babycody]

Try ='spec general'!B6 . The sheet name has a space between spec and general so you have to use single quotation marks.

 

[Smitty]

Try adding apostrophe's:

='spec general'!B6

HTH,

Smitty

 

[clemkonan]

Success! works grest thanks