copy formula issue

[skatcb]

I have a formula that looks like this =PSItemResult("{62ACAD81-3CE2-424A-AA20-F0B8B554A469}","Qty"

What I am trying to do is to copy this to 2 more cell but instead of "Qty" I need to change one to "Name" and "linear". any idea how I can get a macro to do this do this or some kind of link IF statement?

I have attached an example of what the finished product would look like



Thanks in advance

[Pete_UK]

Not sure what your PSItemResult is (and it is a different name in your example), but you could do it like this:

=PSItemResult("{62ACAD81-3CE2-424A-AA20-F0B8B554A469}",IF(COLUMN()=1,"Qty",IF(COLUMN()=3,"Name",IF(COLUMN()=6,"Linear",""))))

Hope this helps.

Pete

[skatcb]

Thats good but the PSItemResult changes, can I do this without knowing what it will be in advance

[Pete_UK]

I haven't a clue what you mean.

Pete

[skatcb]

Okay, so when I link this cell with our program it assigns this =PSItemResult("{62ACAD81-3CE2-424A-AA20-F0B8B554A469}", but if I link to a new item the long # in quotes changes. So right now we copy the first cell and paste then change the name to qty Etc.. I am trying to see if there is a way to make it so we dont have to copy and paste