ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   hide show question (https://www.excelbanter.com/new-users-excel/235253-hide-show-question.html)

pcor

hide show question
 
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

Shane Devenshire[_2_]

hide show question
 
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


Don Guillett

hide show question
 
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



Don Guillett

hide show question
 

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





All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com