Re: $$Excel-Macros$$ Subtotal

Hi Usha, check the attached file, see if this helps u out... Regards, Manoj Kumar On Fri, Jan 28, 2011 at 10:35 AM, Usha Negi wrote: > Dear All, > > Good morning! > > I want to do subtotal on quarterly basis in the attached excel sheet. Could > you please help me out on this? Is there any for

Re: $$Excel-Macros$$ Help With UserForms

Hello Hanumant Thanks a lot for your efforts. As always, this group has once again helped me to quickly solve my problems within the shortest possible time. Yes, I agree that many data validations are yet to be done. However, ideas are bouncing off me as I progress. Hopefully, ideas at a late

Re: $$Excel-Macros$$ Help With UserForms

Hello Brian In fact, I was similarly looking for the drop down selection process in the Combobox1 and Combobox2 to understand it better myself. I too, was unable to decipher the code suitably. But to be honest, I have not looked at the code in detail. I was rather hoping to do it over the wee

$$Excel-Macros$$ Subtotal

Dear All, Good morning! I want to do subtotal on quarterly basis in the attached excel sheet. Could you please help me out on this? Is there any formula to do subtotal/total on quarterly basis Pls. see attached file. Thanks & regards, Usha -- -

Re: $$Excel-Macros$$ Extracting Data from Multiple worksheets using 2 Criterias

please send us a sample file... Regards, Manoj Kumar On Fri, Jan 28, 2011 at 4:30 AM, SK wrote: > Hello Experts, > > I have a file which has 11 tabs. The 10 have same template with first > row being the heading. The 11th sheet is suppose to be used as a > summary report sheet that pulls data f

Re: $$Excel-Macros$$ Extracting Data from Multiple worksheets using 2 Criterias

hi SK attach one sample file for clear understanding On Fri, Jan 28, 2011 at 4:30 AM, SK wrote: > Hello Experts, > > I have a file which has 11 tabs. The 10 have same template with first > row being the heading. The 11th sheet is suppose to be used as a > summary report sheet that pulls data from

Re: $$Excel-Macros$$ query for a solution

hi tamu thnks for quick reply i need only bill no. and amount in single row. for every unique id new row is needed. max 50 bill no. are their in respect to a single unique id. i hope now i m clear . On Thu, Jan 27, 2011 at 4:59 PM, TG T wrote: > Dear Ankur Pandey > > You cannot able to keep

Re: $$Excel-Macros$$ Help With UserForms

this macro is adding the data to combo box before you make form visible if you check sheet1 cell d23 , d24, etc or a23, a24 its having values these values are added to combobox1 Sub OpenDetails() Dim i As Long For i = 23 To Sheets(1).Range("d23").End(xlDown).Row With OrderForm.ComboBox1 .AddIt

$$Excel-Macros$$ Extracting Data from Multiple worksheets using 2 Criterias

Hello Experts, I have a file which has 11 tabs. The 10 have same template with first row being the heading. The 11th sheet is suppose to be used as a summary report sheet that pulls data from the first 10 sheets based on the following criteria: List all rows if business priority 1 or 2 (column A

Re: $$Excel-Macros$$ Help with nested Vlookup

>From your email client just send an email to excel-macros@googlegroups.comwith the same subject line mentioned in this mail. We all will receive it in the group! Best Regards! Prakash Singh Gusain *Please visit my blog (**click here **)* On Thu, Jan 27, 2011

Re: $$Excel-Macros$$ Count Number of Records in worksheet

this will count everything even no. which are used for rough work. lets us know what exactly u want by sending ur workbook. a = WorksheetFunction.CountA(Sheet1.UsedRange) From: Jitendra Verma To: excel-macros@googlegroups.com Sent: Wed, 26 January, 2011 11:

$$Excel-Macros$$ Office 2010 key

Friends - any body have *Microsoft excel professional plus 2010 key*, version is *14.0.4734.1000 (32 bit)* please share -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Help With UserForms

I am amazed at what you have accomplished very simply but I do not understand where you are storing the information in the Combobox1 and combobox2 for the drop down selection process Please help - I really think I would benefit in my programming by utilising Userforms but I have always shied away

Re: $$Excel-Macros$$ Help with nested Vlookup

I'm using Excel 2007 and would use EITHER excel function or VBA! :o) On Jan 27, 11:55 am, Paul Schreiner wrote: > What version of Excel are you using (Excel 2007 has some additional options) > > Are you hoping for a "Excel Function" solution or a VBA solution? > > Paul > > __

RE: $$Excel-Macros$$ Help with nested Vlookup

Using Excel 07, but will use ANY suggestion, including VBA!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Thursday, January 27, 2011 11:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with nested Vlookup W

$$Excel-Macros$$ Help Required-pdf data conversion

Hi Umesh, I am working on data containing Authorized signatory list and wanted this data on excel. I have all data in pdf version and need to get this on excel. In order to get this done I need your help to get vba coding for the converting pdf data to excel data. Kindly confirm if

Re: $$Excel-Macros$$ Help with nested Vlookup

Can you post the file? It will help us a lot! -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here **)* -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ Help With UserForms

