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 |
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 |
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