Re: $$Excel-Macros$$ Help required on formula

2014-03-31 Thread Jocky Beta
Please help Regards On 3/29/14, Jocky Beta wrote: > Hi pramod, > > Please find the attached sheet in which i had explain what i required, > Request you to kindly go through it and help me to solve the problem. > > Regards > > > On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote: > >> hey what

Re: $$Excel-Macros$$ Copy data from multiple sheets into single sheet.

2014-03-31 Thread sunil lobo
there is a tool namely an addd-in called rdbmeger can be installed on to excel ,,, the benefits of this is that multiple sheet data with same column can be combined on to one single sheet plus different workbook sheet can also be combined on to one sinlge worksheet do a google if not get in touch c

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

2014-03-31 Thread Michael Stokes
Ashish - You are a very talented star! The code works perfectly. Thank you so much. Michael On Sat, Mar 29, 2014 at 12:47 PM, ashish koul wrote: > Sub test() > Dim filenm As String, folderpath As String > folderpath = "C:\Documents and Settings\Ashish Koul\Desktop\sample > files\" >

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

2014-03-31 Thread Ravinder
Note:- add word library "Microsoft Word library " This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG

$$Excel-Macros$$ VBA Code to Import Excel table in Word file

2014-03-31 Thread amar takale
Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving & easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you