$$Excel-Macros$$ Re: Need Help....!

Hi.. Thank you very much. You've helped me greatly.. I am really delighted. Thanks a lot. Wish you all the very best in your life. Take care Bye Krishna Kishore Friendship SMS

$$Excel-Macros$$ Re: Need Help....!

Hi.. Yes. This helped me a lot. This was exactly what I was looking for. Thank you very much. Have a great weekend. Take care Bye Krishna Kishore Friendship SMS _ From: e

$$Excel-Macros$$ Re: How to run the macro only if data available else stop.

Looks nice. As I have understood it, you first paste the .CSV on the main tab at the bottom. And then you run the macro. The macro, vlooksup() the new rows in Main tab with the previous rows in the Main Tab to get the values for the 6 rightmost columns. Is it right? Further, you want to ensure that

$$Excel-Macros$$ How to use several variables at once in for loops correctly

I have a very short macro snippet here that I need to iterate several times: Sub Macro1() ' Sheets("Detail").Select Range("ES3").Select Selection.Copy Sheets("Price List").Select Range("W12").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks

$$Excel-Macros$$ Re: Need Help....!

Set up the table (2nd table) with headers (required Period Slabs) and use the following formulas, Less Than 6 months Formula =SUM(IF(DATEDIF(B2:B7,TODAY(),"m") < 6,1)) 6 Months To 1 Year =SUM(IF(DATEDIF(B2:B7,TODAY(),"m") >= 6,IF(DATEDIF(B2:B7,TODAY(),"m") <= 12,1))) 1 year To 2 Years =SUM(IF(

$$Excel-Macros$$ Re: Need Help....!

Hello, My idea is as follows. (Someone may come with better ideas.) Assuming that you have names in column-A and dates in column-B; 1. First of all create the function (after the instructions) in your VBA module. Maybe copy-pasted. 2. In cell C2 you can write following formula against the dates "=d

$$Excel-Macros$$ Re: Page numbering in excel

Hi, For the first excel give manual page numbering. For example: 21 in page number field and from next sheet use "Auto". If you preview the sheets indivdiuallay, page numbering may not be in sequenece. But, if you preeiw the whole work book, page numbers will be in sequene. Thansk and regards, Na