Help Changing The Pasting Reference Cell
I need a formula to change the cell that's referenced when I paste the data into another cell. Is there a way using offset or indirect to make this happen. The pasting needs to go like this In cell "H2" is data that's pasted in "L2" then "M2-Q2" has other formulas. In cell "R2" I want the value of "I2" then another five cells of formulas then I want the value of "J2" in "X2" and so.
I attached a spreadsheet further breaking down what I need. Thank you for all of you help.
Any help or direction
Copy this formula into R2, X2, AD2, and then copy down as needed:
=OFFSET($I2,,INT((COLUMNS($R:R)-1)/6),,)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn your formula worked exactly as I needed. Unfortunately the site won't allow me to give you further rep but I still greatly appreciate the help. Thank you.
"You must spread some Reputation around before giving it to Glenn Kennedy again."
C'est la Vie.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks