$$Excel-Macros$$ Need help

Hello, I have formulated a macro to search data, from a worksheet, using user forms. User form has Date picker and couple of comboxes. Idea is to search between two dates along with two criterias. My problem is, macro doesnt function if I do not enter all the search criterias. Ideally, it sh

$$Excel-Macros$$ Need Help

Kindly help me To allocate the data in macro branch wise and every branch shouid be save in new book , Regards, karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

$$Excel-Macros$$ Need help !!!

Hi all, I have created small code but it is showing error message as "Object required". *The code is -* Sub gen() If Sheet1.Range("A2").Value > 50 Then Sheet1.Range("B2").Text = "You have entered the value above 50" Else Sheet1.Range("B2").Text = "You have entered the value below 50" End If End Su

$$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

$$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

$$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

$$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

$$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

$$Excel-Macros$$ Need Help....!

Hello All I am looking for a help to create a file in excel which can capture the exact tenure of people in an organization. Your inputs can help me in achieving this. I am looking for a report in which excel can segregate the staff in the following categories. Name Date of Joining Ra

$$Excel-Macros$$ Need Help

I need your help. Do you know how to clear the clipboard of MS Word 2003 through VBA Code? If you have any idea, do let me know please. I have tried this code : Application.CommandBars ("Clipboard").FindControl(ID:=3634).Execute But it through an error. Thanks. Ayush Jain --~--~-~

$$Excel-Macros$$ Need Help

Dear Group Members Need ur help Is it possible taht if we can pickup fields Name from drop down (list) other than original pivot table & same time Pivot table will changed automatically? Pls chk attached file its explain itself Thanks & Regards Harish Upadhyay +919773284902 --~--~-~--

$$Excel-Macros$$ Need Help

How can i open Password protected XLA file? Regards, Viral Pandya --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit t

$$Excel-Macros$$ Need Help

Hi All, I am trying to create a spreadheet of indian equity market. In the spreadsheet I have Nifty 50 stocks. I have linked the data from nse india site. I have also created the drop down box of all the 50 scrips. Now my problem starts... 1))All i want to do is to keep a timer of less than 1 min

$$Excel-Macros$$ Need Help!!!!!!!!!!!!

Dear All, I want to know the how i can find the *repeat or duplicate* value in same column or row.(without Advance filter) -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ - Some i

$$Excel-Macros$$ Need help......

HI All, I created a macro PERSONAL.XLSBvery long time ago...now i need to add two more module init..bu the problem is i forget the vba password. Plz help.. I'm also attaching the macro workbook...can some one break the code for me --~--~-~--~~~--

$$Excel-Macros$$ Need Help

Hi All, Can you pls help me on the attached problem... Hope to see your response soon Regards, Hemant Shah --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel

$$Excel-Macros$$ Need Help

Dear Members, Can any body remove the attached file's password which will highly appriciated. Regards, Aamir Shahzad --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ Need Help

Hi Excel Gurus, Kindly need your assistance on the query -mentioned in the attachment. Thanking you in advance. Regards Rags!!! -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text)

$$Excel-Macros$$ Need help

Hi, In the attached file the basic data is in coloured cells. What I want to achieve is that I want to list all items from the basic data that are not zero in column A and that too alphabetically i.e A1, then A6 then A8 and so on. Is there any method in excel so that I can do that. Thanks KK -

$$Excel-Macros$$ need help

hi i have a input in sheet 1 and its not limited and want result in sheet2 like in col1 regards ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

$$Excel-Macros$$ Need Help

Dear Friends, Please help me for solution of attached file. I am stuck now and need your help on this regard. Thanks, Imran Khan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a

$$Excel-Macros$$ Need Help

Sub SumCol() ActiveCell.Offset(Selection.Rows.Count).Value = _ "=sum(r[-" & Selection.Rows.Count & "]c:r[-1]c)" Selection.Resize(Selection.Rows.Count + 1).Select End Sub What is the meaning of this code -- Shiv Goel 8NBYN060 ICFAI National College,YNR 9416275776 --

$$Excel-Macros$$ Need Help

I have excel file. Its calculation in option always go Manual from automatic mode. So all calculation to be made manually. any solution. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

$$Excel-Macros$$ Need Help

Hi All, I need help in the attached file. Actually Column H, I, J, K, L, & M is vendor name which i dont want to show. In row 6, 7, 8, there will be only one code which i want to come automatically in Column G (Coding). Please help. Thanks, Imran Khan Project Control Engineer KBR - Kellog Br

$$Excel-Macros$$ need help

Hi, Do we have any tools to automate financial reports? -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

$$Excel-Macros$$ Need Help

Dear Friends, I want to arrange the series of data in a coloum to series of row. For example Data is available in the following Format: A B C D 1 Cat 2 Rat 3 Dog 4 Lion 5 Want to arrange the data as : A B C D 1 Cat Ra

$$Excel-Macros$$ Need Help

Hi Group, I am not very knowledgable with VBA and would like some help solving a tedious problem. - I would like to copy and past each page contained on this URL into 1 spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for the second 50 etc etc.. http://contests.covers.com/Handi

$$Excel-Macros$$ Need Help !!

I have piece of MACRO as below, Sub LaunchHMRCMARK() Dim NTCUSER As String MARKPATH = InputBox("Enter HMRCMARK PATH - ") 'Filename = InputBox("Enter XML file name here - ") Set oshell = CreateObject("WScript.Shell") oshell.Run "cmd", 9 Sleep 100 oshell.SendKeys ("cd ") oshell.SendKeys MARKPATH os

$$Excel-Macros$$ Need help

Dear expert I have some data stored in excel sheet and I wanted to convert the same in paragraph form can I know how can I convert the same in paragraph form. Warm regards Madhav Vyas Sent on my BlackBerry® from Vodafone -- --

$$Excel-Macros$$ Need Help

Hi All, Please help. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, Aug 4, 2010 at 10:49 PM, prabhakar thakur < prabhakarthak...@gmail.com> wrote: > Dear Group, > I need help to a month & year wise report, I > made a povit but couldn't get correc

$$Excel-Macros$$ Need Help

Hi All, Please assist in this concern i wanted to prepare excel macro where in i can consolidate different excel workbooks data into one excel workbook. so please send me if it is possible through vba macros.if any one of the group is having the script or macro for performing this activity please

$$Excel-Macros$$ Need help

Hi all i have a excel sheet need help, i wanted to use excel formula not pivot table or chat -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com* -- -

$$Excel-Macros$$ Need Help

Hi friends, Dear Adorable group... please share if any one of us are having excel addin's . Moreover i am having query regarding the excel addin's. Can any one suggest how to create the excel addins i just tried creating this addins . but could not use properly. Thanks for your help in advance.

$$Excel-Macros$$ Need help

Dear All Group Member, Kind Attn- Mr. Ayush Jain, I need a excel macro book for start to bottom level creating macro, preparing interview skill & help VB also. Please suggest. -- Thanks, Prabhakar Thakur New Delhi +919953736776 -- --

$$Excel-Macros$$ Need Help

Dear Team, Please find attach file in which i have explained my requirement and request of your kindness to provide me the solution, *as i have more than 4000 records of such data*. Thanks & Regards Priya -- -- Some

$$Excel-Macros$$ need help

Hi Guys need your help, I have 25 agenst overall & I have to record & listen to 12 calls per agent, While rating a call i'll put scores in sheet one & automatically it should get updated in sheet 3 i.e. summary sheet & all the scores shuld get accumulated... Thanx in advance Regards, Lucky --

$$Excel-Macros$$ Need Help

