How to keep history of data changes in excel for examination [closed]
I work in a manufacturing plant and we are trying to keep track of how often we are replacing parts on specific sub-assemblies. Each sub-assembly contains multiple parts that are not changed at the same times. The sheet currently contains the list of parts in one column and their dates of last replacement in the next column. As the date of last replacement is updated, we'd like to have a way to store all the prior dates of replacement for each part.
So essentially, we're trying to keep a sheet that will show each part's date of last replacement as well as have all the prior dates that is was replaced. The past dates can either be stored in the same sheet or in a separate sheet.
Any help would be appreciated. I do not have much of a background in coding.
microsoft-excel
asked Jan 31 at 16:46
IsaacFIsaacF
11
closed as too broad by music2myear, fixer1234, Mike Fitzpatrick, Debra, Pimp Juice IT Feb 15 at 20:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I work in a manufacturing plant and we are trying to keep track of how often we are replacing parts on specific sub-assemblies. Each sub-assembly contains multiple parts that are not changed at the same times. The sheet currently contains the list of parts in one column and their dates of last replacement in the next column. As the date of last replacement is updated, we'd like to have a way to store all the prior dates of replacement for each part.
So essentially, we're trying to keep a sheet that will show each part's date of last replacement as well as have all the prior dates that is was replaced. The past dates can either be stored in the same sheet or in a separate sheet.
Any help would be appreciated. I do not have much of a background in coding.
microsoft-excel
asked Jan 31 at 16:46
IsaacFIsaacF
11
closed as too broad by music2myear, fixer1234, Mike Fitzpatrick, Debra, Pimp Juice IT Feb 15 at 20:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
1
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50
add a comment |
I work in a manufacturing plant and we are trying to keep track of how often we are replacing parts on specific sub-assemblies. Each sub-assembly contains multiple parts that are not changed at the same times. The sheet currently contains the list of parts in one column and their dates of last replacement in the next column. As the date of last replacement is updated, we'd like to have a way to store all the prior dates of replacement for each part.
So essentially, we're trying to keep a sheet that will show each part's date of last replacement as well as have all the prior dates that is was replaced. The past dates can either be stored in the same sheet or in a separate sheet.
Any help would be appreciated. I do not have much of a background in coding.
microsoft-excel
asked Jan 31 at 16:46
IsaacFIsaacF
11
I work in a manufacturing plant and we are trying to keep track of how often we are replacing parts on specific sub-assemblies. Each sub-assembly contains multiple parts that are not changed at the same times. The sheet currently contains the list of parts in one column and their dates of last replacement in the next column. As the date of last replacement is updated, we'd like to have a way to store all the prior dates of replacement for each part.
So essentially, we're trying to keep a sheet that will show each part's date of last replacement as well as have all the prior dates that is was replaced. The past dates can either be stored in the same sheet or in a separate sheet.
Any help would be appreciated. I do not have much of a background in coding.
microsoft-excel
microsoft-excel
asked Jan 31 at 16:46
IsaacFIsaacF
11
asked Jan 31 at 16:46
IsaacFIsaacF
11
asked Jan 31 at 16:46
IsaacFIsaacF
11
asked Jan 31 at 16:46
IsaacFIsaacF
11
asked Jan 31 at 16:46
IsaacFIsaacF
11
11
closed as too broad by music2myear, fixer1234, Mike Fitzpatrick, Debra, Pimp Juice IT Feb 15 at 20:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by music2myear, fixer1234, Mike Fitzpatrick, Debra, Pimp Juice IT Feb 15 at 20:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
1
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50
add a comment |
1
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50
1
1
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50
add a comment |
1 Answer
1
active
oldest
votes
The sheet currently contains the list of parts in one column and their dates of last replacement in the next column.
The most simple method:
Place the cursor on the "last change date" for a replaced part, then do
- Insert Cell (CTRL++),
- select "Shift Cells Right"...
- and type in the new date.
End result: The earlier date(s) remain to the right of the latest date.
answered Jan 31 at 17:11
HannuHannu
4,1551925
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The sheet currently contains the list of parts in one column and their dates of last replacement in the next column.
The most simple method:
Place the cursor on the "last change date" for a replaced part, then do
- Insert Cell (CTRL++),
- select "Shift Cells Right"...
- and type in the new date.
End result: The earlier date(s) remain to the right of the latest date.
answered Jan 31 at 17:11
HannuHannu
4,1551925
add a comment |
The sheet currently contains the list of parts in one column and their dates of last replacement in the next column.
The most simple method:
Place the cursor on the "last change date" for a replaced part, then do
- Insert Cell (CTRL++),
- select "Shift Cells Right"...
- and type in the new date.
End result: The earlier date(s) remain to the right of the latest date.
answered Jan 31 at 17:11
HannuHannu
4,1551925
add a comment |
The sheet currently contains the list of parts in one column and their dates of last replacement in the next column.
The most simple method:
Place the cursor on the "last change date" for a replaced part, then do
- Insert Cell (CTRL++),
- select "Shift Cells Right"...
- and type in the new date.
End result: The earlier date(s) remain to the right of the latest date.
answered Jan 31 at 17:11
HannuHannu
4,1551925
The sheet currently contains the list of parts in one column and their dates of last replacement in the next column.
The most simple method:
Place the cursor on the "last change date" for a replaced part, then do
- Insert Cell (CTRL++),
- select "Shift Cells Right"...
- and type in the new date.
End result: The earlier date(s) remain to the right of the latest date.
answered Jan 31 at 17:11
HannuHannu
4,1551925
answered Jan 31 at 17:11
HannuHannu
4,1551925
answered Jan 31 at 17:11
HannuHannu
4,1551925
answered Jan 31 at 17:11
HannuHannu
4,1551925
4,1551925
add a comment |
add a comment |
1
It appears that you are asking us to provide you with a full solution. This isn't really what SU is for. Please let us know what you have tried, where it has worked/failed, what your research has shown you already. Use the EDIT button to add this any other relevant information to the body of the question itself.
– music2myear
Jan 31 at 17:50