Hi all! This is my first post. However I have been a lurker of your site for some time now and I have never been disappointed. That is why I present to you my first inquiry:
The simplified version-- I wish to create a formula in Worksheet B that populates both from data in cells in Worksheet A and if I were to say, paste.
The problem is that I want the ability be able to paste in data to the receiving cell and not adjust the formula. For example
WS A:
X
P
L
X
WS B:
=WS A!A1 (X)
=WS A!A2 (P)
Y
Y
K
=WS A!A3 (L)
=WS A!A4 (X)
G
T
So the formula would have to be smart enough to read the entered cells in worksheet A and if data is entered in worksheet B, not bugger up the rest of the worksheet. I feel like this is very possible and probably easy but I have not been successful with searching for a solution. Any assistance is appreciated. I would like to avoid creating a macro and stick to a simple formula.
I created a forumla that does not work. It reads the last cell only and makes all of the data mimic that =INDEX(Sheet1!A1:A100,MATCH(REPT("z",255),Sheet1!A1:A100))
Thank you in advance!
-Ryan
Bookmarks