Re: $$Excel-Macros$$ Need Help with VBA in Excel

can u share any sample file or user form if u have created any? On Fri, Dec 20, 2013 at 11:57 PM, PG wrote: > Hi, > I have a problem to solve here. > > I have a master list of about 1000 records, which has Order ID, Customer > Name, Address, and Order Amount columns. > Now I need to print an or

Re: $$Excel-Macros$$ Need Help With VBA using VLookup

Pls ptovide sample data with desire output. Regards, Swapnil. On Feb 21, 2014 11:23 PM, "Erick C" wrote: > Good morning VBA masters. > > Let me start off by saying I am not a VB expert by any means. I am > getting a bit better with modifying small things here and there, but I am > absolutely lo

Re: $$Excel-Macros$$ need help to write a macro

Hi Try this: Enter sheet name in Row A2 to A10 Sub AddSheets()Dim cell As Excel.RangeDim wsWithSheetNames As Excel.WorksheetDim wbToAddSheetsTo As Excel.Workbook Set wsWithSheetNames = ActiveSheetSet wbToAddSheetsTo = ActiveWorkbookFor Each cell In wsWithSheetNames.Range("A2:A10") ' Change ra

RE: $$Excel-Macros$$ Need help related to macro event

Hi Vijay, How about a userform with your "busy" message? You could either have the userform's code perform the task (save, calculate,.) or if you want to perform that task from outside the userform, set the userform's ShowModal property to False so control will return to the procedure that displa

Re: $$Excel-Macros$$ Need help related to macro event

Hi Asa, Thanks for quick reply, can you please provide me code for the same, see I wanted to show message whenever sheet calculating or saving data and message userform must hide automatically. Thanks Vijay On Thu, Apr 26, 2012 at 11:09 AM, Asa Rossoff wrote: > Hi Vijay, > > How about a u

RE: $$Excel-Macros$$ Need help related to macro event

fter the file is saved, so that case should be straightforward. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vijay Mane Sent: Thursday, April 26, 2012 8:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help related to ma

RE: $$Excel-Macros$$ Need Help - To rename the sheet

Use this: Private Sub Workbook_Open() Dim wksSheet As Worksheet For Each wksSheet In Me.Worksheets If wksSheet.Name Like "Result*" Then wksSheet.Name = "Result_" & Val(WorksheetFunction.Substitute(wksSheet.Name, "Result_", "")) + 1 End If Next wksSheet

Re: $$Excel-Macros$$ Need Help - To rename the sheet

My God ! So Quick !! Even Shatabdi Express is not so Fast !!! Thank you so much Rajan On Thu, Jun 7, 2012 at 8:28 PM, Rajan_Verma wrote: > Use this: > > ** ** > > Private Sub Workbook_Open() > > Dim wksSheet As Worksheet > > For Each wksSheet In Me.Worksheets > >

Re: $$Excel-Macros$$ Need Help for Macro or Formula

check the sheet. On Fri, May 14, 2010 at 9:25 PM, Mahesh parab wrote: > Dear All > > for attach sheet i need formula or macro, I will appreciate any help on > this. > 1.if for code in column A ,status in column C is paid then D column status > should be process > 2.if status in column C is n

Re: $$Excel-Macros$$ Need Help for Macro or Formula

Thanks Harry i want formula for Column D. the formula what i have mention in email needs to be enhance or change 1. if for code in column A, status in column C is Paid,Not Paid,Awaiting then Final Status should be Not to process in column D 2. if for code in column A, status in column C is only

Re: $$Excel-Macros$$ Need Help for Macro or Formula

Enter Following Formula in Cell D2 =IF(C2="Paid","Process",IF(C2="","",("Not to Process"))) Regards Jagjeet SIngh On May 14, 8:55 pm, Mahesh parab wrote: > Dear All > > for attach sheet i need formula or macro, I will appreciate any help on > this. > 1.if for code in column A ,status in colum

Re: $$Excel-Macros$$ Need help in automating this report

Hi Girish, Thanks a ton for working on this report. You are great. You have made my day. Thanks & Regards, Yogesh On May 20, 10:21 am, girish naik wrote: > Hi Mate your work is done. > > Please check if this meets your requirement.. > > Click on the button which is on Document map sheet to Gen

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format--> Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN wrote: > Hi friends, > > Need help this is data

Re: $$Excel-Macros$$ Need help to convert date formate

Oops Missed to attach the file... Now done... On Sun, Aug 29, 2010 at 12:56 AM, Vinod N wrote: > Hi Vilas, > > Please select column A and use Text-to-Columns under Data menu... Next > choose the desired date format from Format--> Cells option.. Solved copy of > your sample file attached... >

Re: $$Excel-Macros$$ Need help to convert date formate

Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N wrote: > Hi Vilas, > Please select column A and use Text-to-Columns under Data menu... Next > choose the desired date format from Format--> Cells

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vinod, Thank you very much, Vinod can you give me vba code for that issue Regards Vilas On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN wrote: > Hi vinod, > > You are not sending me any attachment please send solve attachment please > > > > > > > > > > > > regards > Vilas > On Sat, Aug 28, 201

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vilas, Please find below the macro recorded by me... Sub Date_Format() ' ' Date_Format Macro ' Macro to convert date format- 8/29/2010 by Vinod ' Columns("A:A").Select With Selection Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > Hi, > > I have two columns A and B. > > column A contains list of tasks and column

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

You are welcome Sharat. Best Regards, DILIPandey On 12/8/10, Sharath Sambrani wrote: > Fantastic!!! > > Thanks a ton Dilip! > > Sharath > > -- Forwarded message -- > From: Dilip Pandey > Date: Wed, Dec 8, 2010 at 8:43 PM > Subject: Re: $$Exc

Re: $$Excel-Macros$$ Need help on Email from Excel

try this http://akoul.wordpress.com/category/email-through-excel-using-outlook/ On Wed, Aug 3, 2011 at 9:26 PM, hemant shah wrote: > Dear Team, > > I need a help on emailing from excel itself. > I have explained all the steps in the attached excel. > > Regards, > > -- > -

RE: $$Excel-Macros$$ Need help on Email from Excel

Team, Can you please help me on my query. I want you to work on attached file itself. Waiting for your response Regards, -- Forwarded message -- From: hemant shah Date: Wed, Aug 3, 2011 at 9:26 PM Subject: $$Excel-Macros$$ Need help on Email from Excel To: excel-macros Dear

Re: $$Excel-Macros$$ Need help for Hardest formula solution

Are you saying that you want to HIDE COLUMNS??? Please define your problem with examples if possible. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, September 20, 2012 1:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Ma

