Using Excel, How do you copy and link random cells under each other to a different page of Worksheet.?

Question

after entering a value in a cell, need to copy and link to another sheet.

The linkage would add lines under each other even if a cell is 10 rows down from each other

I thank you for any help.

Answer 1

You need to record a macro which does the following:

1) Copies the cell data from your original worksheet

2) Inserts a new row into your new worksheet (this way everything will shift down when new data is pasted in) - action is to be done after you actually right click and click copy.

3) Paste special - values only (prevents data from being overwritten) into your new row)

4) hit esc and go back to the local you started at (looks better generally)

to record a macro: go to Tools>macro>record new macro

when finished , view the drawing or forms toolbar to create a button and right click on the button to assign the macro.

hope that helps !

Answer 2

Go to the cell in the second sheet where you want to put the value from the first sheet.

Type "=" and go to the first sheet where you had entered your value and click on it. Press enter and the link is created and Excel put you back to the second sheet where your value now appears. Copy this link down or anywhere in this second sheet and the corresponding value from the first sheet appears. This is a live link so if you change the value in the first sheet it changes in the second sheet. If you do not want the linked cells to change tnen after you enter your values in the first sheet then go to the second sheet highlight the whole thing the do "copy>paste special>values" to destroy the links.

Answer 3

I have created a small macro that might address this issue, if this isn't what you need, feel free to e-mail me via Y-Answers

http://www.savefile.com/files/1743226