Re: $$Excel-Macros$$ excel Macro

2015-05-07 Thread Pankaj Sharma
like this On Sat, Apr 18, 2015 at 3:32 PM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi > > Please help me with macro code. I am trying to send file to each > individual. > > I need to filter and send the file to each individual. Current i have > macro it work on person. > > > > --

$$Excel-Macros$$ Copy PDF data to Excel macro require

2015-05-07 Thread Pankaj Sharma
Hi everyone, Need your help for this easy. I have a folder with multi PDF files. I need a macro to copy all pdf data in a workbook. Note: One pdf data should be copy in one sheet. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread Pankaj Sharma
r u looking for this ?? Sub Combine() Dim J As Integer Dim rey As Range On Error Resume Next Sheets(1).Select Worksheets.Add Sheets(1).Name = "Combined" Sheets(1).Activate For J = 2 To Sheets.Count Sheets(J).Activate Range("A:A").Copy Sheets("Combined").Select If Range("XFD1").End(xlToLeft) = ""

Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
Thank Pankaj It work perfect. Yes i was looking for something like these On Thu, May 7, 2015 at 7:28 PM, Pankaj Sharma wrote: > r u looking for this ?? > > Sub Combine() > Dim J As Integer > Dim rey As Range > > On Error Resume Next > Sheets(1).Select > Worksheets.Add > Sheets(1).Name = "Combin

Re: $$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread B.N.Chethan Kumar
Yes. it is single column "A:A" On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja wrote: > how is your sheet data.??? it contain a single column or multiple columns > ?? > > > > > On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote: >> >> Hi, >> >> I need some help in modify the Macro.

Re: $$Excel-Macros$$ find exact value contains special characters like *, ?, #, " excel cells using match function

2015-05-07 Thread Mandeep Baluja
Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the *Find and Replace*dialog box to find or replace a character such as a tilde (~), an asterisk (*), or a question mark (?), you must add a tilde (~) before the character in the *Find