I have two excel sheets, A.xls & B.xls. A has five work sheets named as monday, tuesday , wednesday, thrusday, friday. worksheet monday has four numbers A111, B222, C333, D444 on C5, C6, C7, C8. And rest of the sheets has different four numbers on same position.
B has four work sheets called GB, DE, FR, US. On wednesday, if FR Sheet open it will have a option to print number of copies. If we select 3 then it should pickup wednesday sheet from A.xls and pick A111, B222, C333 numbers on each sheet you print on one position (D3) of FR sheet. Is it possible. How?
Regards,
- Mahen
B has four work sheets called GB, DE, FR, US. On wednesday, if FR Sheet open it will have a option to print number of copies. If we select 3 then it should pickup wednesday sheet from A.xls and pick A111, B222, C333 numbers on each sheet you print on one position (D3) of FR sheet. Is it possible. How?
Regards,
- Mahen