Hi, i have multiple sheets and i want to count the number of instruments in one go, with COUNTA am not able to get. I tried grouping the sheets but could't get the count of all sheets. need your suggestion Thanks, Prathima -- -

$$Excel-Macros$$ Need Help

My colleague has this equation set up to count the number of cells within a range that are three standard deviations higher than the mean. But when he has N/As in the set, it's returning those in the count as well. Do you have any ideas on how to adjust the formula to only count straight numeric v

$$Excel-Macros$$ NEED HELP

Dear All, Need helpI would like to put this data in graph.so need help with that.would appreciate if you guys can assist me with this. Thanks n Regards Anupam -- -- Some important links for excel users:

$$Excel-Macros$$ Need Help!

Hi, Hi i have attached my file i want in sheet 2 there are column c in that i want the name from sheet 1 but there are two condition first is match by ID then match by Name as well then how can we do this -- syed aliya -- ---

$$Excel-Macros$$ need help!

Plz solve my problem! -- syed aliya -- -- 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.linkedi

$$Excel-Macros$$ Need Help

Dear gurus, please sought out my problem as attached where i m confusing or what is the solution thanks in advance ROHAN 9818247278 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips trick

$$Excel-Macros$$ Need Help!!!!!!!!!!!!!!!

Hi, I have Two Different Sheets one is mail sheet and another is general sheet. when i open the both sheets and select the arrange all then tilled, then booth sheets open side by side now my Question is, is it possible when i select one name in main sheet it automatically highlight in the Second

$$Excel-Macros$$ NEED HELP

Hi Experts, Due size constance i am sending in two zip folders please check second mail for excel files dump. (This is Second mail please check this one as well -- thanks for cooperation) This report is sent on daily basis please help in this concern if it is automated it could be very much th

$$Excel-Macros$$ Need Help

Dear, pls let me know how i can create excel macros in MS ACESS 2003. thanks in advance... regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.co

$$Excel-Macros$$ Need Help

Hi, I need help in VBA code. I have excel sheet on which data is write as below mention Input A BC D 1 X1 1.511/11/2008 01/11/2010 2 X2 2.511/12/2009 01/11/2010 3 X3 3.511/01/2010 01/11/2010 I want O

$$Excel-Macros$$ Need help --------

Hi Team, I had create Compound Calculator in Excel VB sheet , i had already set the Formula in VB but when i Click on the Calculate Button it shows error, hence i request you to help me on this. Regards -- -- Som

$$Excel-Macros$$ Need Help

Hello, I need IF formula in attached sheet. IF Column C>0, Then Pre-Ops otherwise Construction, IF Column F>0, then Commissioning otherwise Pre-Ops & IF Column I>0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran -- FORUM RULES (986+ members already BANNED

$$Excel-Macros$$ Need Help !!!!

Hi Friends, Please help me on the sheet provided as an attachment. Waiting for your reply !!! Thanks ! -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ Need help

Hi, Please help me to collect data in attached file.. Regard Manoj -- 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, Urg

$$Excel-Macros$$ Need help

Dear Excel Guru, May I know how to vlookup 2003 Excel to 2007 excel... Thanks & Regards, Sriram G (chennai) -- 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. Po

$$Excel-Macros$$ Need Help

Dear Expert, Please help me to find rank in attached file.. Regard Manoj -- 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

$$Excel-Macros$$ Need help

Hi Team, Please help in the attachment file Regards karthik.N -- 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, N

$$Excel-Macros$$ Need help

Dear Team I want the performance count total allocate to Agency fe , date wise for done,dp Thanks karthik.N -- 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. Po

$$Excel-Macros$$ need help

Dear Experts, Kindly find the attached sheet and resolve the problem.. -- 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,

$$Excel-Macros$$ NEED HELP

-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answere

$$Excel-Macros$$ need help!!!

Hy guys! I am a student from holland, doing my thesis. and i need some help with excel (i never had to use it before, so have no clue on how it works, tried so much already and am still failing, regular sites do not help at all) I am trying to convert my time notation: min,sec ex. 23,54 into a m

$$Excel-Macros$$ Need Help

Dear Sir, Please find the attached file.. we have to calculate time duration starting from 09:30 to 07:30 for ladies and gents we have to calculate duration starting from 09:30 to 08:30 How many ladies working in between 09:30 to 07:30 How many gents working in between 09:30 to 08:30 --

$$Excel-Macros$$ Need Help

To All:- PLease help me to provide formula to eliminate the space. Example file attached. Regards, *Imran Khan* -- 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

$$Excel-Macros$$ Need Help

I need Excel formula or VBA for the following. *) To set cell width(for headers). *) To make hyper link text blue. *) Font Formatting(for headers). Regards, Chandru -- 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

