how can i copy the contents of 2 cells in eve

February 9, 2011 at 02:18:11
Specs: Windows XP
I have a workbook with different sheets. I want to copy the contents of the cells C11 and B2 of every worksheet to a different workbook. Can somebody help me in doing this.

See More: how can i copy the contents of 2 cells in eve

Report •


#1
February 9, 2011 at 04:56:25
Are you looking for the syntax for a formula?

='C:\Documents and Settings\user name\My Documents\[Book1.xls]Sheet1'!$C$11

Replicate for each sheet.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question