Hello Ashish This file is amazing. Just as I had hoped for. Never ceases to amaze me about the power of excel in the hands of people with expert minds like yours.. :-) :-) Am adding some more stuff to the file. Hope to get it done with as less help as possible. Thanks once again for the b

Re: $$Excel-Macros$$ Help with nested Vlookup

What version of Excel are you using (Excel 2007 has some additional options) Are you hoping for a "Excel Function" solution or a VBA solution? Paul From: Ahleah1031 To: MS EXCEL AND VBA MACROS Sent: Thu, January 27, 2011 11:28:48 AM Subject: $$Excel-Macros$$

$$Excel-Macros$$ Help with nested Vlookup

I have to count the number of claims based on status codes, but also, group the counts based on whether the eff date and pymt dates match or don't match and whether they have a pymt or notSo, the counts would be listed by status, then broken out by 4 columns (dates match w/ pymt), (dates don't

Re: $$Excel-Macros$$ build a database from multiple workbooks

Sub consolidatefromdifferentworkbooks() Application.DisplayAlerts = False 'On Error GoTo abc Dim ask As Workbook Dim ask2 As Workbook Dim ASK3 As Workbook Set ASK3 = ActiveWorkbook Dim i As Long Dim j As Long Dim N, z, r, s, k As Long s = 1 k = 1 Dim x As String Dim temp As String Sheets

Re: $$Excel-Macros$$ build a database from multiple workbooks

put sheetnames always in double quotes Sheets("PRIPRAVA_PROJEKTA"). On Thu, Jan 27, 2011 at 9:23 PM, Seba wrote: > Hi, > > I made the following change for sheet name and I get the error > "Subscript out of range". Sheets(1) -> Sheets(PRIPRAVA_PROJEKTA) > > Sub consolidatefromdifferentworkbooks()

Re: $$Excel-Macros$$ build a database from multiple workbooks

Hi, I made the following change for sheet name and I get the error "Subscript out of range". Sheets(1) -> Sheets(PRIPRAVA_PROJEKTA) Sub consolidatefromdifferentworkbooks() Application.DisplayAlerts = False 'On Error GoTo abc Dim ask As Workbook Dim ask2 As Workbook Dim ASK3 As Workbook Set ASK3

Re: $$Excel-Macros$$ build a database from multiple workbooks

shannur can you attch the sample workbook On Thu, Jan 27, 2011 at 9:13 PM, ashish koul wrote: > > use 2 for second sheet or 3 for 3 rd sheet like > sheets(2).select or you can also sheets("abc").select > > > > > Workbooks.Open Filename:=Sheets(1).Range("a" & i).Value > Set ask2 = ActiveWorkbo

Re: $$Excel-Macros$$ build a database from multiple workbooks

use 2 for second sheet or 3 for 3 rd sheet like sheets(2).select or you can also sheets("abc").select Workbooks.Open Filename:=Sheets(1).Range("a" & i).Value Set ask2 = ActiveWorkbook Sheets(1).Select @shannur can you send a sample workbook On Thu, Jan 27, 2011 at 9:04 PM, shannu shannu

Re: $$Excel-Macros$$ build a database from multiple workbooks

Hi Ashish,   Life and death matter, I have a workbook and again it has diff sheets like sheet 1 to sheet 11. and now my task is to copy unique names from sheet 1 search in other sheets if it is existing then I need to copy only those row from the diff sheets and create a fresh new workbook and n