Re: $$Excel-Macros$$ Need Help with IF(AND formula

Hi, If you are using Excel 2007 or 2010, then you can use the SUMIFS or COUNTIFS to achieve the same. Cheers Andy On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee wrote: > Hello- I am trying to write a formula that would return the COUNT and > SUM, with 3 criteria elements. > > IF(AND(data!F:F =

Re: $$Excel-Macros$$ Need Help with IF(AND formula

You can also try... =SUMPRODUCT((data!F:F = "A")*(data!B:B="04 - Closed Won")*(data!D:D="Oct-11")*(data!K:K=0)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

RE: $$Excel-Macros$$ Need Help with IF(AND formula

If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum. If using an older Excel, use SUMPRODUCT for either. IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! D:D, = Oct-11),count, "0") =COUNTIFS(data!F:F,"A",data!B:B,"04 - Closed Won",data!D:D,DATE(2011,10,1))

RE: $$Excel-Macros$$ Need Help with IF(AND formula

for more info on how the arguments work. Asa -Original Message- From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Tuesday, November 22, 2011 7:38 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need Help with IF(AND formula If you are using Excel 2007+, use C

Re: $$Excel-Macros$$ Need Help with IF(AND formula

Thank you! On Tue, Nov 22, 2011 at 10:30 AM, Jedi Spencee wrote: > Hello- I am trying to write a formula that would return the COUNT and > SUM, with 3 criteria elements. > > IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! > D:D, = Oct-11),count, "0") > > > Can this be done? >

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल > Dear all, > > Can you please help me on resign

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly give one example of what u want in your sheet as to study the data > and analyse the same and preparing format as per

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

fyi regards jitendra singh 9015340017 On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly give one example of what u want in your sheet as to study the data > and analyse the same and preparing format as per your requirement takes a > lot time > > So kindly provide one ou

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Sunita Kindly find the attached file Hope this is as per your req 2012/1/20 सुनिता पौडेल > Dear Priyanka, > > Thank you for the interest shown. Please find attached the example of what > I required. > > > > > On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa wrote: > >> Dear Sunita >> >> Kindly

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Thank you very much for the prompt action. It works as per my requirement. Have a wonderful day! On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly find the attached file > > Hope this is as per your req > > > 2012/1/20 सुनिता पौडेल > >> Dear Priyanka, >> >> Thank you fo

Re: $$Excel-Macros$$ Need help to create a user form.

Hi All, I want you to understand the requirements. Sub Brand numbers & Invoice number combination will be multiple. Can anyone will be help me out to create a user form. for eg: Brand numbers Invoice numbersStatus 90121 97012

Re: $$Excel-Macros$$ Need help to create a user form.

Opening a file to show form. To import the data: Typing data into the form and click the Data Entry To edit data:Click listbox to select data, The data will appear on the form, Edit the data needed, and click Edit Data. 2014-11-12 13:34 GMT+07:00 Kamal Ganeshan : > Hi All, > > I want you to

Re: $$Excel-Macros$$ Need help to create a user form.

Great one buddy! On Nov 13, 2014 4:13 AM, "Bé Trần Văn" wrote: > Opening a file to show form. > > To import the data: Typing data into the form and click the Data Entry > > > To edit data:Click listbox to select data, The data will appear on the > form, Edit the data needed, and click Edit Data.

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at the start of code. and "Application.Calculation = xlCalculationManual" To turn off the automatic calculation at the beginning of the code see example: Dim u As Integer, v As Integer u = Range("Months").Value - 1 Application.S

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you Basole for your message! I have been already using your recommendation on my code, but it still takes a lot of memory. Regards, Isabel On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote: > > Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at > th

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Can u pls share a sample file On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote: > Thank you Basole for your message! > I have been already using your recommendation on my code, but it still > takes a lot of memory. > > Regards, > Isabel > > > > On Saturday, September 12, 2015 at 9:20:05 AM

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hello Ashish, Thank you for your response. This is a simplified copy of my macro. The lines you can find there are repeated multiple times in my final workbook, in different spreadsheets because it has a broader mathematical formulation. Hope this helps, Regards On Saturday, September 12, 201

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

We can avoid using loop in this case, try to replace your looping code with offset and resize, try this another solution Dim u As Integer u = Range("Months").Value - 1 If u > 1 Then Range("ColumnLong").Resize(, u).Insert Range("ColumnFormula").Copy Range("ColumnLong").Offset(, -u).R

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you DP! Thank you very much for your help. It worked perfectly. However, I tried to do the same in Calculation2 sheet, but inserting rows instead of columns and it did not work the same logic. It gives me a syntax error. Could you help me fix this? I used: Dim v As Integer v = Range("Mont

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Hi Isabel, I'am glad that its work, ok here is the problem in out 2nd case 1st, we need to step back to learn about how the function work, cpearson.com have a bunch article about this complete with explanation & sample, you can follow this link *http://www.cpearson.com/excel/optionalargumentst

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

Thank you DP Your explanation was extraordinary. In addition to solve my problem, you taught me a lot! ;) Thank you very much again Regards Isabel On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote: > > Hi Isabel, > > I'am glad that its work, ok here is the problem in out 2nd

Re: $$Excel-Macros$$ Need help using Modules in Excel 2007

First of all, .xlsx files are designed SPECIFICALLY to remove all modules when the file is saved. (Microsoft hoped to use this as a mechanism to reduce the spread of viruses) Second, when you save the file, close and reopen it, (assuming .xlsm or .xlsb format) is the macro module still there? I

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

Try this. On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote: > Hi Team, > > I have one excel sheet in which i need to arrange the data in such a > manner that all the data will come with the help of transpose option under > the one by one. i had try this by many methods but in-vain. Hence pleas

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

Solution with formula. PFA On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote: > Hi Team, > > I have one excel sheet in which i need to arrange the data in such a > manner that all the data will come with the help of transpose option under > the one by one. i had try this by many methods but in-

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

*Hi Team,* thank you very much for helping me Regards On Wed, May 29, 2013 at 1:46 PM, priti verma wrote: > Solution with formula. > PFA > > > On Wed, May 29, 2013 at 1:17 PM, vikas khen wrote: > >> Hi Team, >> >> I have one excel sheet in which i need to arrange the data in such a >> manner

Re: $$Excel-Macros$$ need help to create Manpower Assigning report

what you want?.. . Enjoy Team XLS On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan wrote: > Dear Friends > > kindly hep me to create a manpower assigning report. > > E.g: > > *Project name *:xx > *Input:* > *Per day target*:according to project name its should target val

Re: $$Excel-Macros$$ need help to create Manpower Assigning report

Template for Manpower as assigning report. On Thursday, 29 August 2013 15:55:12 UTC+5:30, XLS S wrote: > > what you want?.. > > . > > Enjoy > Team XLS > > > > On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan > > wrote: > >> Dear Friends >> >> kindly hep me to create a manpow

Re: $$Excel-Macros$$ need help with nested IF AND formula

It is better to attached a sample sheet. On Wed, Dec 4, 2013 at 6:05 PM, Dan Burfield wrote: > Hi, thx in advance for your help. I am trying to build a spreadsheet that > will help calculate medication doses. The variables involved are weight > (wt) and creatinine clearance (CrCl). Here is the

Re: $$Excel-Macros$$ need help with nested IF AND formula

try: =IF(C4>121,IF(C8<50,10,20),    IF(C8<50,(1*C4*60)/(0.75*1000), (2*C4*60)/(0.75*1000)    )    ) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can,

Re: $$Excel-Macros$$ need help with nested IF AND formula

Thanks so much Paul, works perfectly. Happy Holidays! On Wednesday, December 4, 2013 1:39:48 PM UTC-5, Paul Schreiner wrote: > try: > =IF(C4>121,IF(C8<50,10,20), >IF(C8<50,(1*C4*60)/(0.75*1000), > (2*C4*60)/(0.75*1000) >) >) > > *

Re: $$Excel-Macros$$ Need help to filter text by function

Try this =SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",") where cell A1 contains your data.. On Tue, Apr 15, 2014 at 1:06 PM, Ashish Bhalara wrote: > Dear experts > > I have a text as per below. > Matting, Mud Flap-Vista, , , ,,, > > I want remove extra comma from the end as below result b

Re: $$Excel-Macros$$ Need help to filter text by function

Thanks to reply but the "Mud Flap-Vista" is a complete word, there are no need comma between "Mud" & "Flap-Vista". I want to remove only last commas, kindly suggest if possible. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environme

Re: $$Excel-Macros$$ Need help to filter text by function

You may try this.. =SUBSTITUTE(SUBSTITUTE(B3,",,",""),", ,","") Thx On Tue, Apr 15, 2014 at 2:05 PM, Ashish Bhalara wrote: > Thanks to reply but the "Mud Flap-Vista" is a complete word, there are no > need comma between "Mud" & "Flap-Vista". > I want to remove only last commas, kindly suggest

Re: $$Excel-Macros$$ need help to make compare sheet plz

please send the sheet with example On Tue, Mar 6, 2012 at 6:14 AM, sherif azat wrote: > what i want in the sheet > > -- > 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

Re: $$Excel-Macros$$ Need help in ranking with multiple criteria

Dear Vijay, The easiest way to do that is to select the entire table and then Sort on Multiple Criteria. 1) Quality (Largest to Smallest) 2) Achieved (Largest to smallest) That would do the trick.. Hope that helps... Cheers! Andy On Tue, Apr 24, 2012 at 11:01 AM, Vijay Mane wrote: > > Hi Exp

Re: $$Excel-Macros$$ need help urgently from excel to word

need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul wrote: > hi > > i have a list in excel file with company name website etc, information a > > > and want to put the same in word as i have given in the word format > > > please can anyone give me the vba coding for the same > >

Re: $$Excel-Macros$$ need help urgently from excel to word

thanks a lot bro ... but is it possible to make changes in it so that i can get the result in in the format attched in word document in the first mail On Fri, Jan 29, 2010 at 4:34 PM, ankur wrote: > hi ashish > sorry for late reply > > plz check the attached file , this will help u ..u can

Re: $$Excel-Macros$$ need help urgently from excel to word

hi ashish i dont know how to export data in the abovesaid format, taking my code as base other members can modify as per needlet see On 29/01/2010, ashish koul wrote: > thanks a lot bro ... but is it possible to make changes in it so that i can > get the result in in the format attched in

Re: $$Excel-Macros$$ Need help for macro- changing cell value

See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote: > Dear All > > I need macro for when i open workbook, A1 cell value, will display 1 to 4 > numbers one by one, time interval should be 15sec. > i want this to create animation effects in pie chart, cell A1 is link with > data by

Re: $$Excel-Macros$$ Need help for macro- changing cell value

Thank u so much Christopher ! On Fri, Feb 26, 2010 at 1:48 PM, Christopher Luka < christopher.l...@gmail.com> wrote: > See attached. > > > On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote: > >> Dear All >> >> I need macro for when i open workbook, A1 cell value, will display 1 to 4 >> numbers

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

That's actually very tricky to do, and has all kinds of potential for circumventing it. The problem is that when VBA macros run, they usually have "control" of Excel. they don't run in "background". that means that a normal macro that runs and monitors the time wouldn't allow the person TAKING th

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

Hi Paul, I got the code similar to this, but dont exatly how to edit this as per my requirements. http://www.atlaspm.com/faqxlselfclose.html As I said in the first post, once he clik on hyperlink(i.e., in 1st sheet), it will count till 60 Minutes, and before 15 min it shud remind him. after 60

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

Hello Team, I got the code here http://www.atlaspm.com/faqxlselfclose.html could you please edit the same as to ful fil my requirements below. And it should pomp up msg box at 45 min sayin "This test will over in 15 min" lik that. Thanks. Vinu vinu wrote: > Hello Friends, > > I build a model

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

the =Text() function diplays numbers in different formats. replace your Round() function with: text(round(sum(a2:a4),0),"#,###") =CONCATENATE("FY09-Q4",CHAR(10)," (",TEXT(ROUND(SUM(A2:A4),0),"#,###"),")") curiously enough, you SHOULD be able to use: ="FY09-Q4" & CHAR(10) & " (" & TEXT(ROUND(SU

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

Hi, You can modify your formula as =CONCATENATE("FY09-Q4",CHAR(10)," (",TEXT(SUM(A2:A4),"0,000"),")") . Regards, Deepak On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > thanks Paul, > > it worked amazingly! > > :) > > On Tue, Jun 8, 2010 at 8:19 PM, P

Re: $$Excel-Macros$$ Need help deleted column in excell sheet

In my opinion, data lost. On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed wrote: > Dear guys, > > > > I have a excel sheet with big data. Its contain one date column > unfortunately I delete and save it. It’s possible to recover that > column. > > > > Thanks in Advance. > > > > Regards, > >

RE: $$Excel-Macros$$ Need help deleted column in excell sheet

Hi, Do you back-up regularly? If so, it may be in your back-up files. If not, then it is lost lost. Sorry. Regards - Dave. > Date: Fri, 27 Aug 2010 05:24:43 +0400 > Subject: $$Excel-Macros$$ Need help deleted column in excell sheet > From: idhrees...@gmail.com > To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

can you attach the sample sheet On Fri, Jan 7, 2011 at 8:40 PM, Erick C wrote: > Hello everybody, > > I am in desperate need of some assistance, and I am hoping someone may > be able to give me a hand. I am still a bit of a novice when it comes > to vba code writing, so I am hoping that it may

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

Align-left and Align-Right is irrelevent (I think) because "alignment" is a paragraph property, not a string property. What you're saying is that you need the string padded with spaces either on the left or right... So, by example, if you were padding with underscores (_), then the results you'r

Re: $$Excel-Macros$$ Need Help Getting Text To Align Left

Paul - Thank you, this is exactly what I was looking for! On Jan 7, 11:37 am, Paul Schreiner wrote: > Align-left and Align-Right is irrelevent (I think) > because "alignment" is a paragraph property, not a string property. > > What you're saying is that you need the string padded > with spaces e

RE: $$Excel-Macros$$ Need help in Meeting room booking system

Hope it will help you Add this in Your code If Day(Me.DTPicker1.Value) >= Day(Now()) And Month(Me.DTPicker1.Value) >= Month(Now()) And Year(Me.DTPicker1.Value) >= Year(Now()) Then If Hour(Me.DTPicker2.Value) >= Hour(Now) & Minute(Me.DTPicker2.Value) >= Minute(Now) Then MsgBox

Re: $$Excel-Macros$$ Need Help related to XML with excel

Dear Amol, You have try through Developer tab.. On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote: > Hello experts, > > I need help related to following things > > 1) How to import xml file in excel using VBA > 2) how to export xml file using vba > > > Regards, > Amol J > > -- > Join offic

Re: $$Excel-Macros$$ Need Help related to XML with excel

Yes, I am able import and export it using devloper tab, Is it posible using VBA?? Thanks Amol On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI wrote: > Dear Amol, > > You have try through Developer tab.. > > > > > On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote: > >> Hello experts, >> >

Re: $$Excel-Macros$$ Need Help related to XML with excel

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help related to XML with excel Yes, I am able import and export it using devloper tab, Is it posible using VBA?? Thanks Amol On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI wrote: > Dear Amol, > > You have try through Deve

Re: $$Excel-Macros$$ Need Help related to XML with excel

- > *From: *Amol Jadhav > *Sender: *excel-macros@googlegroups.com > *Date: *Thu, 11 Oct 2012 11:54:30 +0530 > *To: * > *ReplyTo: *excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Need Help related to XML with excel > > Yes, I am able import and expor

Re: $$Excel-Macros$$ Need help on Access VBA automating outlook

hi kavita, you should add outlook reference in your excel workbook, which contains this code open visual basic editor (press Alt+f11) go on tool menu click on reference... option Microsoft Outlook 12.0 object library Divaker 9582060233 On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja wrote: > Hi

RE: $$Excel-Macros$$ Need help on Access VBA automating outlook

Excel-Macros$$ Need help on Access VBA automating outlook Hi Kavita, See attachement. On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja wrote: Hi Group members, I have one access tool which is automating outlook. Earlier it was working fine on all the systems in our team but now our o

Re: $$Excel-Macros$$ Need help on Access VBA automating outlook

t Library, for the 2010 version? > > > ** ** > > Aas > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Tuesday, November 15, 2011 5:15 AM > *To:* excel

RE: $$Excel-Macros$$ Need help on Access VBA automating outlook

Hello kavita, I don't have Outlook 2010 installed, but I checked the Outlook 2010 object reference on MSDN @ and noticed MAPIFOLDER isn't listed at all. At http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.map ifolder.aspx it is specified as deprecated, and to use Fol

Re: $$Excel-Macros$$ Need help in building pivot using vba

Hi Rekha Try : Sub Mtest() On Error Resume Next 'delete existing pivot sheet Application.DisplayAlerts = False Sheets("Pivot West").Delete Application.DisplayAlerts = True Sheets("West").Select ActiveSheet.UsedRange.Select 'Count the column colcount = Selection.Columns.Count 'Add Dynamic Name Ran

Re: $$Excel-Macros$$ Need help to mail userform on outlook body

Send us user form with sample data in it . On Oct 1, 2014 3:17 AM, "Sunil Patil" wrote: > Hi firends, > > i have one project. on sheet1 i have modless userform and some values. I > need a vba code in such a way that i can mail the value and userform to > outlook mail body, > so i can perform some

Re: $$Excel-Macros$$ Need help to mail userform on outlook body

It sounds like you're trying to create a userform in Excel, copy the userform to an email in Outlook, Send the email, have the recipient change something and click a button and have the userform respond to your Excel workbook? I don't think you're going to have any luck with that approach. Even

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

Hi You can hide all unwanted col & rows and protect workbook so that user will not be having access to that portion. Thanks On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar wrote: > Dear Seniors, > > I have a data from Colum A to Column D in excel sheet, I want show only > this data in sheet & res

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

Hi Vabz, I'hve follow your insturction and I'hve got my answer but when I'hve unhide the sheet, the data will not showing. please help and advise for the same. Thanks, Ashish kumar On Monday, July 1, 2013 2:06:10 PM UTC+5:30, Vabz wrote: > > Hi > > You can hide all unwanted col & rows and prot

Re: $$Excel-Macros$$ Need Help with Lookup function involving NFL scores

which version of excel are you using and last 4 do you mean from top or bottom of column ? On Tue, Jul 16, 2013 at 7:33 AM, wrote: > > > Hello, > > I am using Excel 2003. I have attached a simple workbook which has two > worksheets. One worksheet is titled "Scores" and the other is "Team Info".

Re: $$Excel-Macros$$ Need Help with Lookup function involving NFL scores

excel 2003 and the last 4 would be the bottom On Tuesday, July 16, 2013 9:36:13 AM UTC-4, ashish wrote: > which version of excel are you using and last 4 do you mean from top or > bottom of column ? > > > On Tue, Jul 16, 2013 at 7:33 AM, > wrote: > >> >> >> Hello, >> >> I am using Excel 2003.

Re: $$Excel-Macros$$ Need Help with Lookup function involving NFL scores

Perfect, thank you so much for your help!! Saves me a lot of time. On Wednesday, July 17, 2013 10:28:34 AM UTC-4, ashish wrote: > check the attachment see if it helps > > > > On Wed, Jul 17, 2013 at 12:15 AM, >wrote: > >> excel 2003 and the last 4 would be the bottom >> >> On Tuesday, July 16, 20

Re: $$Excel-Macros$$ Need help with offset formula for VBA code

Dear Lucky Can you share sample sheet with complete explanation. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Mar 30, 2012 at 5:30 PM, Zibraan wrote: > * > * > *Hi Team,* > * > * > *Need y

Re: $$Excel-Macros$$ Need help with offset formula for VBA code

Start over by telling us what you are trying to do... Code can be greatly simplified. Pls do not use “urgent” in your request. It is rude. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Zibraan Sent: Friday, March 30, 2012 7:00 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Need help with code to automate copy/paste

Hi Erick, I Will glad to help but can you please explain more what you actually want? I mean what will be the input and output.? Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Erick C Sent: Apr/Mon/2012 09:43 To: excel-mac

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

try something like this Sub Macro1() ' suppose ur forumula is in a1 Range("A1").Copy For i = 9 To Range("azz1").Column Cells(1, i).Select Selection.PasteSpecial Paste:=xlPasteFormulas i = i + 7 Next End Sub On Mon, Apr 16, 2012 at 9:51 PM, Rajan_Verma wrote: > Hi Erick, > I Will glad to help but

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

Hi Ashish, Thank you, your suggestion works perfectly! Thanls again for the prompt response! -- 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, Code Problem, and Need Advic

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

16, 2012 11:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help with code to automate copy/paste try something like this On Mon, Apr 16, 2012 at 9:51 PM, Rajan_Verma wrote: Hi Erick, I Will glad to help but can you please explain more what you actually want? I m

Re: $$Excel-Macros$$ Need help to make good format of report

Can you just use data>filter>autofilter on the data sheet. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Karan Singh Sent: Monday, April 30, 2012 7:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help to make good format of report Dear All

Re: $$Excel-Macros$$ Need help to make good format of report

Thanks for replying and your solution, but I know very well that I can do this with filters. But my dear I need this in that excel format which I'v posted on group. I need to automate this file with combo box as I have to give this to my seniors and they dont have much knowledge of excel. So I woul

Re: $$Excel-Macros$$ Need help to make good format of report

Dear Karan, Please find the attached solved query, Hope it will help to you. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Apr 30, 2012 at 9:11 PM, Karan Singh wrote: > Thanks for replying and your solution, but I know very well that I can

Re: $$Excel-Macros$$ Need help to make good format of report

Thanks Noorain for replying, but I'm not able to understand this file. I would request you all to solve my problem with combo box, I would be very thankful to you. Kindly solve my problem according to my format. Thanks Karan Singh On Tue, May 1, 2012 at 12:49 AM, NOORAIN ANSARI wrote: > Dear

Re: $$Excel-Macros$$ need help on maximum value and thier name

PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote: > Dear all, > > It has always been previlege to query on this group whenever needed and > thanks from heart. > > I need one help regarding finding out maximum number and their name in one > cell ? > > Have a wonderful day !! > > Thank you

<    1   2   3   4   5   6   7   8   >