Column I formula is an IF referring to column H.
=if(H2="this","Yes","No")
Except, it mentions H2 14 times. I want to move it to Worksheet 2.
Short of manually correcting every instance of H2, how do I cut and paste so that the pasted formula refers to Worksheet 1, so I get
=if('Worksheet 1'!H2="this","Yes","No")
?
Last edited by johnandrews; 12-20-2013 at 11:04 AM.
Just cut and paste it - the reference will automagically update with the relevant sheet name for H2.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Nope. They reroute to refer to the cells on the left of the second worksheet.
Are you COPYING and pasting, or CUTTING and pasting?Originally Posted by johnandrews
Oh. Have another beer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks