Calculate data from a different hidden sheet

[tsioumiou]

Hello,

I have this code that calculates the value in column F according to what you type on column D divided by the value column K and vice versa ( you type on column F and a value comes up on D)

Column K is needed for those calculations.
What i want to do is move column K to a hidden sheet2. ( i dont want the values on column K to be visible)

Here is the code below:

Please Login or Register  to view this content.

"Target.Offset(, 7)" and "Target.Offset(, 5)" is column K as you can see. If i move this column to sheet2 and hide the sheet is there a way to make this code still work?

Thanks

[tsioumiou]

Any help with this guys?
Any ideas?

Thanks

[tsioumiou]

should i close this thread? it seems what i ask is not possible ?

Thanks

[StephenR]

If they're still in column K perhaps replace with:

Please Login or Register  to view this content.

[tsioumiou]

Thanks for the reply StephenR

Although it doesnt work.

I moved the K column to sheet2 and when i type on Column D nothing happens (nothing shows on column F)
Strangly whatever i type on column F it gives 0 on D.
Something is wrong here. Probably a detail.

Please Login or Register  to view this content.

[tsioumiou]

My mistake it work for column D!!!
Brings the right results on F.

But when i type on F it always brings 0 on D.

Something wrong with the below maybe?

Please Login or Register  to view this content.

[StephenR]

You've lost the reference to sheet2. EDIT - apologies, my mistake:

Please Login or Register  to view this content.

[tsioumiou]

Worked perfectly

Thank you very much.