Automatically copy contents of cell derived from a formula.

[Nigel]

Hi

How can I copy a variable from for example A1 to G1 when A1 is the result of a formula. When I attempt this I get a NAME error. A1 changes frequently so I dont want to use the manual copy and paste values option.

Thanks in advance

Nigel

[Ace_XL]

Why not link the two?

So in Cell G1 simply use
=A1

Or am I missing something?

[Nigel]

Hi, I tried that and it didnt work. The contents of A1 is a variable from a different so I assumed thats why your suggestion didnt work. Im not in the office now and wont be until Sunday and I will retry then. Thanks for your reply

Regards

Nigel

[Nigel]

Back in the office now and retried linking the two cells as suggested just to make sure and it returns a value of 0 in G1. A1 contains a variable from a different workbook in case that makes any difference. Is there any other way of copying the value from A1 to G1?

Thanks in advance. Nigel

[FDibbins]

Unless A1 is empty, a reference to that cell will return whatever is in that cell - irrespective of where it comes from - and if it is empty, then it will return 0. what (exactly) is in A1?

[ELeGault]

if A1 is a ling to another workbook, and you want it to be copied to G1 so it shows there... then why not put that LINK in G1 instead of A1 removing the redundancy...

Can you add a file with the example... only make sure your example does not reference an outside workbook, instead make it go to a new sheet just for the sake of argument so we can see what it is you are actually doing please.

Thanks

[Nigel]

Hi. Cell A1 has the following.... [tyre ordering system.xlsm]Main Sheet'!E58....This returns a 5 digit number from a different workbook. My plan is to use that figure (which is a variable) in another calculation but I cant get Excel to recognise it. So I tried to copy it to another location (G1) simply by putting =A1 in cell G1 to see if that would work but it just returns a zero. How can I use the numeric variable content in A1 in another calculation? I hope that explains my problem more clearly.

Thanks and regards

Nigel

[ELeGault]

Wrap[ Value around it. Sounds like it is making it text currently. That should do it...

=VALUE([tyre ordering system.xlsm]Main Sheet'!E58)

[FDibbins]

Not that it should matter, but is the data that is being pulled in really a number, or is it text that just looks like a number? Test with =ISNUMBER(A1) FALSE indicates text.

However, using =A1 in another cell should return the contents of A1, whether it is numeric or not

I think you are going to have to upload a clean sample of both of those workbooks here to the forum

[ELeGault]

Touché Ford,

I am assuming it is a text version of numbers based on the post

This returns a 5 digit number from a different workbook

.
But a working version of this would be helpful to verify.

[FDibbins]

Touché Ford,

I am assuming it is a text version of numbers based on the post .
But a working version of this would be helpful to verify.

Even with text, =A1 should still return what is in the cell, thats what has me puzzled

[Nigel]

The suggestion by ELeGault to "wrap value round it" worked so im very grateful to him and all the others who took the time to help...much appreciated.

Regards

Nigel