Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread XLS S
Hey Kaushik, can you attach the worksheet and also..easy way to make link file..just create workbook shortcut and use On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA wrote: > Query on paste link - Should i select each worksheet of workbook and > do the paste specia

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Venkat CV
Hi Kaushik You Have to Select Entire Page on Copying time as well Paste special and use As told Mr XLS S Steps *Best Regards,* *Venkat * *Chennai* On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA wrote: > Query on paste link - Should i select each worksheet of workbook and > do the paste spec

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread KAUSHIK SAVLA
Query on paste link - Should i select each worksheet of workbook and do the paste special value paste link? If so then is there any shortcut to link whole workbook to another workvook. Regards, Kaushik On 8/4/11, XLS S wrote: > Use paste special with paste link.. > > On Wed, Aug 3, 2011

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread XLS S
Use paste special with paste link.. On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote: > Hi All, > How to import only selected data from another workbook? > Please help. > > Regards, > Kaushik > > -- > Sent from Gmail for mobile | mobile.google.com > > Kaushik Savla > > -- > ---

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Jorge Marques
if your data format doesn´t change i recomend using links, i use links for a database which doesn´t change the format, but i have another database i have to add new data every month which is always changing values and cells, for that i use a copy paste macro which copies all the data by selecting c

Re: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Venkat CV
Hi Kaushik, We can Copy Paste Else Link the Cells as Required data by using data linking...workbook 1 to Workbook 2 *Best Regards,* *Venkat * *Chennai* On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote: > Hi All, > How to import only selected data from another workbook? > Please help. > > Reg

RE: $$Excel-Macros$$ Help required on Importing Data

2011-08-03 Thread Rajan_Verma
Hi kaushik, I think copy and paste is the best option for this Regards Rajan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday, August 03, 2011 4:47 PM To: excel-macros@googlegroups.com Subject: $$Exce