Hi,
I am trying to understand what application function would be necessary if the goal is to select a cell within a grid depending upon a criterion. The following example may clarify what I am attempting to achieve:
For list:
Date Manager Value Buy/Sell
29/09/2011 A £272 Sell
30/09/2011 B £273 Sell
03/10/2011 C £274 Sell
04/10/2011 D £275 Sell
05/10/2011 A £276 Sell
06/10/2011 B £277 Sell
I would like to copy the 'Value' to the cell which is in the column for 'Manager' and row for 'Date' from the above.
If I were to have the dates in a column on the left and the Managers ‘Manager A’ to ‘Manager D’ in the row one above the row in which the dates start, please could someone inform me whether the ‘application.intersect’ function would be applicable, eg. for the first line in the above:
I am trying to understand what application function would be necessary if the goal is to select a cell within a grid depending upon a criterion. The following example may clarify what I am attempting to achieve:
For list:
Date Manager Value Buy/Sell
29/09/2011 A £272 Sell
30/09/2011 B £273 Sell
03/10/2011 C £274 Sell
04/10/2011 D £275 Sell
05/10/2011 A £276 Sell
06/10/2011 B £277 Sell
I would like to copy the 'Value' to the cell which is in the column for 'Manager' and row for 'Date' from the above.
If I were to have the dates in a column on the left and the Managers ‘Manager A’ to ‘Manager D’ in the row one above the row in which the dates start, please could someone inform me whether the ‘application.intersect’ function would be applicable, eg. for the first line in the above:
Code:
Dim isect as Range
Set isect = application.intersect(“29/09/2011”,”Manager A”)
Any advice would be greatly appreciated. Thanks.
