ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help for multiple entries (https://www.excelbanter.com/excel-discussion-misc-queries/264536-re-need-help-multiple-entries.html)

Mike Rogers[_2_]

Need help for multiple entries
 
Karl

Put this formula in all the cells you want to match your input cell. In
this case A1.

=A1

Now when you enter anything into A1 it will show up in all cells that have
your formula

Mike Rogers

"Karl" wrote:

Hi I want to be able to put say the letter A in column A-1 but want a formula
that wil also put the same letter A in like 6 more times for instance B-2,
C-3, D-4, E-5,F-6,G-7. All with just the one entry in A-1. Thanks Karl



All times are GMT +1. The time now is 12:41 PM.

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