how do I validate an entire colume instead of a cell
I have multiple columns of prices and I want to use one cell, the header
cell, to populate all the cells in my price sheet column once I choose the header price I want. I have tried cell validation but that only does one cell at a time and I want to do the whole column from one cell. Please help! |
how do I validate an entire colume instead of a cell
Select A1:A100
Type a price in A1 then hit CTRL + ENTER Gord Dibben MS Excel MVP On Thu, 19 Mar 2009 12:26:01 -0700, de_diver wrote: I have multiple columns of prices and I want to use one cell, the header cell, to populate all the cells in my price sheet column once I choose the header price I want. I have tried cell validation but that only does one cell at a time and I want to do the whole column from one cell. Please help! |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com