Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Store the values in next sheet [Closed]

Report
Posts
1
Registration date
Tuesday January 21, 2014
Status
Member
Last seen
January 21, 2014
 -
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
 -
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
See more

1 reply

Answer 1 / 1
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
 448
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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!