Re: $$Excel-Macros$$ Conditional copy and row insert based on criteria

can you attach the sample workbook On Sun, Dec 12, 2010 at 10:52 PM, WeitWinkel wrote: > Hi Everybody, I was hoping that anybody in this forum could help me > solve my particular vba problem in Excel. I need to add information > from one sheet to the other based on certain criterias. This is h

Re: $$Excel-Macros$$ Macro to Sort

See if it helps Sub Macro1() Sheets(1).UsedRange.Copy Sheets(2).Select Range("a1").Select ActiveSheet.Paste Columns("B:B").Select On Error GoTo abc Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete abc: Exit Sub End Sub On Mon, Dec 13, 2010 at 3:37

Re: $$Excel-Macros$$ Vlookup in Macro

hi Vaibhav, thanks for this. but i want to dispaly an input box as "*lookfor is not in the rng*" while there is error. On Fri, Dec 10, 2010 at 1:32 PM, wrote: > Hi, > > Add line; > > On error resume next > > Rgds > Vaibhav J > > Sent on my BlackBerry® from Vodafone > --

RE: $$Excel-Macros$$ Error

Hi Vebhav, You seem to be trying to autofill a range based on where the range currently ends. Are you sure you don't want to fill Col 8 as far down as data in an adjacent column? Regards - Dave. Date: Mon, 13 Dec 2010 07:40:24 +0530 Subject: $$Excel-Macros$$ Error From: vebhav.j...@gmail.com

$$Excel-Macros$$ Error

Hi All, Please help me out in rectifying the below error. Selection.AutoFill Destination:=Range(Cells(2, 8), Cells(Rows.Count, 8).End(xlUp)) Regards Vebhav Jain -- -- Some important links for excel users: 1. Follo

$$Excel-Macros$$ Re: Need Excel Formula or VBA Function to Solve the Query.

http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm On Dec 12, 2:14 am, amrahs k wrote: > Dear Experts, > > I have described my query in the attached workbook. I need excel formula or > any appropriate function to solve my query. > > Please help me on this. > > Looking forward t

$$Excel-Macros$$ Macro to Sort

Is there a way to? If B2 thru B8 is complete with all information then Delete info and send to Sheet 2. With B2 thru B8 now empty then more everything up. Keeping everything together. Same thing with rest of info. For example if B18 thru B24 is Incomplete and B10 thru B16 is complete then Delete

$$Excel-Macros$$ Conditional copy and row insert based on criteria

Hi Everybody, I was hoping that anybody in this forum could help me solve my particular vba problem in Excel. I need to add information from one sheet to the other based on certain criterias. This is how my information looks like: Sheet "Source" Code|Description|Explanation|RollupGroup AA|Color:Gr

$$Excel-Macros$$ need chart factor

dear sir i here with enclose dip chart to density find factor i have two different temp charts please find to make other temperature values anybody knows please help what is the formula thanks regards, mohanraj --

Re: $$Excel-Macros$$ Re: Need Excel Formula or VBA Function to Solve the Query.

Brilliant! Thanks for your support Ayush. Best Regards, Sharma On Sun, Dec 12, 2010 at 1:35 PM, Ayush wrote: > Dear Sharma, > > Attached is the solution. I have used COUNTIFS formula to get this done. > I hope it helps. Please let us know if any further assistance is required. > > Thanks. > > B

$$Excel-Macros$$ VBA Macros Code examples : Import a PDF in Excel

Ayush Jain has sent you a link to a blog: Dear Members, I keep getting queries to import a PDF file into excel sheet. Here is the macro for same. Please try and let me know if you have any feedback. Thanks. Best Regards, Ayush Jain Microsoft MVP Blog: VBA Macros Code examples Post: Import a PDF i