$$Excel-Macros$$ Selective standard deviation - EXCEL - help!

Hi I have my excel dataset arranged as follows : * Col KCol T * APPLE . ORANGE . APPLE ORANGE In Column K, I have fruit data which is either APPLE or ORANGE. In Column T, I have corresponding numerical

Re: $$Excel-Macros$$ Pivot Help

On Fri, 1/26/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Pivot Help To: excel-macros@googlegroups.com Date: Friday, January 26, 2018, 5:43 PM

Re: $$Excel-Macros$$ Re: concatenate in one cell

On Sun, 12/31/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Sunday, December 31, 2017, 12:44 PM

Re: $$Excel-Macros$$ Re: concatenate in one cell

On Mon, 12/25/17, Aamir Shahzad wrote: Subject: Re: $$Excel-Macros$$ Re: concatenate in one cell To: excel-macros@googlegroups.com Date: Monday, December 25, 2017, 11:05 AM this is manual formula & need select cells

Re: $$Excel-Macros$$ RE: Excel to Link to Word

On Thu, 11/9/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ RE: Excel to Link to Word To: excel-macros@googlegroups.com Date: Thursday, November 9, 2017, 8:12 PM

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

On Thu, 6/1/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: "excel-macros@googlegroups.com" Date: Thursday, June 1, 2017, 4:47 PM

Re: $$Excel-Macros$$ Links

On Thu, 5/25/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Links To: "excel-macros@googlegroups.com" Date: Thursday, May 25, 2017, 8:17 PM The workbook that you add the VBA macro

Re: $$Excel-Macros$$ automation for advanced filter

On Fri, 5/5/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ automation for advanced filter To: "MS EXCEL AND VBA MACROS" Date: Friday, May 5, 2017, 6:01 PM Hi gowri Thank you very much

Re: $$Excel-Macros$$ advanced formula

On Mon, 4/17/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ advanced formula To: excel-macros@googlegroups.com Date: Monday, April 17, 2017, 8:44 PM

Re: $$Excel-Macros$$ advanced formula

On Mon, 4/17/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ advanced formula To: "MS EXCEL AND VBA MACROS" Date: Monday, April 17, 2017, 6:08 AM Thank you very much for your help, can you

Re: $$Excel-Macros$$ Re: Macros for screenshot

---       On Sun, 4/9/17, 'Martin   George'     via     MS       EXCEL AND VBA MACROS <excel-macros@googlegroups.com>       wrote:             Subject: Re:   $$Excel-Macros$$     Re:       Macros for screenshot       To: excel-macros@googlegroups.com  

Re: $$Excel-Macros$$ Re: Macros for screenshot

On Sun, 4/9/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Sunday, April 9, 2017, 1:41 AM

Re: $$Excel-Macros$$ Formula to convert Text into Number

    Formula       to convert Text into Number       To: excel-macros@googlegroups.com       Date: Thursday, April 6,   2017,     6:34       PM                               ----       On Thu, 4/6/17, 'Martin   George'     via      

Re: $$Excel-Macros$$ Formula to convert Text into Number

On Thu, 4/6/17, jmothilal wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 1:36 PM first letter is not zero  is "O" , so Remove the

Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA

On Wed, 3/29/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, March

Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook

On Tue, 3/28/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook To: excel-macros@googlegroups.com Date: Tuesday, March 28, 2017,

$$Excel-Macros$$ course in Analytics

I am MBA Business Process Analyst , 5 + yrs in Telecom / IT industry . My technical knowledge solemnly lies only in SQL, Excel , IBM DB2 and some analytical tools . I wish to pursue a good course that can help me to fetch a good job in Analytics . Can any one help me with the course I

$$Excel-Macros$$ Macroa

Hi All, I have a task at hand. Wherein i have files stored online on my office intranet. And i need those files downloaded and merged as and when required. For example, I have 10 folders and in each folders there are 2 files say A and B, now whenever i need the data i have to download the files

Re: $$Excel-Macros$$ Macroa

you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Jones George jonnie...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, September 5, 2014 10:15 AM *Subject:* $$Excel-Macros$$ Macroa Hi All, I have

$$Excel-Macros$$ Mass mailer help!!!

the list is huge can macros help me? If yes can someone guide me. Appreciate your help in advance. Regards Jones George -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com

$$Excel-Macros$$ Mass mailer help!!!

Thanks Anil for replying. However I cannot share the worksheet as its Confidential information. Is it possible to prepare a sample list of email addresses and then prepare a macro. I know im asking too much. But need help. Regards Jones George On 2 Sep 2014 15:04, Jones George jonnie

$$Excel-Macros$$

-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

