Hello,
How does one add cell positions?
For example, I am working with two worksheets. One has a list (ws2), the other (ws1) displays information from that list. I would like to display cell c3 from ws2 and in cell d5 in ws1, then display c4 from ws2 in cell d8 in ws1. I need these linked because I will have a lot of rows of this.
Thank you!!!!
Hi banessa and welcome to the forum,
See the attached example where I've done what I think you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you for your quick reply.
What I'm trying to display is text, not data. I'm looking for something that will look something like this:
B3 in WS1= WS2!B2
B4 in WS1= WS2!B(2+1) so that it's actually B3...
This is really confusing to even try to describe. I've attached a sample of what I'm trying to do.
Hi,
This looks like you need to learn the Indirect Function.... See if this doesn't help at:
http://www.contextures.com/xlFunctions05.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks