How to read value of a cell in a relative location

A

AnatolyV

I use data filters to display products from a particular vendor. When I apply
a filter, I want cell A1 to display the value of the cell that appears one
row down and one column to the left of the cell A1.

Thank you!
 
T

T. Valko

one column to the left of the cell A1.

There is no column to the left of column A.

Need more detail. Tell us where the filter drop downs are located.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to autofill from relative location 2
How do I put a blank value in a cell not using "" in a formula 2
Relative Addressing not working 4
display a value from Sheet1-A1:A10 in Sheet2-B1 2
Relative Cell Reference 2
Naming Cells Using Relative Cell References 1
relative offset to a named cell 3
"Save As" to XML file macro using a cell's value 0

Top