ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   AUTO FILL (https://www.excelbanter.com/excel-discussion-misc-queries/258663-auto-fill.html)

Paul

AUTO FILL
 
If I type a value into cell 3H and I want that same value entered
automatically for me in cell 148T what formula would I use. This would make
my job a whole lot easier. Thanks

pmartglass

AUTO FILL
 
in cell 148T type =3h

"Paul" wrote:

If I type a value into cell 3H and I want that same value entered
automatically for me in cell 148T what formula would I use. This would make
my job a whole lot easier. Thanks


Dave Peterson

AUTO FILL
 
Put this formula in T148:

=if(h3="","",h3)



Paul wrote:

If I type a value into cell 3H and I want that same value entered
automatically for me in cell 148T what formula would I use. This would make
my job a whole lot easier. Thanks


--

Dave Peterson


All times are GMT +1. The time now is 05:16 AM.

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