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 January 16, 2023 - 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

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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
0