$$Excel-Macros$$ Re: Move coloum

2015-05-07 Thread Mandeep Baluja
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. Current it combine multiple sheet in one column. I need to copy each sheet to one column, Like

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

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 rockerna...@gmail.com 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

$$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) = Then

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 pankaj123...@gmail.com 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

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. -- Chethan