$$Excel-Macros$$ need help

Dear sir's, I have 3 excel files, which are very old, i kept password protected, but now i have forgotten those password, plz help me to recovery password. regards, thameem.m -- 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 Facebo

$$Excel-Macros$$ Need Help

Hi Expert, we need your help we have attached excel file. actuall i have data based on Wid and i have to update in attached as mentioned below based on formula WID Months 1 April 1 May 1 June 1 July 1 August 1 September 1 October 1 November 1 December

$$Excel-Macros$$ Need Help

Hi All, Currently I am working as a MIS-Lead but I want to build my carrier in SAS and I have done MCA so could you tell me the best institute for SAS in DELHI region,so that after doing i can get the good JOB -- syed aliya -- -

$$Excel-Macros$$ Need Help

Can excel file such as reports be access from web or can be acccess as web pages suppose we have 10 sheets but from some url we want to see the reports -- syed aliya -- -- Some important links for excel users: 1. Fo

$$Excel-Macros$$ Need help

Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the sub

$$Excel-Macros$$ Need help

hi experts, please advise the formula to convert the alphabets to numbers. for example a =1 b= 2 c=3 acb =132 like this for each alphabet it should convert text to number. Thanks for your help Regards, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

$$Excel-Macros$$ Need help

Hi Team, Need help in using "vlookup & mid" funtion. Below are the details I have a excel workbook in which data is present in 2 sheets. Sheet1: - Column A is having unique ids which is having combination of text and numeric data and column B is having corresponding numeric values. Sheet2: - C

$$Excel-Macros$$ Need help

Hi Exports, Pls find the attached file. -- *Regards* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

$$Excel-Macros$$ need help

I have worked on macros but not at a advanced level. Now i have been asked to do the following and need help 1. list down all excel files if a folder is selected by a user. i have created the browse button which takes me to browse folder whre i can select a folder.also created a fetch command

$$Excel-Macros$$ Need help.

Hi Experts, Please find the attached excel. My requirement is : 1. There should be only one command button. 2. There should be option for command button like Sum, Average, Sumproduct etc.. i can select the formula whichever is required. 3. If i select the cell "I4" and if i press the

$$Excel-Macros$$ Need help.

Hi experts, Any updates...? Prabhu R On May 10, 2013 12:40 PM, "Prabhu Pinky" wrote: > Dear Anil, > > Please find the attached file. > > One more help needed. > > In the attached file there is three sheets. > > First sheet is the data where i will update week on week. By the end of > month i hav

$$Excel-Macros$$ Need help

Dear Members, plz help me to get formuale for high-lighting selected cells automatically, when value of one cell get 0 or 1 etc regards Thameem.M -- 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 @ htt

$$Excel-Macros$$ Need help

Dear all, one more help needed, I want to highlight range of cells, based on today date, for example, i have file 1 and file 2, I will update file 1 every time and there is link (vlookup) in file 2 with file 1, in file 1, I will just enter dates, suppose i opened file 2, if there is dates of to

$$Excel-Macros$$ Need help

