Selected row--->other workbook?
Hi U there!
Probably a stupid question and a simple answer, but for me it's all new... I tried to look but.....
I know there is some kind of way to link one cell from workbook1 to workbook 2.
But how it is done? The cells don't have the same position in both workbooks and I don't need to copy all the information.
Is there a way after linking these too togeher, to make a command button and put some kind of a macro attached to it? So that everytime one selects a row the information copies into woorkbook and then prints it..? Dont have to save the document but I do need 6 prints of the workbook2? Then selecting another row in workbook1 and doing the same all over again...:doh:
If something like this exists, it would help my work tremendously... Now I am adding the information manually by copying and pasting and printing...
You can imagine I do this about to 80-100 rows a day, 6 copies of each, about 20 cells to link....
So any help is more than wellcomed,
-erin-