Re: $$Excel-Macros$$ Dynamic range

see if this helps Sub growth() Dim i As Long i = Range("s21").End(xlDown).Row Columns("S:S").Select Selection.Insert Shift:=xlToRight Range("S21").Select ActiveCell.FormulaR1C1 = "Growth" Range("S23").Select ActiveCell.FormulaR1C1 = "=(RC[-2]-RC[-1])/RC[-2]" Range("S23

Re: $$Excel-Macros$$ Saving excel workbook to 2 folders

Private Sub Workbook_BeforeClose(Cancel As Boolean) ' with password ThisWorkbook.SaveAs Filename:="d:\test3.xls ", FileFormat:= _ xlNormal, Password:="abc", WriteResPassword:="abc1", ReadOnlyRecommended:=False _ , CreateBackup:=False 'without password ThisWorkbook.SaveAs Filename:="d:\test.xls "

Re: $$Excel-Macros$$ Segmentation?

can you please attach the sample workbook On Tue, Feb 15, 2011 at 11:58 PM, MikeMikeMike wrote: > Say for example I have one tab that has a list of contact information > - say anywhere from 1000 to over 100,000 contact items that include > name (one field for first and last name), phone, address,

Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

Hi Mike, Please use: =VLOOKUP(A2,Sheet1!B:B,1,0) instead. Regards, Andy On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike wrote: > I am struggling with this and wondering if you could help.. > > Worksheet 1 Column A & B > Keyword Category > telecom Telecom > tele com#N/A > > Worksheet 2 Colu

Re: $$Excel-Macros$$ Saving excel workbook to 2 folders

The command you're looking for is SaveCopyAs I would create a BeforeSave event, there, save the file locally, then define the "backup" location, unprotect the file, then save a copy at the backup location. Let me know if you need specifics. Paul From: balder

Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

Hi Paul, Thanks for your help. I think I now understand how it works. After I sent you the file I tried what is suggested in below link one more time and it works great. It is basically the same thing that you told me to do with a little bit of change. Here is the link for anybody interested: htt

$$Excel-Macros$$ Saving excel workbook to 2 folders

I ahve a workbook for each of my staff for coaching purposes, I need to save this into a Common drive so they can password protect it to enable only me and them to access it. I also need to save it without a password into a management drive to allow my manager to access it without the need for a p

RE: "$$Excel-Macros$$ RASHI QUERRY"

=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))-K8,SUM(VLOOKUP(D

$$Excel-Macros$$ Diff excel Sheet based on Name & test

Hi Gurus, I Just want to create Diff excel sheet based onn Emp name & sheet name should be "emp name & date".there are diff test are available for each process I also want to update that process test scores in respective sheet (kindly see the sheets for more info),i am having very large excel data

Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations

Sanjoy, Thanks for your reply. I suspect you are saying that if I press F2 in something like Visual Studio I will get a page come up that will show the values for the constants/enumerations. (I'm not at a place that I can check VS).My question may be a bit more fundamental. When I try to

$$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

I am struggling with this and wondering if you could help.. Worksheet 1 Column A & B Keyword Category telecom Telecom tele com#N/A Worksheet 2 Column A & B termcategory telecom Telecom telcom Telecom tele comTelecom What I want to do is pull the category name from worksheet

$$Excel-Macros$$ Dynamic range

Sub growth() ' ' growth Macro ' Columns("S:S").Select Selection.Insert Shift:=xlToRight Range("S21").Select ActiveCell.FormulaR1C1 = "Growth" Range("S23").Select ActiveCell.FormulaR1C1 = "=(RC[-2]-RC[-1])/RC[-2]" Range("S23").Select Selection.NumberFormat = "0.00%"

$$Excel-Macros$$ RE: Excel graphs and formula for adding time spent

Dear Vinod, The sum formula is giving correct solution if you mean by 0:20 mins. Kindly explain where are you facing the issue or why do you think the sum for 4:30 is not correct. -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here **)*

$$Excel-Macros$$ Re: error checking VBA Excel 2003

I have solved the cancel button exit from the routine problem part 1 as follows:- 'Check to see if cancel button is pressed go back to Menu If Newuser = false Then Sheets("Menu").Select Exit Sub End If Still cannot get anything on the other two problems Brian Scotland O

$$Excel-Macros$$ Segmentation?

Say for example I have one tab that has a list of contact information - say anywhere from 1000 to over 100,000 contact items that include name (one field for first and last name), phone, address, etc. On the other tab I have a list of Categories. 1 column for Category Name and the other for a text

Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

The choice of which approch to use is really a question of Readability and Functionality. You can use: Sheet1.Select Sheet2.Select Sheet3.Select as long as you know you're not going to be deleting and adding sheets. Once you delete a sheet, even if you make a copy and delete the original, this

Re: $$Excel-Macros$$ Fwd: Need to Check

what exactly you are looking for .. do you want us to transfer data into the site from excel sheet On Tue, Feb 15, 2011 at 6:46 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > > hi , > > Please help in this concern can any one help in this concern i require this > computation

Re: $$Excel-Macros$$ Load image from the url

I am using a web url. Is there anyway I can covert/save web url in picture format and then call it in the below function? Regards, San On Tue, Feb 15, 2011 at 5:46 AM, ashish koul wrote: > Sub test() > > UserForm1.Image1.Picture = LoadPicture("D:\koul\krishna.jpg") > UserForm1.Show > > > End S

Re: $$Excel-Macros$$ Sheets(2) refers to 2nd sheet in excell file not sheet with index2

Thanks for your thorough explanation Paul. I now understand that sheets() points to the position of the sheet in the file. I still do not understand how to use the sheet.name though. This is what I have in objext explorer sheet1 (Process) 'is the first sheet sheet2 (Hours) ' is 3rd sheet sheet3 (

Fwd: $$Excel-Macros$$ Solution required

Dear Excel Gurus, I know mailmerge but how to do the same thing in excel, I also know that It is very easily done using Ms-access. how to do mailmerge in excel. because we want the desired data in excel only Regards Jitender -- Forwarded message -- From: Sanjoy Nath Date: 14 Fe

Re: $$Excel-Macros$$ data in horizontal row

hi please use this simple procedure Excel Text to Column Command The Text to Column command allows you to break text in one column into several columns. For example, if you have LastName, FirstName in a column, you can break the text into two columns—one containing LastName and the other containi

Re: $$Excel-Macros$$ RASHI QUERRY

VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)>= 1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1) On Tue

Re: $$Excel-Macros$$ Query

will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad wrote: > Thanks *Ashish *for reply but can you please provide formula without > pivot. Condition you have understand that if sum of any classification is > grater then others,it shows that value. > > > > On

Re: $$Excel-Macros$$ Query

Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul wrote: > > > On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad > wr

$$Excel-Macros$$ Fwd: Need to Check

hi , Please help in this concern can any one help in this concern i require this computation using excel macro below is the link which is coded in HTML. Which is working fine but i cant use this link in my organisation so kindly can anyone help to build the excel macro for this concern. Thanks, R

Re: $$Excel-Macros$$ Problem with Sorting in row wise

try this Sub Macro1() Dim i As Long For i = 1 To Sheets(1).Range("a1").End(xlDown).Row ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("b" & i & ":i" & i), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlS

$$Excel-Macros$$ Problem with Sorting in row wise

Respected Sir, I have many 500 rows in my excel sheet i want sort all row ascending order. for exp 1 row 102 103 105 110 120 2 row 103 102 110 105 120 how i convert it into 1 row 102 103 105 110 120 2 row 102 103 105 110 120 -- -

Re: $$Excel-Macros$$ Re: Array or Variant ???

Its a variant type Variable.. On Mon, Feb 14, 2011 at 8:12 AM, hanumant shinde wrote: > also pls tell me if dim abc is array then > does dim abc is equal to dim abc() ? > > > -- > *From:* hanumant shinde > *To:* excel macros > *Sent:* Tue, 15 February, 2011 1:38:21 A

$$Excel-Macros$$ error checking VBA Excel 2003

I have written a sub routine to add a name to a dynamic list but I have three problems with it and would be grateful for some advice. First the routine:- Sub InputNewUser() ' ' InputNewUser Macro ' Macro recorded 01/02/2011 by Brian ' Dim Newuser As String Dim nextRow As Long Dim flag As Boolean

Re: $$Excel-Macros$$ RASHI QUERRY

Thank you Mr. sundervalen, but i need only one formula instead of calculating value for date, month and time separately,. Is it possible? and thank you to Mr. Ashish kaul also for help. On Feb 14, 8:42 pm, Sundarvelan N wrote: > Check if mine is ok for you > > Thanks, > Sundarvelan, > 9600160150

Re: $$Excel-Macros$$ Load image from the url

Sub test() UserForm1.Image1.Picture = LoadPicture("D:\koul\krishna.jpg") UserForm1.Show End Sub On Tue, Feb 15, 2011 at 11:55 AM, San Pat wrote: > How I can load a image from a url using the LoadPicture function in > userform. > > Regards, > > -- > > -

Re: $$Excel-Macros$$ A little OT

The biggest confusion here is the difference between the Worksheet OBJECT: Sheet1 the Worksheet NAME:   Sheet1 and Sheets ARRAY: Sheets(1) An Excel workbook must contain at least one sheet. Excel will INTERNALLY "Identify" this sheet object as "Sheet1" and will initially NAME the sheet "Sheet

Re: $$Excel-Macros$$ Nos. of Sundays between two days

Thank you very much for the prompt reply Sir. - Original Message - From: ashish koul To: excel-macros@googlegroups.com Sent: Monday, February 14, 2011 8:17 PM Subject: Re: $$Excel-Macros$$ Nos. of Sundays between two days start date in a1 and end date in a2 no of sun