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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 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

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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