LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Enter a number on different cells automatically ?

Hello,

I want to enter a number on different cells automatically. I want to
do this so I don't need to repeat the process again and again. I want
to enter a number on cell A3 and the same number will appear on cell
A6, A9, A12, A15 and A18 automatically. When I delete the number on
cell A3, the number will also dissapear from cell A6, A9, A12, A15 and
A18 automatically too.

Example Cell A3 2019

A6 2019

A9 2019

A12 2019

A15 2019

A18 2019


Thank You.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
want to automatically skip certain cells when you hit enter Deedarling1960 Excel Worksheet Functions 2 July 11th 08 11:53 PM
Enter various number of blank lines in cells Jim New Users to Excel 2 March 3rd 08 02:15 AM
HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS danielle Excel Worksheet Functions 4 May 31st 07 09:03 PM
set tab or enter keys to automatically move to different cells J9Y Excel Discussion (Misc queries) 8 November 8th 06 02:29 AM
How do I quickly enter the same number into different cells? Cheers100 New Users to Excel 2 February 18th 06 02:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"