I am using windows 7 i am not using genuine software for the last 2 years now i have message on my scree that this copy of winos is not genuine and i want to remove this. how can i do that pls help me out. Thanks, Regard -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

$$Excel-Macros$$ need help

Dear all, for example I have one excel with 40 sheets, in those sheets I have one total r sum... I need formuale or codes, to sum all total of 40 sheets in one sheet... -- 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

$$Excel-Macros$$ Need help

Hope you get this on time, I made a trip to Ireland and my Bag was stolen from me with my passport, cash and credit cards in it. Unfortunately, I made contact with my bank but they are not providing a fast solution. I will be glad if you can lend me the sum of 1,500 usd or any amount you can afford

$$Excel-Macros$$ Need Help

Dear Friends, Need your help in IF formula. I have attach the file for your input. Thanks & Regards, *Imran Khan* *Lead Planner - OR/CSU* Ras Al-Khair Industrial City P.O. Box 11342, Jubail Industrial City - 31961, Saudi Arabia Mobile Phone: +966-555160349 Email : kha...@mac.maaden.com.sa

Re: $$Excel-Macros$$ Need help

Since I don't know anything about your workbook or the types of values, I'd suggest something like what follows.I've run into issues where Excel doesn't treat a "null" value and a "blank/empty" cell as the same.Plus, when using something like: wshD.Cells(r, "C")the "default" property is "value",

Re: $$Excel-Macros$$ Need Help

