$$Excel-Macros$$ Problem regarding sorting and grouping in a prescribed way

Hi Experts, I have a problem regarding sorting and the data.Within my limitation I tried to sort them based on the group column and insert a raw in the beginning where the data changes.But I can't write code well.Kindly help me regarding this issue. Rajesh Kainikkara --

Re: $$Excel-Macros$$ Shorting Problems

Hi Sudhir, i have done this using macro. please find the attached. 1. paste your data in col A from row 1 2. in sheet 2 there is 1 button click on it. you will get the desired result. From: sudhir kumar bluecore...@gmail.com To: Excel Group

Re: $$Excel-Macros$$ Passing Variable to another function

Dear All I require your urgent help for attach file. Please find attach file for calculation of Square meter form Inches to Centimeter. I want to a formula which convert inches in to Centimeter. Example 10' 3'' is equal to 10.25 for Calculation of Square Feet. Thanks and regards Manhar

$$Excel-Macros$$ Need Help

Hi, i have multiple sheets and i want to count the number of instruments in one go, with COUNTA am not able to get. I tried grouping the sheets but could't get the count of all sheets. need your suggestion Thanks, Prathima --

$$Excel-Macros$$ Macro issue passing values from Cell to columns

Hi, i have a macro i´ve done, but it it has a problem, when it passes the data from cells A to various columns it stops no cell 20 in the sheet2 e the another stops at another cell number, i have the file attached here with the code below, can´t seem to discover the error, taking baby steps at

Re: $$Excel-Macros$$ Passing Variable to another function

First of all: Dim Workingday as String does not declare the variable as Global. It merely makes it a module-level variable. It would NOT be available to other modules or to sheet modules. the syntax for declaring a Global variable is: Global WorkingDay as String or: Public WorkingDay as String

Re: $$Excel-Macros$$ Need Help

Are you wanting to count the sheets or count the records/rows on all sheets? Sheets.Count gets you the number of sheets. For Sht = 1 to sheets.count     total = total + application.worksheetfunction.counta(sheets(sht).range(A1:A65000)) next Sht would loop through all sheets and count the

Re: $$Excel-Macros$$ Need Help

Thanks for the response. Here am trying to count the number of non-blanks in multiple sheets On Thu, Feb 10, 2011 at 6:32 PM, Paul Schreiner schreiner_p...@att.netwrote: Are you wanting to count the sheets or count the records/rows on all sheets? Sheets.Count gets you the number of

Re: $$Excel-Macros$$ Need Help

please advice in this concern as i am having around 20-30 workbooks where in need to count the number of Non-blanks in multilple sheets. Thanks, Prathima On Thu, Feb 10, 2011 at 7:23 PM, Prathima R prathima@gmail.com wrote: Thanks for the response. Here am trying to count the number of

$$Excel-Macros$$ Re: Question for you Excel Masters out there...

I'm not sure I understand the question correct. See if this solution will help: You can set the second metric to be displayed as a secondary axis. In other words. The first metric will be on the primary vertical axis on the left and teh second metric will be on the secondary vertical axis on

Re: $$Excel-Macros$$ Need Help

You've asked this question in an Excel VBA Macros user group. Do you not wish a VBA solution? Also, your initial question stated that you had multiple sheets. This follow-up says workbooks. So, the question is: are they multiple sheets in multiple workbooks? one sheet per workbook? also...

Re: $$Excel-Macros$$ Need Help

Try This.. Sub GetNonBlank() For i = 1 To ActiveWorkbook.Sheets.Count t = t + WorksheetFunction.CountA(Sheets(i).UsedRange) Next MsgBox t End Sub On Thu, Feb 10, 2011 at 6:11 AM, Prathima R prathima@gmail.com wrote: please advice in this concern as i am having around 20-30 workbooks where

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

While condition '-- your macro Wend condition is an expression that evaluate to TRUE or FALSE Ex: yr data are in cell B4-down. i = 1 With Activesheet.Range(B4) While Len(.cell(i,1) 0 .cell(i,1).texttocolumns destination:=.cell(i,2), '-- etc -- i = i + 1 Wend End with On 2/10/11, Jorge

$$Excel-Macros$$ excel vba

each time i save many spreadsheeets into a folder; i want to set up a macro do this: open each spreadsheet in the folder and then change the print setting in a way the spreadsheet could be printed in one page and then close each spreadsheet. anyone knows how to wrote a macro like this??? thanks a

$$Excel-Macros$$ Outlook Shared Folder

Hi all Its possible to send excel file to outlook shared folder.. The solution below sends email to individual receipent: http://www.rondebruin.nl/mail/folder2/mail2.htm Would like to send shared folder : mail-folderA-folderB ( subfolders) Thanks in avance --

$$Excel-Macros$$ Outlook Shared folder

Hi all Its possible to send excel file to outlook shared folder.. The solution below sends email to individual receipent: http://www.rondebruin.nl/mail/folder2/mail2.htm Would like to send shared folder : mail-folderA-folderB ( subfolders) Thanks in avance Moo --

Re: $$Excel-Macros$$ Passing Variable to another function

Hi Manhar, Use the following formula, =LEFT(C3,FIND(',C3,1)-1)+VALUE(MID(C3,FIND(',C3,1)+1,FIND(,C3,1)-FIND(',C3,1)-1))/12 Above formula is for the value entered in Inches in cell C3 and always the value is expected in Feet(') and Inches(), the forumula also ignores the multiple spaces beteem the

Re: $$Excel-Macros$$ Passing Variable to another function

Hi Paul, thanks a lot dude. your theory helped me i ll try your code too today. i will let u know. From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Thu, 10 February, 2011 6:26:50 PM Subject: Re: $$Excel-Macros$$ Passing