-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to insert number in differant cells
- Thread starter Waynecu1
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,638
- Office Version
- 365
- Platform
- Windows
We don't know how you want it to work. Can you explain what you want in more detail? (This is all that was asked in your other post)
Upvote
0
OK maybe I'll try to explain it better
I want to be able to have formula to place data or text in 2 differnt cells automaticly so that I do not have to a lot of copy/cut paste
Exsample Let's say in cell A1 I enter the number 72 then also have the data /text 72 from A1 placed in Cell C366 I what I done in past was
data/text =A1 then I type in cell C366 =a1 so data that is in A1 will show up in Cell c366.
Would it better better to have a forumla to do this then and keep typing in formation over and over. Marco does work but I think a formula is better NO ?
I want to be able to have formula to place data or text in 2 differnt cells automaticly so that I do not have to a lot of copy/cut paste
Exsample Let's say in cell A1 I enter the number 72 then also have the data /text 72 from A1 placed in Cell C366 I what I done in past was
data/text =A1 then I type in cell C366 =a1 so data that is in A1 will show up in Cell c366.
Would it better better to have a forumla to do this then and keep typing in formation over and over. Marco does work but I think a formula is better NO ?
Upvote
0
Similar threads
