![]() |
Naming Ranges
Hi all,
i have a range of six columns that data is entered to (ID,Name,Position,Department,Salary,Overtime) and I want the name of the range expand everytime i enter a new record as all filled cells are included in the range and blank cells are ingored. I thank you in advance and i really appreciate your help regards, naweed |
Naming Ranges
check debra's site
http://www.contextures.com/xlNames01.html#Dynamic -- Gary wrote in message ups.com... Hi all, i have a range of six columns that data is entered to (ID,Name,Position,Department,Salary,Overtime) and I want the name of the range expand everytime i enter a new record as all filled cells are included in the range and blank cells are ingored. I thank you in advance and i really appreciate your help regards, naweed |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com