Store the values in next sheet
Closed
jagadevaraj
TrowaD
- Posts
- 1
- Registration date
- Tuesday January 21, 2014
- Status
- Member
- Last seen
- January 21, 2014
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Store the values in next sheet
- How to transfer values from different sheets in excel - Guide
- Excel copy values from another sheet ✓ - Forum - Excel
- Code to move rows into another sheet based on certain values ✓ - Forum - Excel
- How to auto-populate values from certain cells into a new sheet ✓ - Forum - Excel
- How to name excel sheets on values in columns ✓ - Forum - Excel
1 reply
TrowaD
Jan 21, 2014 at 10:48 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Jan 21, 2014 at 10:48 AM
Hi Jagadesh,
It is not clear to me how your sheet is made up.
On sheet 1 column A is header?
Then column B and on are the values?
If this is true, then copy the data you want to move. Then right-click B1 on sheet 2 and choose paste special, check the transpose option and hit OK.
If I understood you correctly then your query should be solved, otherwise explain in greater detail.
Best regards,
Trowa
It is not clear to me how your sheet is made up.
On sheet 1 column A is header?
Then column B and on are the values?
If this is true, then copy the data you want to move. Then right-click B1 on sheet 2 and choose paste special, check the transpose option and hit OK.
If I understood you correctly then your query should be solved, otherwise explain in greater detail.
Best regards,
Trowa