Cell Value Problems

[TDK86]

In my workbook, i've created a number of lists in the name manager, and created lists using data validation process, but when i want to transfer a value from one worksheet to another, all it shows are the referenced cells, for example ='Shed Enquiry'!B33:H33. it's able to work within the same sheet, but not one sheet to another.

How can i transfer the selected value in the list from one worksheet to another?

 

[sgmpatnaik]

@TDK86

Hi

Try with the Array Enter as Ctrl+Shift+Enter

for ex. you try as ='Shed Enquiry'!B33:H33 and you press just simple enter but enter as a array method

='Shed Enquiry'!B33:H33 Ctrl+Shift+Enter

hope it is solve other wise please give some details actually what do you want

Thanks

SP

 

[TDK86]

Champion, thank you

@TDK86


Hi

Try with the Array Enter as Ctrl+Shift+Enter

for ex. you try as ='Shed Enquiry'!B33:H33 and you press just simple enter but enter as a array method

='Shed Enquiry'!B33:H33 Ctrl+Shift+Enter

hope it is solve other wise please give some details actually what do you want

Thanks

SP

 

[sgmpatnaik]

@TDK

Hi

Glad your problem solved

Thanks

SP