Using Excel
Closed
Charles
-
Jan 9, 2012 at 01:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 17, 2012 at 10:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 17, 2012 at 10:33 AM
Hello,
I'm trying to find the necessary formula or formulas that will let me enter a single or double digit number into one cell, example C3, that will transfer it to another cell, for example, E4 and when entering another number into that same first cell, (C3), will move the first number down one cell, (E5), and replace it with the new number and keep doing this for 7 or 8 cells,(E11). Then the bottom one, (E11) will disappear to nowhere, but the flow will keep going the same direction, just being replaced once a day.
Thank you
Charles Wilkerson
I'm trying to find the necessary formula or formulas that will let me enter a single or double digit number into one cell, example C3, that will transfer it to another cell, for example, E4 and when entering another number into that same first cell, (C3), will move the first number down one cell, (E5), and replace it with the new number and keep doing this for 7 or 8 cells,(E11). Then the bottom one, (E11) will disappear to nowhere, but the flow will keep going the same direction, just being replaced once a day.
Thank you
Charles Wilkerson
Related:
- Using Excel
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 17, 2012 at 10:33 AM
Jan 17, 2012 at 10:33 AM
Hi Charles,
Don't think this can be done by using a formula, so try this code:
To implement the code, right-click on the sheets tab and select "view code". A new window opens up, now copy-paste the code in the big white field. You can close the newly opened window and check if the code does what you want by entering numbers in C3 of that particular sheet.
Best regards,
Trowa
Don't think this can be done by using a formula, so try this code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Integer
If Intersect(Target, Range("C3")) Is Nothing Then Exit Sub
x = 11
Do
Range("E" & x - 1).Copy Destination:=Range("E" & x)
x = x - 1
Loop Until x = 4
Range("C3").Copy Destination:=Range("E4")
End Sub
To implement the code, right-click on the sheets tab and select "view code". A new window opens up, now copy-paste the code in the big white field. You can close the newly opened window and check if the code does what you want by entering numbers in C3 of that particular sheet.
Best regards,
Trowa
