Once upon a time, people identified the god Neptune as the source of storms at sea. Today we call these storms hurricanes. The only people who still call hurricanes acts of god are the people who write insurance forms.
Sheet-A contains 365 rows (one for each day of the year), col-1 of each row contains the date and cols 2 thru 10 contain data values.
How can I prepare Sheet-B where Row 1 contains a copy of the row corresponding to Jan 21 on Sheet-A, Row 2 contains a copy of the row corresponding to Feb 21 on Sheet-A Row 3 contains a copy of the row corresponding to Mar 21 on Sheet-A . . . . and so on all the way to the row corresponding to Dec 21 on Sheet-A.
Thanks
Answer from Richard Rost:
Just copy the data from Sheet1 and then PASTE LINK it into Sheet2. This way if the data changes in Sheet1, it's automatically updated into Sheet2.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
