Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I am a bit stuck, I want to update a worksheet but keep previous data in another column but I am stuggling to find a way. What i want to do is, A1 has my present data and when I update that data I want the old data to automatically move to B1. This will enable me to keep both the present and previous data without cutting and pasting data. Can anyone help. Regards Steve |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select the cells that are important to you. Under the Edit toolbar, click
copy, and then right-click in Cell B1, click paste special, and then click values. I think this will give you what you want...but it doesn't require an If/Else function... Well, I hope that works for you. Regards, Ryan-- -- RyGuy "sby" wrote: Hi I am a bit stuck, I want to update a worksheet but keep previous data in another column but I am stuggling to find a way. What i want to do is, A1 has my present data and when I update that data I want the old data to automatically move to B1. This will enable me to keep both the present and previous data without cutting and pasting data. Can anyone help. Regards Steve |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for that but I was looking for an automated system as they are
numerous cells. Can anyone help. "ryguy7272" wrote: Select the cells that are important to you. Under the Edit toolbar, click copy, and then right-click in Cell B1, click paste special, and then click values. I think this will give you what you want...but it doesn't require an If/Else function... Well, I hope that works for you. Regards, Ryan-- -- RyGuy "sby" wrote: Hi I am a bit stuck, I want to update a worksheet but keep previous data in another column but I am stuggling to find a way. What i want to do is, A1 has my present data and when I update that data I want the old data to automatically move to B1. This will enable me to keep both the present and previous data without cutting and pasting data. Can anyone help. Regards Steve |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you right-click in A1, it will give you the option to Insert & shift
cells right. -- David Biddulph "sby" wrote in message ... Hi I am a bit stuck, I want to update a worksheet but keep previous data in another column but I am stuggling to find a way. What i want to do is, A1 has my present data and when I update that data I want the old data to automatically move to B1. This will enable me to keep both the present and previous data without cutting and pasting data. Can anyone help. Regards Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |