Re: $$Excel-Macros$$ $$Excel Macros$$ Need to automate some data

2018-06-24 Thread selva raj
Hi Ankur, Te date column should be updated automatically using today( formula. And the Percentage value also need to updated in result sheet without deleting the date history. Regards, Selvaraj M On Sun, Jun 24, 2018 at 2:29 PM, ankur wrote: > > hi selva raj > > Source Sheet format is incom

Re: $$Excel-Macros$$ $$Excel Macros$$ Need to automate some data

2018-06-24 Thread ankur
hi selva raj Source Sheet format is incomplete, missing date column can you add more data to your sample file *With Regards:* *CMA** Ankur Pandey* *B.Com (H), C.M.A * * Mob: :- +919532513513* *P* Please don't print this e-mail unless you really need it. "This e-mail message may cont

$$Excel-Macros$$ $$Excel Macros$$ Need to automate some data

2018-06-23 Thread selva raj
Dear team, I have attached my source excel sheet. My workbook has the two sheet. One is Sourcesheet and another one is Result sheet. Requirements. 1. Need to copy and paste the value from source sheet to Result sheet once i clicked the command button like attached sheet using VBA iteration 2.

$$Excel-Macros$$ Excel macros using a mapping table

2016-04-15 Thread Karthik Sarmah
Hi, I have a file that is a source to feed into other. And they have different headers with same meaning, SO we have created a mapping table between the two data. A macro has to be designed to allow data to compare headers and fill the other file. So far i kinda forumalted this. But it is lea

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-11 Thread venkateswara reddy
THANK YOU so much for your time & efforts. Regards venkat On Thursday, August 7, 2014 6:29:25 PM UTC+5:30, Vabz wrote: > > hi > > check this., as soon as any data is changed you will get notification to > update it.. > > Cheers!! > > On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy > wrote:

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-07 Thread Vaibhav Joshi
hi check this., as soon as any data is changed you will get notification to update it.. Cheers!! On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy < venkateswara.red...@gmail.com> wrote: > thank you so much for this. I'm grateful again for your time and > considerable expertise. > > This is pe

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-04 Thread venkateswara reddy
thank you so much for this. I'm grateful again for your time and considerable expertise. This is perfectly right answer , which i am looking for automation from many days. finally u did it. Please it should match as per the many number of order numbers like VLOOKUP function. please send me fi

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-01 Thread Vaibhav Joshi
PFA, we can modify to suits you once you revert on my query. Cheers!! On Thu, Jul 31, 2014 at 12:05 PM, Vaibhav Joshi wrote: > Thanks for file.. > > Query! > > say Group1 status for order 1 is ABC, so on next day whether there will be > any change in status or not? > > If it changes then do yo

Re: $$Excel-Macros$$ Excel Macros Help

2014-07-31 Thread venkateswara reddy
Hi Vabz, Thanks for the Query, Every day I will replace manually all order numbers & status with new data in all the groups. What I want is for the required order numbers only ,want to see coresponding status from all the gorups status in the master sheet daily. I think aswered you query! P

Re: $$Excel-Macros$$ Excel Macros Help

2014-07-30 Thread Vaibhav Joshi
Thanks for file.. Query! say Group1 status for order 1 is ABC, so on next day whether there will be any change in status or not? If it changes then do you want to replace existing status in Master file or add new record? Cheers!! On Wed, Jul 30, 2014 at 11:14 AM, venkateswara reddy < venkates

Re: $$Excel-Macros$$ Excel Macros Help

2014-07-29 Thread venkateswara reddy
Hi Vabz, Please find the attached file. thanks in advance if you find solution.. I am wasting everyday so much time for doing vlookups everyday. looking for simple automation Thnaks On Tuesday, July 29, 2014 1:45:48 PM UTC+5:30, Vabz wrote: > > Hi share sample file with data format.. > >

Re: $$Excel-Macros$$ Excel Macros Help

2014-07-29 Thread Vaibhav Joshi
Hi share sample file with data format.. Cheers!! On Mon, Jul 28, 2014 at 9:42 AM, venkateswara reddy < venkateswara.red...@gmail.com> wrote: > Hi Dear's, > > Please hlep me with Macros, > > I have problem with multiple sheets need to update corresponding status as > per the order number in mast

$$Excel-Macros$$ Excel Macros Help

2014-07-27 Thread venkateswara reddy
Hi Dear's, Please hlep me with Macros, I have problem with multiple sheets need to update corresponding status as per the order number in master sheet. Worksheet 1 "Master" is a list of orfer numbers that gets updated several times daily (some order numbers are deleted and others are added

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-07-01 Thread Vaibhav Joshi
for your request 1 & 2 change last line to Range("S" & c.Row).Value = Range("H" & c.Row).Value + cIntt Change letter S to desired column no. To run macro on larger row select larger rows, i checked & its working... Cheers!! On Wed, Jul 2, 2014 at 12:26 AM, Kalpesh Shivdas wrote: > Hi > Thank

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-07-01 Thread Kalpesh Shivdas
Hi Thank you for spending time for this calculation Its working well Can you make some changes 1 interest calculations (macro result) should be in column after outstanding /advance (last column) 2 for working of interest please considere current interest column figure also (this may be blank or fig

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-07-01 Thread Vaibhav Joshi
Hi last Q, how do you calculate current int. (Pt. 4). E.g. Bill is raised on 5 Jun & payment recd on 8/Jun, so how you cal int, and you said Total int will be charged in next bill, is it current int only? Cheers!! On Tue, Jul 1, 2014 at 1:51 PM, Kalpesh Shivdas wrote: > Can anyone help on th

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-07-01 Thread Kalpesh Shivdas
Can anyone help on this On Jun 29, 2014 6:56 PM, "Kalpesh Shivdas" wrote: > Hi Vaibhav > > this format is almost fixed means > first Opening Balance then current bill & the receipt against it then > interest (calculate by macros) & then closing outstanding/ advance > > by experience I know during

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-29 Thread Kalpesh Shivdas
Hi Vaibhav this format is almost fixed means first Opening Balance then current bill & the receipt against it then interest (calculate by macros) & then closing outstanding/ advance by experience I know during the period not more than 3 receipt received if macros can calculate more than receipt i

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-29 Thread Vaibhav Joshi
Hi Is this format is fixed or subject to change? If format is fixed then is if by chance you get more than 3 receipts than what? What you want Macro to do? Where you want calculated Interest amount to be shown in sheet? Cheers!! On Sat, Jun 28, 2014 at 12:15 PM, Kalpesh Shivdas wrote: > Hi

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-27 Thread Kalpesh Shivdas
Hi pramod & vaibhav Thank you for your reply I am still facing the interest calculation problem I have mensioned detail explanation in attached file. Can you please make macros for this calculation Regards On Jun 28, 2014 11:27 AM, "Vaibhav Joshi" wrote: > Did this got resolved at your end

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-27 Thread Vaibhav Joshi
Did this got resolved at your end or do you need help on this? On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas wrote: > Hi Group > > > Can anyone help me on this > > Currently I am using (IF) formula for doing this calculation with is > very long & confusing. > > I have four values 1 opening

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-22 Thread Pramod Singh
Can't Understand . What is your Skype ID. for discussed. Pramod my ID:- Pramodb35 On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas wrote: > Hi Group > > > Can anyone help me on this > > Currently I am using (IF) formula for doing this calculation with is > very long & confusing. > > I have

$$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-22 Thread Kalpesh Shivdas
Hi Group Can anyone help me on this Currently I am using (IF) formula for doing this calculation with is very long & confusing. I have four values 1 opening interest 2 opening principal 3 current bill 4 current bill interest =1+2+3+4=5 total outstanding. There are receipts against total ou

Re: $$Excel-Macros$$ $$ Excel-Macros$$ How to create consolidated production log

2014-02-21 Thread Manjunath Narayanappa
Thank you sir, Can you please teach me, when i was trying to extract data from individual production log using consolidated work book. It was pulling data even from header of the individual production log Function BrowseFolder() As String Dim objFso As Object Set objFso = CreateObject("Scri

Re: $$Excel-Macros$$ $$ Excel-Macros$$ How to create consolidated production log

2014-02-20 Thread Manjunath Narayanappa
Thank you very much, i'm not getting words to express ... Its was simply superb Can you please teach me . Why was first consolidated workbook was pulling data even from header for individual production log.(eg: A1, A2, A3 rows) Is there any option that we can extract data from A4 rows. Thanks Ma

$$Excel-Macros$$ $$ Excel-Macros$$ How to create consolidated production log

2014-02-17 Thread Manjunath Narayanappa
Hi Experts, How to extract data from multiple workbooks to one single workbook. Thanks Manjunath -- 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/discussexcel FORUM RULES

Re: $$Excel-Macros$$ excel macros for pasting to selected range

2012-11-01 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: key log To: excel-macros@googlegroups.com Sent: Wed, October 31, 2012 5:13:54 PM Subject: Re: $$Excel-Macros$$ excel macros for pasting to selected range

Re: $$Excel-Macros$$ excel macros for pasting to selected range

2012-10-31 Thread key log
I tried it and it didn't work. I select two whole rows and when I run the macros nothing happens On Wednesday, October 31, 2012 12:26:09 PM UTC-7, Sam Mathai Chacko wrote: > Is this what you wanted?? > > Sub CopyToRows() > > Dim strRange As String > strRange = Selection.EntireRow.A

Re: $$Excel-Macros$$ excel macros for pasting to selected range

2012-10-31 Thread Sam Mathai Chacko
Is this what you wanted?? Sub CopyToRows() Dim strRange As String strRange = Selection.EntireRow.Address(0, 0) Range(strRange).Value = Range("2:2").Value End Sub Regards, Sam Mathai Chacko On Thu, Nov 1, 2012 at 12:50 AM, key log wrote: > Hi all, > > This is a very easy macro bu

$$Excel-Macros$$ excel macros for pasting to selected range

2012-10-31 Thread key log
Hi all, This is a very easy macro but since I just started learning about VBA I'm having a hard time making something that works. What I want to do is have a macros button that will paste a specific row to a selected field. So, I want the user to select whatever rows they want, say rows 99-101

Re: $$Excel-Macros$$ $$Excel-Macros$$ Need to find out date of latest data

2012-10-11 Thread Vijayendra Rao
Dear Excel Learner, Thanks for the solutions and sorry for late response. Can you please let me know the logic for 10^10 in below formula =IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"") Regards, Vijayendra 2012/10/8 Ms-Exl-Learner > Hi Vijayendra > > Copy and paste the below formula

RE: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

2012-05-06 Thread Rajan_Verma
: 05 May 2012 16:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days Hi, Find the attachment. Regards, MARIES. On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote: Dear Deba Ranjan

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

2012-05-05 Thread Maries
Hi, Find the attachment. Regards, MARIES. On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote: > Dear Deba Ranjan, > > Thanks for efforts, I knew this formula and it was not solved my problem. > > I need the below details if any one worked 4th October 2011 to 4th May 2012 > - Total days

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

2012-05-04 Thread Vijayendra Rao
Dear Deba Ranjan, Thanks for efforts, I knew this formula and it was not solved my problem. I need the below details if any one worked 4th October 2011 to 4th May 2012 - Total days worked in which beginning of the month, i.e: 4th oct to 31 st oct is 28 days, It should be zero if he worked full mo

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

2012-05-04 Thread Deba Ranjan
*Hi *Vijay, You can you try formula, it will help you out.:- For Date diffrence:- =DATEDIF(A2,(B2),"md") For Month diffrence :- =DATEDIF(A2,(B2),"ym") For Year diffrence :- =DATEDIF(A2,(B2),"y") Thanks & Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao w

$$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

2012-05-04 Thread Vijayendra Rao
Dear All, I need date formula for finding how many days and months between two different dates. Request you to resolve my query. I have attached is the same file. Regards, Vijayendra 94491 67631 -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread NOORAIN ANSARI
Dear Sunil, Please use.. For 2007+ =AVERAGEIF(F1:F10,">0") For 2003 =SUMPRODUCT((F1:F10>0)*(F1:F10))/COUNTIF(F1:F10,"<>0") On Thu, Feb 9, 2012 at 4:49 PM, sunil bn wrote: > Hi Expert, > > > > Please find the attached file. > > > > 1. I need “average formula” which includes 0 value. > > --

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
Thank u maries Regards Sunil B.N ®Sent From Android Mobile© On 9 Feb 2012 17:02, "Maries" wrote: > Hi, > > Find the below formulas, > > =SUM(F1:F10)/COUNTIF(F1:F10,">0") > > =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) > > =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") > > =SUM(F1:F10)/(SUMPROD

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Maries
Also Try, *=AVERAGEIF(F1:F10,">0") * On Thu, Feb 9, 2012 at 3:33 PM, Lakshman Prasad wrote: > Sorry, > > =AVERAGE(F2:F11) > > *From:* sunil bn > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, 9 February 2012 4:49 PM > *Subject:* $$Excel-Macr

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Lakshman Prasad
Sorry,   =AVERAGE(F2:F11) From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need “average formula” which

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Maries
Hi, Find the below formulas, =SUM(F1:F10)/COUNTIF(F1:F10,">0") =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") =SUM(F1:F10)/(SUMPRODUCT((F1:F10<>0)*1)) Regards, MARIES. On Thu, Feb 9, 2012 at 3:19 PM, sunil bn wrote: > need “average formula” whi

Re: $$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread Lakshman Prasad
Hello Mr. Sunil Use =AVERAGE(F2:F11,{1})     From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need

$$Excel-Macros$$ excel macros - Sunil B.N

2012-02-09 Thread sunil bn
Hi Expert, Please find the attached file. 1. I need “average formula” which includes 0 value. -- *Regards* **Sunil B.N *** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

Re: $$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread Kabir....:-)
Dear Lucky Ji., Thanks for your valuable help. I am having a requirement of protecting the entire sheet. The query is - How should i lock a particular book with a pass word. When ever a user tries to open that work book it has to be asked password. Then only the sheet should open and the contents

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh
Hi Team, Attached below is the Marco code for Protecting cells in excel sheet. Steps to Protect a cell Step 1 - Open that particular file which you want to lock and hide any formulas in sheet. Step 2 - Open file "PROTECT" and press CTRL + j Steps to Unprotect a cell Step 1 - Open that particul

$$Excel-Macros$$ Excel-Macros for protecting cell

2011-08-02 Thread lucky singh
Hi Team, Attached below is the Marco code for Protecting cells in excel sheet. Steps to Protect a cell Step 1 - Open that particular file which you want to lock and hide any formulas in sheet. Step 2 - Open file "PROTECT" and press CTRL + j Steps to Unprotect a cell Step 1 - Open that particul

$$Excel-Macros$$ $$EXCEL-MACROS$$HOW TO AUTOFILL FOR A GIVEN SUM IN MAGIC SQUARE

2011-07-02 Thread karunanithi ramaswamy
HI,   I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.   THANKS IN ADVANCE -R.KARUNANITHI,2/7/2011. -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-10 Thread ashish koul
http://akoul.blogspot.com/search/label/Sending%20a%20Range%20as%20attachment%20in%20mail%20though%20Excel%20VBA try this if it helps On Mon, May 9, 2011 at 9:20 AM, sreekanth m wrote: > Dear All, > > I am attaching an Excel with some hypothetical data. > > Please help me to : > >- Take

$$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-09 Thread sreekanth m
Dear All, I am attaching an Excel with some hypothetical data. Please help me to : - Take out the data by filtering the Managers name and paste it in a New Work Book. - Sent it to the respective managers E-Mail ID. - All the above actions should get done in a button Click. Awaiting

$$Excel-Macros$$ Excel Macros for updating current records.

2011-02-23 Thread Ken Hansen
Hi all, I have a Sales Tracking workbook. I have 2 issues that I can't seem to resolve. 1. When the UserForm to add sales is closed I want all sheets to refresh. I am using: ActiveWorkbook.RefreshAll It refreshes everything EXCEPT the Sales Analysis sheet. I have to manually refresh the Pivot T

RE: $$Excel-Macros$$ $$Excel Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-19 Thread Daniel
ons(1).Interior.ColorIndex = 1 .FormatConditions(1).StopIfTrue = True End With End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nuria Gimenez Envoyé : mercredi 16 février 2011 10:46 À : excel-macros@googlegroups.com Objet : $$Excel-Mac

Re: $$Excel-Macros$$ excel-macros : Get Agents Name under Team Leader

2010-12-26 Thread Sundarvelan N
Hi Rohan, Thanks for your reply, but i dont want to edit my original excel file. I need to get the agents name under corresponding TL names like wise TL names under manager name. Thanks, Sundarvelan 9600160150 On Fri, Dec 24, 2010 at 3:43 PM, Rohan Young wrote: > Hi, > > Please find the solved

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Paul Schreiner
k... I don't think you can do that. The best we could do is create Event macros in the secondary workbooks that run the macro in the "template" Paul - Original Message > From: Ted > To: MS EXCEL AND VBA MACROS > Sent: Mon, November 1, 2010 1:42:25 PM > Subjec

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
> To: MS EXCEL AND VBA MACROS > > Sent: Mon, November 1, 2010 12:09:33 PM > > Subject: Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module > > > Thank you.  I added EnableEvents = true  and used the function I vound > > "App_SheetChange" to acc

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Paul Schreiner
ailed description for how you WANT it to work. Paul - Original Message > From: Ted > To: MS EXCEL AND VBA MACROS > Sent: Mon, November 1, 2010 12:09:33 PM > Subject: Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module > > Thank you.  I added EnableEven

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
> then, within your event, check this status before running. > If (not ChangeFlag) Then Exit Sub > > hope this helps, > > Paul > > > > > > > > - Original Message > > From: Ted > > To: MS EXCEL AND VBA MACROS > > Sent: Mon, Novemb

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Paul Schreiner
/false then, within your event, check this status before running. If (not ChangeFlag) Then Exit Sub hope this helps, Paul - Original Message > From: Ted > To: MS EXCEL AND VBA MACROS > Sent: Mon, November 1, 2010 8:20:52 AM > Subject: $$Excel-Macros$$ $$Excel Macros$$ Work

$$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
I use one book for portability of macros and I'd like to be able to turn on and off a worksheet_change macro from the book, not by adding the script to each individual worksheet. I can't find any information on this anywhere, so I thought this would be a good place to ask. All I can think of is w

$$Excel-Macros$$ Excel Macros

2010-09-23 Thread aswin sudheer
Hi, I wanted to learn Excel Macros.Kindly help me. Thanks, Aswin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

RE: $$Excel-Macros$$ Excel Macros ?

2010-09-01 Thread Dave Bonallack
seful when you need to do the same thing hundreds, or hundreds of thousands, of times. Hope this helps. Regards - Dave. Date: Wed, 1 Sep 2010 09:12:56 +0530 Subject: $$Excel-Macros$$ Excel Macros ? From: harilal@gmail.com To: excel-macros@googlegroups.com HLC Dear Excel Friends, I am a

$$Excel-Macros$$ Excel Macros ?

2010-08-31 Thread Hari Lal C
HLC Dear Excel Friends, I am a beginner in Excel. I would like to know what is Excel Macro ! Can we develop a programme in Excel Macro ? How to develop a small programme in Excel Macro? What are the advantages ? Is there any body in our community to help me with a simple example on Excel *Ma

$$Excel-Macros$$ $excel-macros$ help

2010-07-21 Thread preeti vora
Hi team i have one excel file there is 10 to 15 sheet different but i want to marge in one sheet is that possible to do??? -- Regards, Preeti Vora. -- -- Some important links for excel users: 1. Follow us on TWIT

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-11 Thread Soni.Rajender
Thanks Buddy On Jul 11, 9:03 am, Nikhil Shah wrote: > Dear Friend > > Yes.Yes.. > > Frist visit the web site..here they have number option..Excel 2003 or excel > 2007 > > Regards > Nikhil > > On Sun, Jul 11, 2010 at 7:13 AM, krishnan moorthy > wrote: > > > > > Thank you Nikhil... have a quick que

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-11 Thread prabhakar thakur
Hi Nikhil, Have Macro Traning book in PDF or Soft copy. If have Please send me. Thanks, Prabhakar Thakur New Delhi +919953736776 On Sun, Jul 11, 2010 at 9:33 AM, Nikhil Shah wrote: > Dear Friend > > Yes.Yes.. > > Frist visit the web site..here they have number option..Excel

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread Nikhil Shah
Dear Friend Yes.Yes.. Frist visit the web site..here they have number option..Excel 2003 or excel 2007 Regards Nikhil On Sun, Jul 11, 2010 at 7:13 AM, krishnan moorthy wrote: > Thank you Nikhil... have a quick question.. will this work in office 2007 > as well?? > > > On Sat, Jul 10, 2010 at 1

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread krishnan moorthy
Thank you Nikhil... have a quick question.. will this work in office 2007 as well?? On Sat, Jul 10, 2010 at 10:32 PM, Nikhil Shah wrote: > Dear Friends > > Here i am sending One URL For Excel - Macro Training in excel 2003. > > http://www.familycomputerclub.com/excel/excel2003_macros.html ( With

$$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread Nikhil Shah
Dear Friends Here i am sending One URL For Excel - Macro Training in excel 2003. http://www.familycomputerclub.com/excel/excel2003_macros.html ( With Video ) In English & Hindi also I think , it gives some knowledge about how to write macro.. Regards Nikhil Shah -- --

Re: $$Excel-Macros$$ $$Excel - Macros$$ - Need to Break the password of my VBA Code

2010-04-26 Thread rf1234 rf1234
Hello Dear, Please send mail with proper subject line and message.Here We are unable to understand your problem. we can help better when we know your problem. On Mon, Apr 26, 2010 at 10:44 AM, ram kumar.m wrote: > > > -- > Thanks and Regard > ramkumar.m > HAVE A NICE DAY FRNDS:) > > -- >

$$Excel-Macros$$ $$Excel - Macros$$ - Need to Break the password of my VBA Code

2010-04-26 Thread ram kumar.m
-- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) -- -- 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 @ h

Re: $$Excel-Macros$$ Excel-Macros : Help

2010-04-16 Thread Sundarvelan N
Hi Friends, Thanks, Thanks, Thanks, Thanks, Thanks, Thankyou very much one more request How to remove the page breaks both in portrait and landscape On Fri, Apr 16, 2010 at 12:59 PM, Kumar wrote: > Hi Sundarvelan, > > See if the below code helpful for your task: > > '

Re: $$Excel-Macros$$ Excel-Macros : Help

2010-04-16 Thread Kumar
Hi Sundarvelan, See if the below code helpful for your task: '=== ActiveSheet.PageSetup.RightHeader = "" ActiveSheet.PageSetup.CenterHeader = "" If WeekdayName(Weekday(Date)) = "Monday" Then ActiveSheet.PageSetup.LeftHeader = FormatDateTime(

RE: $$Excel-Macros$$ Excel-Macros : Help

2010-04-16 Thread Dave Bonallack
Hi, If I understand you correctly, the following line of code does what you ask, to the active cell. If Weekday(Date) = 2 Then ActiveCell = Date - 3 Else: ActiveCell = Date - 1 Regards - Dave. Date: Fri, 16 Apr 2010 10:36:13 +0530 Subject: $$Excel-Macros$$ Excel-Macros : Help

$$Excel-Macros$$ Excel-Macros : Help

2010-04-15 Thread Sundarvelan N
Hi Friends, Please complete this coding. Condition is if the current day is Monday then i need to have Privious Friday Date in the header else just previous day date. Please help me to complete my project Range("A1:IV65536").Select With ActiveSheet.PageSetup End With ActiveShe

Re: $$Excel-Macros$$ Excel Macros Free PDF

2010-02-11 Thread hari kumar
http://groups.google.com/group/excel-macros/files On 2/11/10, Venkatesan c wrote: > Can I Have Excel Macros PDF Complete Guide > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tri

$$Excel-Macros$$ Excel Macros Free PDF

2010-02-11 Thread Venkatesan c
Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Excel Macros Free PDF

2010-02-10 Thread Venkatesan c
Dear All Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video a

$$Excel-Macros$$ excel macros -non numeric value

2009-09-02 Thread ymusafi
Hi All I want to create a macro that is doing somthing if the cell value has non numeric value meaning: if cell.value=???then I just need to know what to put instead of the question marks Thanks! --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ $$ Excel-Macros $$ Consolidation of different sheet by macro

2009-07-02 Thread SANJAY SONI
Dear All,   Please help me to solve my problem. As I want to have the macro for making the consolidation of different sheets through a recorded macro with the variable ranges in sheets.   Best Regards, Sanjay Love Cricket? Check out live scores, photos, video highlights and more.

$$Excel-Macros$$ $$Excel-Macros$$

2009-06-17 Thread lingesh p
Hi all, Can anyone send me a ppt or an overview abt macros i want to learn the basics of macros. is there any one who can help me with this Thanks in advance Regards, Lingesh --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ excel macros

2009-06-01 Thread mayank khare
Hai, I want to learn indepth excel macros. Plz tell the resource to learn this. I do not know any language ie Visual Basic ,which i know is required to write a macro. Plz guide me. -- Warm Regards Mayank Khare --~--~-~--~~~---~--~~

$$Excel-Macros$$ Excel macros

2009-06-01 Thread mayank khare
Hai, I want to learn indepth excel macros. Plz tell the resource to learn this. I do not know any language ie Visual Basic ,which i know is required to write a macro. Plz guide me. -- Warm Regards Mayank Khare --~--~-~--~~~---~--~~

$$Excel-Macros$$ excel macros

2009-01-05 Thread Joe
> I wonder if you can help out an absolute novice when it comes to excel > macros. > My girlfriend has sent me some homework as she has to work today and I am > at home trying to read up on Excel Macros 2003... > She needs to be able to look through each of the day cells in her excel > calen

$$Excel-Macros$$ Excel Macros totaling like values

2008-11-05 Thread enajenkins
How do I create a macro in Excel that will count the number of like values in a cell? For Example: "how many people live in each city" in an excel spreadsheet of names and addresses --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.ex

$$Excel-Macros$$ Excel Macros Book?

2008-09-15 Thread SilvergunSuperman
Would anyone be able to recommend a good book to purchase wrt to Macros and VBA? Thanks in advance!! : ) --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@g