Dear Kartik, Can you share sample workbook. On Tue, Mar 6, 2012 at 6:35 PM, karthik N wrote: > Kindly help me > > To allocate the data in macro branch wise and every branch shouid be > save in new book , > > > > > Regards > Karthik > > -- > FORUM RULES (986+ members already BANNED for viola

Re: $$Excel-Macros$$ Need Help

FYI. Regards karthik.N On Wed, Mar 7, 2012 at 1:05 PM, NOORAIN ANSARI wrote: > Dear Kartik, > > Can you share sample workbook. > > On Tue, Mar 6, 2012 at 6:35 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and every branch shouid be >> save in new bo

Re: $$Excel-Macros$$ Need Help

Dear Kartik please use below codeand Change red color path Sub Sheet_Creater_Deptwise() Dim rng As Range Dim rng1 As Range Set rng = Sheet1.Range("G1:G" & Sheet1.Range("G65536").End(xlUp).Row) rng.Copy Sheet1.Range("H1") Set rng1 = Sheet1.Range("H1:H" & Sheet1.Range("H65536").End(xlUp).Row) rng1.S

Re: $$Excel-Macros$$ Need Help

see attached sheet.. On Wed, Mar 7, 2012 at 3:12 PM, karthik N wrote: > Kindly help me > > To allocate the data in macro branch wise and every branch shouid be > save in new book , > > > Regards, > karthik.N > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise

Re: $$Excel-Macros$$ Need Help

Thank You Regards karthik.N On Thu, Mar 8, 2012 at 9:56 AM, NOORAIN ANSARI wrote: > see attached sheet.. > > > On Wed, Mar 7, 2012 at 3:12 PM, karthik N wrote: > >> Kindly help me >> >> To allocate the data in macro branch wise and every branch shouid be >> save in new book , >> >> >> Regar

RE: $$Excel-Macros$$ Need help !!!

Use value property instead of Text From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Dayne Sent: Apr/Tue/2012 10:12 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help !!! Hi all, I have created small code but it is

Re: $$Excel-Macros$$ Need help !!!

of Text > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne > *Sent:* Apr/Tue/2012 10:12 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need help !!! > > ** ** >

RE: $$Excel-Macros$$ Need help !!!

I think Text is a read only property here Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Dayne Sent: Apr/Tue/2012 10:16 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help !!! Thanks Rajan It works so it

Re: $$Excel-Macros$$ Need help !!!

e > *Sent:* Apr/Tue/2012 10:16 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need help !!! > > ** ** > > Thanks Rajan > > It works so it means that > > - we generally use text property in VB but in excel it takes value > p

$$Excel-Macros$$ Need help--macro

Hi Experts, pfa refer attachment Query I want macro which will create different workbooks according tounique user column. and all workbooks will have name of user and their data respectively in same format Please help me. -- FORUM RULES (986+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ Need help

Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times.Dear excelmacros! Get Yourself a cool, short @in.com Email ID now! -- FORUM RULES (986+ members already

Re: $$Excel-Macros$$ Need help

Hi, Try this formula, =CEILING(ROW()/11,1) On Wed, Apr 18, 2012 at 1:36 AM, Krishnaraddi wrote: > > Hi Experts, > > I have attached the sheet with question. I require formula which will give > number to repeat 11 times and 12th numer should be next serial number which > should reeat again 11

Re: $$Excel-Macros$$ Need help

Dear Krishnaraddi, Please try it.. =IFERROR(OFFSET(A2,-12,0)+1,1) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Apr 18, 2012 at 2:06 PM, Krishnaraddi wrote: > > Hi Experts, > > I have at

Re: $$Excel-Macros$$ Need help

m: Krishnaraddi Sent: Wednesday, April 18, 2012 3:36 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number whic

RE: $$Excel-Macros$$ Need help

Fill A1:A11 =1 then put formula in A12 = A1+1 and Drag Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Apr/Wed/2012 06:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help How about a nice macro

Re: $$Excel-Macros$$ Need help

Dear Krishna, You can also try =INT((ROW()-1)/11)+1 On Wed, Apr 18, 2012 at 2:06 PM, Krishnaraddi wrote: > > Hi Experts, > > I have attached the sheet with question. I require formula which will give > number to repeat 11 times and 12th numer should be next serial number which > should reeat a

Re: $$Excel-Macros$$ Need help

Hello All Expert,Can anyone give me any template or suggestion On Fri, Apr 20, 2012 at 10:41 AM, sushil kumar wrote: > I want to multiple user can use do the entry in excel sheet and that data > save into central access database > > Please help any one this is very urgent for me > > > > -- > FORU

Re: $$Excel-Macros$$ Need help

Try Using Workbook Sharing.. in Maped Network Drive... On Fri, Apr 20, 2012 at 12:54 PM, sushil kumar wrote: > Hello All Expert,Can anyone give me any template or suggestion > > > On Fri, Apr 20, 2012 at 10:41 AM, sushil kumar > wrote: > >> I want to multiple user can use do the entry in excel s

FW: $$Excel-Macros$$ Need help

Group is not allowing large size Files. So I am sending the Excel file and Access DB on your personal mail. J Rajan From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Apr/Fri/2012 06:55 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need help Hi,

Re: $$Excel-Macros$$ Need Help

Hi friends, pls do needful. Thanks. Mangesh. [sent frm phone] On 6/7/12, Mangesh Dayne wrote: > Hi Friends, > > Please find the attached sheet and for this, I need average for the pivot > table. > Also explain me procedure. > > Thanks > > > Mangesh > > -- > FORUM RULES (986+ members already BANNE

Re: $$Excel-Macros$$ Need Help

Dear Mangesh, Goto to Excel Option-Fomula-Uncheck Use GetPivot Data function Then use in B8 *=AVERAGE(B3:B6)* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 7, 2012 at 11:01 PM, Mangesh Dayne wrote: > Hi Friends, > > Please find the at

Re: $$Excel-Macros$$ Need Help

*@Noorain, is this option available in MS Excel 2007? If yes, then can you please send a snapshot for exact location, because I am not getting this option in my MS Excel 2007.* On Fri, Jun 8, 2012 at 7:24 AM, NOORAIN ANSARI wrote: > Dear Mangesh, > > Goto to Excel Option-Fomula-Uncheck Use GetP

  1   2   3   4   5   6   7   8   9   10   >