I have names in col A that go from row 1 to row 1000
I then place data(numbers) in col B that corresponds with the name in col A.
Once done I show ONLY the rows that have new data(filter)and use the SPEAK
function to read the data back to me.
Here is the tough part. On subsequent weeks I enter data in col B again and
I want to be able to apply the SPEAK function BUT ONLY to the LAST set of
inputted data.
aDoes anyone have a good way to implement htis
Thanks

Hi,

It sounds like you need to add a date column to your data so you can filter
on that.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pcor" wrote:

I have names in col A that go from row 1 to row 1000
I then place data(numbers) in col B that corresponds with the name in col A.
Once done I show ONLY the rows that have new data(filter)and use the SPEAK
function to read the data back to me.
Here is the tough part. On subsequent weeks I enter data in col B again and
I want to be able to apply the SPEAK function BUT ONLY to the LAST set of
inputted data.
aDoes anyone have a good way to implement htis
Thanks

Viewtoolbarsformula bar

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pcor" wrote in message
...
I have names in col A that go from row 1 to row 1000
I then place data(numbers) in col B that corresponds with the name in col
A.
Once done I show ONLY the rows that have new data(filter)and use the
SPEAK
function to read the data back to me.
Here is the tough part. On subsequent weeks I enter data in col B again
and
I want to be able to apply the SPEAK function BUT ONLY to the LAST set of
inputted data.
aDoes anyone have a good way to implement htis
Thanks

I answered the wrong post
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Viewtoolbarsformula bar

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pcor" wrote in message
...
I have names in col A that go from row 1 to row 1000
I then place data(numbers) in col B that corresponds with the name in col
A.
Once done I show ONLY the rows that have new data(filter)and use the
SPEAK
function to read the data back to me.
Here is the tough part. On subsequent weeks I enter data in col B again
and
I want to be able to apply the SPEAK function BUT ONLY to the LAST set of
inputted data.
aDoes anyone have a good way to implement htis
Thanks