Store the values in next sheet
Closed
jagadevaraj
Posts
1
Registration date
Tuesday January 21, 2014
Status
Member
Last seen
January 21, 2014
-
Jan 21, 2014 at 01:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 21, 2014 at 10:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 21, 2014 at 10:48 AM
Dear All,
I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below,
CABLE NO -1
LOAD -18.5
VOLTAGE -415
CURRENT -37
EFFCIENCY-0.9
if i enter cable no is 1(assume cell is sheet1 B4), then the all values( voltage, current...) is store in next sheet row one(b1,c1,d1,e1 of sheet2), then if i enter the cable no is 2, the corresponding values are store in row 2(b2,c2,d2,e2) of the next sheet, don't over right in first row values, if i enter cable no is 3, then store the values in row 3, please help (either in macro or xl)
Thanks
Jagadesh
I have doubt in xl sheet, I have two xl sheet , i show the first sheet parameter as below,
CABLE NO -1
LOAD -18.5
VOLTAGE -415
CURRENT -37
EFFCIENCY-0.9
if i enter cable no is 1(assume cell is sheet1 B4), then the all values( voltage, current...) is store in next sheet row one(b1,c1,d1,e1 of sheet2), then if i enter the cable no is 2, the corresponding values are store in row 2(b2,c2,d2,e2) of the next sheet, don't over right in first row values, if i enter cable no is 3, then store the values in row 3, please help (either in macro or xl)
Thanks
Jagadesh
Related:
- Store the values in next sheet
- Microsoft store download - Download - App downloads
- Tentacle locker 2 app store - Download - Adult games
- Sheet right to left in google sheet - Guide
- Play store download zip - Download - App downloads
- Windows network commands cheat sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 21, 2014 at 10:48 AM
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