Re: $$Excel-Macros$$ build a database from multiple workbooks

Hi, it works and it is ok to copy to sheet 1. However I am not able to define from which sheet to copy from. Could you please indicate in the code where am I suppose to insert the name of the sheet to copy from. I didn't see any yellow markings in the code above. I decided to combine this macro w

$$Excel-Macros$$ Differentiating bars on a stacked bar graph based on dates

We have a stacked bar graph that displays 26 4-week periods spanning two years. The requesting department would like to differentiate the colors on the bars for the past year from the colors on the bars for the current year. This is using Excel 2003. When I try to edit the colors for the graph the

Re: $$Excel-Macros$$ Calculate Difference between two dates

first of all, it needs to be a TRUE Excel "DATE", not just a string of characters that LOOK like a date. To determine this, try changing the format to "General". If it is a date, it will convert to a number. That's because to Excel, a "date" is really the number of days since 1/1/1900. So today,

$$Excel-Macros$$ Re: Question on Pivots

Hi, I just checked your file. You need to do a few modifications to your pivot. 1) Click on pivot table. Select Options and make Field List visible. It's the option on top right in Option tab. Remove Insurance , Claims and Reinsurance for Colum Labels. 2) Drag insurance in the sum Values area (rig

Re: $$Excel-Macros$$ Lookup values in different sheets

Dear Amir, IFERROR will not work in excel 2003. Try this one =IF(ISNA(IF(ISNA(VLOOKUP(B6,$E$3:$F$3,2,0)),VLOOKUP(B6,$H$3:$I$3,2,0),VLOOKUP(B6,$E$3:$F$3,2,0))),VLOOKUP(B6,$K$3:$L$3,2,0),"") type the above formula anywhere in worksheet. cel (b6) is taken as lookup value. Thanks & Regards Thamu

Re: $$Excel-Macros$$ Count Number of Records in worksheet

Dear Jitendra, Simply palce the cursor in any other worksheet. for example if you want to count the number of nonblank cells in sheet1, just place the cursor anywhere in sheet2 and =COUNTA(Sheet1!1:65536) Thanks & Regards Thamu On Wed, Jan 26, 2011 at 11:43 PM, Dilip Pandey wrote: > Hi Jit

Re: $$Excel-Macros$$ query for a solution

Dear Ankur Pandey You cannot able to keep it in a single row If you have large amount of data. Because Excel 2003 has only 256 columns and excel 2007 has only 16384 columns. Thanks & Regards Thamu On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote: > hi excel experts > i need one help > i need da

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi Find the attachment. Thanks & Regards Thamu On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour corresponding to his Last Dated > Status. > > Please help me to

Re: $$Excel-Macros$$ build a database from multiple workbooks

hi try this code if the sheets postion or names are fixed from which data is to be merged in all workbooks then simply change below yellow marked line currenty it will copy on sheet 1 from all the workbooks. 2nd - once you get all the file names to be merged you can manually delete that row, fr

Re: $$Excel-Macros$$ Please help to get result through Formule

Hi CS, If you want to color the band. You can Conditional Formatting to get the result. Regards Umesh On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote: > Hello Expert, > > In Attached Sheet i am making a tracker For Attrition In first summary > sheet i have to show Band with Colour correspon

$$Excel-Macros$$ Please help to get result through Formule

Hello Expert, In Attached Sheet i am making a tracker For Attrition In first summary sheet i have to show Band with Colour corresponding to his Last Dated Status. Please help me to get that Result on Summary sheet through formula . Thanks, CS --

Re: $$Excel-Macros$$ build a database from multiple workbooks

Hi Ashish, I can't thank you enough for this great solution:) I'd hate to be a pain in the neck but I do have a couple of questions more. Would it be possible to specify only one sheet to be merged? My workbooks contain several, but only one is relevant for the database. And, if I run this macro

Re: $$Excel-Macros$$ build a database from multiple workbooks

On Thu, Jan 27, 2011 at 11:37 AM, ashish koul wrote: > Sub consolidatefromdifferentworkbooks() > > Application.DisplayAlerts = False > 'On Error GoTo abc > Dim ask As Workbook > Dim ask2 As Workbook > Dim ASK3 As Workbook > Set ASK3 = ActiveWorkbook > Dim i As Long > Dim j As Long > Dim N, z, r,