. -- To post to this group, send email to excel-macros@googlegroups.com -- Best Regards George -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ need help:save excel worksheet data into SQLserver using VBA code

. -- To post to this group, send email to excel-macros@googlegroups.com -- Best Regards George -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

$$Excel-Macros$$ Conditional Formatting using VBA

Excel 2007- I have a spreadsheet that is updated frequently with new rows of data. I have a conditional format that is set for all rows and each time I add a new row I have to manually adjust the last row to encompass the newly added one. In the attached spreadsheet, new SKU data is added at

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

-- George W -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3

RE: $$Excel-Macros$$ Create a drop down calendar in consecuative cells in a Excel column

Thanks very much, will give it a try George -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Friday, July 8, 2011 12:04 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Create a drop down

$$Excel-Macros$$ Any help on Outlook macro will be appreciated

and DEF.txt I want to compare values in ABC with values in File2.xlsx also see some values of ABC are in File1.txt Please let me know if there is anyother alias that can help me in this. Also any links will help on this. Thanks, Annie George

Re: $$Excel-Macros$$ Arithmetic with blank cells

-- George W -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3

Re: $$Excel-Macros$$ Arithmetic with blank cells

OK, here is an example: The whole idea is to prevent a data entry spreadsheet having a bunch of zeroes in all the totalizing columns. Cells K1,L1 and K2,L2 have been Clear Contents, Cell M3 the totalizer cell is blank. Put a 1 in K1 and the #Value error appears in M3 Cell M1:

$$Excel-Macros$$ Re: Help with Date

Hi HARI, Please look at that: http://marchello.ccx-grads.org/files/PR.xls All you need is key of your fields (dot-separated) and VLOOKUP standart function. You can press F9 if your seetings do not allow automatic calculation. Enjoy! On 22 Лип, 14:20, HARI NAIR hari.shrin...@gmail.com wrote:

$$Excel-Macros$$ Re: $excel-macros$ help

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets(main sheet).Select Cells.Select

$$Excel-Macros$$ Re: $excel-macros$ help - merge sheets into one sheet

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets(main sheet).Select Cells.Select

$$Excel-Macros$$ Re: how to copy 1 file column to another file column automatically

Hi Ankit, You can run this code and enjoy. Sub Macro1() Columns(A:A).Select Selection.Copy Windows(as.xls).Activate Columns(B:B).Select ActiveSheet.Paste Windows(a.xls).Activate Columns(C:C).Select Application.CutCopyMode = False Selection.Copy

$$Excel-Macros$$ Re: Required Help

Hi somasekhar, you can use my macros code, it works for me if columns in text file are separate by tab. Change path D:\Work\090710_1\sample.txt to your full path. Please report whether it works for you. Sub Macro1() Workbooks.OpenText Filename:=D:\Work\090710_1\sample.txt, Origin:=866, _

$$Excel-Macros$$ Re: Worksheet/workbook events not being triggered

Hi fromeo, So your spreadsheet pulls in data from SQL Server correctly, then populates a sheet Data correctly, but doesn't refresh sheet Pivot ? Please tell me are you able to refresh Pivot sheet manually by pressing Shift+F9 after your sheet Data is ready? If yes, all you need is to add this

$$Excel-Macros$$ Re: Want to convert on Text in each cell to rows

Hi Prashant, I would like to do it in 3 steps. 1. Run this code: Sub Macro1() ActiveWorkbook.SaveAs Filename:=D:\tmp\Book1.txt, FileFormat:=xlText, _ CreateBackup:=False End Sub (sure, you can change path D:\tmp\Book1.txt to your own) 2. Open D:\tmp\Book1.txt in text editor,

$$Excel-Macros$$ Re: Fwd:

Hi praveen, Let's say you have United States of America in A1 cell and (space) in A2 cell. Now you can run this code and get result in A3 cell. Enjoy! Sub test1() Dim currentCell, currentLength, currentSymbol, i, currentSpace, j j = 1 Range(A2).Select currentSpace =

$$Excel-Macros$$ Re: parse Excel file

George, Can't quite understand your request. column F down untill we reach two empty cells in columns F and J But your sample data doesn't have 2 empty cells in both F and J. Perhaps you could attach a sample workbook with a bit more data - say 20 rows. Regards - Dave. Date: Fri, 29 May 2009

$$Excel-Macros$$ parse Excel file

Dear group members, I have got .xls file where two columns (F and J) must be parsed. Columns look like this: F J aaa bbb (empty) ccc (empty) ddd (empty) (empty) fff ggg (empty) rrr (empty) vvv (empty) (empty) So, I need to go through these columns and copy data to other sheet: column J - as