M
maceudora
I use the serial number date as the 'find' part of Vlookup in anothe
worksheet which is sorted properly by date. I place at the head of th
column the date I want selected and use a concatenate to try and ge
the Vlookups in the column to go to a different date on the remot
worksheet. I have delineated the remote worksheet with the usua
$B4:$D256 and just try and change the column heading date to picku
data for different dates. This used to be called a computed go t
statement and in basic is popular in IF statements. I can make three o
my columns work perfectly well and I am pleased with the results which
check closely from time to time. When I place a current date (seria
number) in the column heading in order to pick up recent instead o
historical data, i.e. in the last 4 or 5 days, that particular colum
simply does not work and I have to spend hours 'hand coding' each ro
in that column in order to get my data which drives me to distraction.
Any help would be most appreciated
worksheet which is sorted properly by date. I place at the head of th
column the date I want selected and use a concatenate to try and ge
the Vlookups in the column to go to a different date on the remot
worksheet. I have delineated the remote worksheet with the usua
$B4:$D256 and just try and change the column heading date to picku
data for different dates. This used to be called a computed go t
statement and in basic is popular in IF statements. I can make three o
my columns work perfectly well and I am pleased with the results which
check closely from time to time. When I place a current date (seria
number) in the column heading in order to pick up recent instead o
historical data, i.e. in the last 4 or 5 days, that particular colum
simply does not work and I have to spend hours 'hand coding' each ro
in that column in order to get my data which drives me to distraction.
Any help would be most appreciated