Re: $$Excel-Macros$$ vlookup -please help on the attachment

hi Smitha i hope this is your requirement PFA Regards: CMA Ankur Pandey On Mon, Jun 18, 2012 at 11:28 AM, Smitha S R wrote: > Hi, > > PFA my vlookup table. If I select the nature of expenses, corresponding > expenses main head should come from the second worksheet anemd data2. > But the ma

Re: $$Excel-Macros$$ Attendance tracker 2012

Hi Santosh, Thanks for resolving the query. See the below few conditions i needed. And if you have any doubt send me an email. *See if amt is "0" without any comment it should be "L".**See if the amt is "0" with comment It should be "COMP","LOP","J","UL","M",* based on comments i need the resul

$$Excel-Macros$$ vlookup -please help on the attachment

Hi, PFA my vlookup table. If I select the nature of expenses, corresponding expenses main head should come from the second worksheet anemd data2. But the main head coming in the first work sheet is wrong. Please help on this. Regards Smitha -- FORUM RULES (986+ members already BANNED for violat

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

Dear Avinash. Sub gg() For a = 1 To Sheets.Count Sheets(a).Activate Range("a1:dd5").Select Selection.Font.Bold = True Next End Sub Regard Manoj On Sun, Jun 17, 2012 at 11:39 PM, Avinash wrote: > Dear Experts, > > I have 1 workbook and there are 10 subsheets in that workbook. > i hav

RE: $$Excel-Macros$$ Macro for column size reduction

Thanks a lot for solutions.. Best Regards, Amit -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: 17 June 2012 16:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for column size reduction use t

$$Excel-Macros$$ Progress Bas for macro status - Help Required

Dear Experts, I have 1 workbook and there are 10 subsheets in that workbook. i have created 1 macro to format those 10 subsheets. every sheet does have different formatting e.g. sheet 1 bold text for row 1 and and sheet 2 bold italic text for row 2. so now i want macro to show the progress bar (

Re: $$Excel-Macros$$ Saving Photos from webpage

Hi Chilexcel, Thanks for your reply. I will check and let you know at the earliest. Thanks & Regards, Kiran On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel wrote: > Please see attached > > Used DownThemAll , add on firefox (To use DownThemAll, simply open a > Web page in Firefox, click Tools fr

Re: $$Excel-Macros$$ Attendance tracker 2012

Hi All, Please resolve this query whether using formula or an macro. I am waiting for your reply do the needful. Regards Lokesh.M On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki wrote: > Hi Experts, > > Till now i did not get any updates from the below request. Please do the > needful brothers. >

Re: $$Excel-Macros$$ Macro for column size reduction

use this macro Sub gg() Selection.ColumnWidth = 5 End Sub you can change column width as per your need On 6/17/12, Ahmed Honest wrote: > Dear Amit, > > May be I'm not sure whether you are familiar with this Or this is what you > are looking for i.e for making all columns adjust according

$$Excel-Macros$$ Saving Photos from webpage

Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified l

Re: $$Excel-Macros$$ Macro for column size reduction

Dear Amit, May be I'm not sure whether you are familiar with this Or this is what you are looking for i.e for making all columns adjust according to the Raw Data in a sheet you do this >> Ctrl + A to select entire sheet and after this Alt + O + C + A. Hope this helps. On Sun, Jun 17, 2012 at

Re: $$Excel-Macros$$ Macro for column size reduction

You mean column width? Sam On Sun, Jun 17, 2012 at 2:38 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Does anyone have a macro to reduce column size all together? > > ** ** > > Best Regards, > > Amit > > ** ** > > -- > Disclaimer: This

Re: $$Excel-Macros$$ Translating

Hi All, Thanks for your reply. Thanks & Regards, Kiran On Sat, Jun 16, 2012 at 3:19 AM, Asa Rossoff wrote: > Good day Kiran, > > ** ** > > *To manually translate,* you can go to the Research task pane > select > Translation > select language pair > search for a word or phrase. > > **·

$$Excel-Macros$$ Macro for column size reduction

Dear Friends, Does anyone have a macro to reduce column size all together? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for

Re: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell

Dear ASA, It was great, worked as I wanted Thanks you for help, all experts who helped in this issue Regards, Prashant On Sun, Jun 17, 2012 at 5:57 AM, Asa Rossoff wrote: > My post should work, but I made a "boo boo". The SizeColumns macro should > not have Set Workbook=Nothing at the end. W

$$Excel-Macros$$ Re: Attendance tracker 2012

Hi Lokesh, I'm not expert of macros but following condition you can achieve by using combination of "Match & vlookup". Regards, Suyog On Friday, 15 June 2012 17:51:42 UTC+5:30, lokesh wrote: > > Hi Experts, > > I need a help from you, i have attached excel file with the following > conditiona