Re: $$Excel-Macros$$ Conditional Formatting using VBA

Dear George, Consider this one. On Wed, Dec 7, 2011 at 11:06 AM, George Barrowcliff wrote: > > 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

Re: $$Excel-Macros$$ Conditional Formatting using VBA

Dear George, Please see attached sheet, I hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Dec 7, 2011 at 11:06 AM, Georg

$$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 the

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Dear Susan, Please try it and see attached sheet. Sub Sheet_Creater() Application.ScreenUpdating = False Dim i, j, k As Integer j = Sheet18.Cells(Rows.Count, "A").End(xlUp).Row For i = 2 To j Sheets.Add after:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Sheet18.Cells(i, "

Re: $$Excel-Macros$$ Re: Subtotals

Very helpful thanks a lot.. On Mon, Dec 5, 2011 at 9:47 PM, Sam Mathai Chacko wrote: > Thanks a lot Noorain > > Cheers > Sam > > > On Mon, Dec 5, 2011 at 9:36 PM, NOORAIN ANSARI > wrote: > >> Dear SAM, >> >> Please find attached sheet... >> >> -- >> Thanks & regards, >> Noorain Ansar

Re: $$Excel-Macros$$ Need Help

Guys, Cant figure out what these files do. Please explain with example, how exactly do you use these two excel files. Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

Re: $$Excel-Macros$$ Data validation not working properly

Ensure that you are using the correct formula and remove unnecessary blanks from the sheet. Also, check the Ignore blanks in data vlaidation box. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

RE: $$Excel-Macros$$ How to close many files at a time

Dear Rajan, Thanks a lot. This works really well with all excel files. However is it possible to cover even emails(.msg files)? Regards, Amit Desai -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rajan verma Sent: 06 December 20

Re: $$Excel-Macros$$ How to close many files at a time

On 12/3/11, Amit Desai (MERU) wrote: > Hi All, > > In case if i want to close many excel files (& not all) or emails all at a > time (in stead of selecting one at a time - want to select many..), how can > we do that? > > Regards, > Amit Desai > > > Disclaimer: Thi

Re: $$Excel-Macros$$ update link automatically in excel sheet

You can change the File in Edit links Dialog Box to Update Links.. Rajan. On 12/5/11, Bé Trần Văn wrote: > 2011/12/5 dguillett1 > >> Haven't followed this but have you tried >> edit/replace >> >> >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> -Original Message- From:

Re: $$Excel-Macros$$ Auto schedule for execution of macro

yes we need to open that file and Run that macro to create schedule for any other macro.. Write that code on workbook_open events . so that when we open that workbook.. its automatically triggered and create Schedule . Rajan On 12/5/11, Gangaram. wrote: > I have tried this using the following

$$Excel-Macros$$ Need help on Statistical Modeling

Hi team, can anyone help me out in How to check the assumption of linear regression for building business models like data is Normally distributed or not? Data has linear relation or not? about checking multicollinearity? -- Thanks & Regards, Vikash Chandra Bangalore 9902622922 -- FORUM RULES (

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

Hi Please try this : Sub MakeXML() Dim strPath As String Dim rngUsed As Range Dim rngRow As Range Dim wbknew As Workbook With Application.FileDialog(msoFileDialogFolderPicker) .Title = "please Choose Folder to Save XML File" .Show strPat

Re: $$Excel-Macros$$ Working in multiple workbooks

we need to open linked file in some cases like if we used sumif ,Countif.. Rajan. On 12/5/11, Veer wrote: > Dear B Sharma, > > if you dont want to open both files, u can merge all the worksheets of > both workbooks in one workbook. > > or u can attach your files as example to make practical solu

Re: $$Excel-Macros$$ Working in multiple workbooks

Hi Bajrang, what error you getting if you dont open second file... Rajan. On 12/3/11, B Sharma wrote: > Dear Excel Experts... > > I have created two separate work book. > 1st one is the database and 2nd one is the report / summary file > > now my query is that while checking the reports I dont

Re: $$Excel-Macros$$ Re: hi experts solve this problem

When communicating with me, please REPLY to message with previous msg The macro is using a vlookup to lookup the value above in the 1st column of the table and returning the 3rd column. You do not have a table value for 14000 in the first column. I added here ??? You did not comment on my other

$$Excel-Macros$$ Ledger opening balance and balance in MS Access

hi friends, i want to make ledger accounts in ms access. i am able to make ledger for full period with opening balance but i m problem making ledger for a specific period. for example i have full debit credit data from 01 jan 2010 to 31 dec 2010 with opening balance. i can creat report for full pe

$$Excel-Macros$$ Re: hi experts solve this problem

sorry Don Guillett its working good but chart was not shown ur done good work once i will check this Code and inform you soon thanks On Dec 6, 1:30 pm, Renukachari Kasee wrote: > hi > Don Guillett > thanks for your response > > once check this file > > here max is 14000 then this macro was not w