how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?
Thank you for your time.
I cant find the answer in the documentation or forum. So I am asking.
a. How do I reference a single cell in an external sheet?
b. Can I reference a cell by row number and column number?
c. Is there a way to make this dynamic?
using the ' =ExampleCell1 ' syntax is for the current sheet. How would I do this by for an external sheet?
- web-form creates a new row in Master sheet
- in newly created row, (column #2, row #5) then pulls text from specific cell in external sheet at (column #5, row #5)
- this would repeat for each new row that was created, where the row # was updated dynamically
-VLOOKUP looks for a range and a search criteria. I am not sure how to use it in this scenario as I don't have a search criteria and the range would always be changing.
-Workflow Automation requires I copy an entire row. which wont work for me.
-Cell linking doesn't seem to be able to automatically populate on newly added rows.
Thank you again.🤩