now that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
--- On Sat, 30/8/08, Ravi Megharaj <[EMAIL PROTECTED]> wrote:
From: Ravi Megharaj &l
Hi Darshan,
Thank you so much for this code.
For the following code to work it is necessary that all the other files
namely sales and Emp_Info must be opened. But I do not want to open those
files. All these files are saved in a particular location say on E:\Data.
Hence, I will open only file Con
Use following code
Sub copy_data()
Windows("Consolidated").Activate
Sheets("sales").Select
Windows("Sales").Activate
Range("a2:b7").Select
Selection.Copy
Windows("Consolidated").Activate
Sheets("sales").Select
Range("a2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, Sk
