$$Excel-Macros$$ Array of CheckBox
Hi all, I am using MS word 2010. In the word / Excel Sheet document I have created one checkbox object and named it as CheckBox 1.Now , I want to create array of 10 checkbox. How can i do that. Advance thanx Rsh -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work
Use this
Sub EndLoop()
Range("A2").Select
Do
ActiveCell.Value = "2010 Real"
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Offset(0, 1).Value = "Total"
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday, July 14, 2011 5:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work
Hi guys, i have this table where i want to fill the column A with "2010
Real" but stopping when in the same row the column B is "Total" i used Do &
Loop but i can´t seem to find the right code.
sub fill2010real()
Do until range("B:B").value = "Total"
range("A:A").value = "2010 Real"
loop
end sub
I can´t seem to go around this code :(
1001 thanks to all of you!excel-lent as always :)
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Find and replace in all open Excel Workbook
Hi, I am looking for macro where in i can do find replace in all opened excel workbook. Eg., I have 10 Excel workbook(s) where the Common Text is "asdfghjkl" which i want replace with "lkjhgfdsa". Presently I am doing this manually. Request to help me to get the macro. Regs Sunny -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Providing multiple option
Hi All, I have an acadamic question paper on desiginig spreadsheet solution. Need your help. The proprietor of Pizza Kutir has realized that a certain segment of his customers consists of low budget customers, who before placing an order, state the maximum amount (budget) they want to spend, and want to know which Pizza is feasible within that amount. The proprietor was wondering whether he could answer such quest ions using a spread sheet. He would like to experiment with the idea by first developing a spreadsheet, considering only a subset of the options that are offered by his menu card, and using some assumptions about his customer Pizza Kutir offers four different types of Pizza (Veg-I, Veg-II, NV-I, NV-H), each in three different sizes, regular, medium, or large. On any of the above types, the customer can choose to have extra cheese, the cost of which depends on the size of the Pizza. Furthermore, for an extra cost of Rs. 30, any of the above types can be ordered in what is called its feast-version (the non-feast version is called the normal version). The prices for the various type-size combinations and the extra costs for extra cheese and feast-version are given in the following table. For example, one unit of the NV-II Pizza in medium size, feast-version with extra cheese, costs Rs 240+45+30 = Rs.315. Similarly, one unit of large size, Veg-I with extra cheese, normal (non-feast) version costs Rs. 260 + 65 + 0 = Rs. 325. TypeSize RegularMedium Large Veg. – I75 150 260 Veg. – II 130 230 310 NV – I 95 200 310 NV – II 140 240 340 Extra Cheese35 45 65 Each of the 3 sizes is available in its feast version for Rs. 30 extra. A number of other options such as toppings are usually offered, but can be ignored for the task at hand. To further simplify the analysis, the proprietor assumes that the low budget customers want the proprietor to suggest them only alternatives each of which consists of one unit of a Pizza and that the budget of a customer never exceeds the price of the costliest combination. In case the budget permits several alternatives, the proprietor wants to rank the alternatives in descending order of price, and indicate to the customer only the top 3 alternatives. For example, when a customer's budget is Rs 110, then the following four combinations are feasible: Alternative Combination 1 .Veg – I Regular, feast, without extra cheese 2 .Veg – I, Regular, non-feast, extra cheese 3.Veg – l, Regular, non-feast, without extra cheese 4.NV – I, Regular, non-feast, without extra cheese However the proprietor suggests only combinations 2, 1 and 4 in that order. Design a spreadsheet without a macro in where the user will be able to input a customer’s budget and get as output the list of best three alternative combinations (type of pizza, size, feast or non- feast and with/without extra cheese) that can offered -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: RE: $$Excel-Macros$$ Delayed Days
Hello Nilesh, Another way, K2 copy down. =TEXT(I2,"\/00\/00")-TEXT(J2,"\/00\/00") If you don't want to see -days use =ABS(TEXT(I2,"\/00\/00")-TEXT(J2,"\/00\/00")) Or, convert the Dates to actual date, for doing this, Select the whole column I:I, go to, Data >> Text to Columns >> Next >> Next, then from the top left side, select Data & from the drop down list select YMD, click Finish. Do the same for Column_J. Then you can simply use in K2, =I2-J2 to avoid -days change to =ABS(I2-J2) -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work
Ah that was fast and PERFECT :), i suppose, cell(i,2), the 2 is for column
B, 3 C 4 D and so on(this is a huge implement in my learning), many many
many thanks Ashish, perfect as always :).
2011/7/14 ashish koul
> try this
>
> Sub fill2010real()
> Dim i As Long
> i = 1
> Do Until Cells(i, 2).Value = "Total"
> Cells(i, 1).Value = "2010 Real"
> i = i + 1
> Loop
> End Sub
>
>
> On Thu, Jul 14, 2011 at 5:39 AM, Jorge Marques wrote:
>
>> Hi guys, i have this table where i want to fill the column A with "2010
>> Real" but stopping when in the same row the column B is "Total" i used Do &
>> Loop but i can´t seem to find the right code.
>>
>> sub fill2010real()
>> Do until range("B:B").value = "Total"
>> range("A:A").value = "2010 Real"
>> loop
>> end sub
>>
>> I can´t seem to go around this code :(
>>
>> 1001 thanks to all of you!excel-lent as always :)
>>
>>
>> --
>>
>> --
>> 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.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work
try this
Sub fill2010real()
Dim i As Long
i = 1
Do Until Cells(i, 2).Value = "Total"
Cells(i, 1).Value = "2010 Real"
i = i + 1
Loop
End Sub
On Thu, Jul 14, 2011 at 5:39 AM, Jorge Marques wrote:
> Hi guys, i have this table where i want to fill the column A with "2010
> Real" but stopping when in the same row the column B is "Total" i used Do &
> Loop but i can´t seem to find the right code.
>
> sub fill2010real()
> Do until range("B:B").value = "Total"
> range("A:A").value = "2010 Real"
> loop
> end sub
>
> I can´t seem to go around this code :(
>
> 1001 thanks to all of you!excel-lent as always :)
>
>
> --
>
> --
> 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.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help My "Do Loop" statement doesn´t work
Hi guys, i have this table where i want to fill the column A with "2010
Real" but stopping when in the same row the column B is "Total" i used Do &
Loop but i can´t seem to find the right code.
sub fill2010real()
Do until range("B:B").value = "Total"
range("A:A").value = "2010 Real"
loop
end sub
I can´t seem to go around this code :(
1001 thanks to all of you!excel-lent as always :)
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
2010 Real & false.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ PROJECT DOUBT
ur name range (PDATA) shud start frm col B and not from col A.i.e. from col B to col F or may b more if u like. so the new formula will b =VLOOKUP(K13,PDATA,5,FALSE) formula without name range. =VLOOKUP(I18,$B$2:$F$3,5,FALSE) this will solve the problem > >From: SAJID MEMON >To: Excel Group >Sent: Wed, 13 July, 2011 9:20:28 PM >Subject: $$Excel-Macros$$ PROJECT DOUBT > > >Dear Ashish ji thanks for co-operate me in my privious doubt > >DEARS EXPERTS, > >I have attached my small part of project plz help me for solve it > >VLOOKUP IS RESPONDING #NA > I HAVE USED FOLLOWING TWO FORMULAS > >=VLOOKUP(K13,PDATA,6,FALSE) >AND >=IF(ISNA(VLOOKUP(K13,PDATA,6,FALSE),"",VLOOKUP(K13,PDATA,6,FALSE)) > >BUT ITS NOT WORKING IN EXCEL 2003. > >AWAITING YOURS TIPS > >SAJID MEMON > > > -- >-- > >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.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ JOB OPPORTUNITY: McKinsey, Gurgaon #SAS #Excel #VBA
Below mentioned is an opening of life time with one of the most esteemed management consulting firm. If currently you are aiming for a job change please do read the below e-mail very carefully. *About The Client: -* McKinsey is a preeminent management consulting firm that helps leading companies and institutions make distinctive, lasting and substantial improvements to their performance. With over 6,000 consultants working in 83 offices in 45 countries, they advise organizations worldwide on issues of strategy, organization, operations and technology. Its for the World's No. 1 Management Consulting Company. *About The Opening: -* Position -- Research Analyst Location -- Gurgaon Salary -- Negotiable, depends upon your current package. Minimum Experience -- 1 Year *Job Role:* 1. Perform modeling in client engagements (such as the development of consumer demand model. 2. Provide expert advice to consulting teams on technique/modeling related issues. 3. Support development and maintenance of proprietary market analysis techniques and other knowledge development projects. 4. Highly proficient in standard modeling techniques like time series analysis, regressions (linear, logistic), forecasting, cluster analysis, etc 5. Additionally he / she should have a sound exposure in any one of the advanced techniques like discriminant analysis, CHAID, tobit, probit models, simultaneous regression models, probability modeling (added plus), etc. 6. Highly proficient in core analytical tools - SAS (preferred), SPSS (a plus) 7. Existing advanced ability in Excel and Access or the capability and willingness to develop this (Current average ability level in Excel and Access is a pre-requisite) If the above JOB ROLE interests you then please *send your resume* to the undersigned (*ashishjain @OpenExcel.com*) with the following details. 1. Current Salary 2. Expected Salary 3. Joining Time 4. Current Location For any further query please get in touch with the under signed. Thanks & Regards Ashish Jain Research Analyst, McKinsey & Co. +91--40-48-43 *ashishjain @OpenExcel.com* Note: To continue receiving relevant job notifications (Excel/Access/VBA/SAS/SQL) of premier companies, register yourself here -->* http://jobs.excelitems.com* -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Books
*Hey, Please find the below mention link for Microsoft Excel 2077 VBA Macro Programming 2009* http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm * Regards, Vikas Chauhan* On Wed, Jul 13, 2011 at 3:46 PM, jmothilal wrote: > if any one have pdf file pls send me > > J.Mothilal > > > On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> I need book for learning chart itself. If anything is there pls send it to >> me. >> >> Thanks, >> >> Chandra Shekar B >> >> On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma wrote: >> >>> *Here are some good books name which are free on internet ..* >>> >>> * * >>> >>> *VBA and Macros Microsoft Excel 2010 (MrExcel Library)* >>> >>> *VBA Beginner How To Computer Programming Concepts and Visual Basic* >>> >>> *Excel_2007_VBA_Programming_for_Dummies* >>> >>> *Excel Programming WIth VBA and .Net* >>> >>> *Excel Programming Absalute Bigginers* >>> >>> *Excel Power Programming 2003 With VBA* >>> >>> *Excel 2007 Power Programming With VBA* >>> >>> * * >>> >>> * * >>> >>> * * >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >>> *Sent:* Wednesday, July 13, 2011 12:10 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ Books >>> >>> ** ** >>> >>> Hi, >>> >>> >>> >>> Can anyone suggest which book will be the best ot learn Charts (Like >>> Bullet Chart and Doughnut chart with Indication). If anyone have ebook >>> please post it. Thanks!. >>> >>> >>> >>> Regards, >>> >>> >>> >>> Chandra Shekar B >>> >>> -- >>> >>> -- >>> 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.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >>> -- >>> >>> -- >>> 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.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> -- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.
$$Excel-Macros$$ Re: HELP urgent
If you are using Excel 2007, then you can do part of this without VBA. If you want to change color of cell, for example, when the cell value is negative, you can accomplish this by going to Home > Conditional Formatting and then creating a rule by which the cell changes. This is probably easier than fiddling with VBA to accomplish the same thing. To tackle your year question, I would probably figure out how to write a subroutine that would be activated upon a change in the worksheet. Whenever you make a change, this subrouting would be triggered to run. I would then run a loop using the range.offset property such that the loop counter is used to run down the rows and perform an algorithm on each row to check the value and copy your year. -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ connection between flash and excel vba
hi, can you refer me the best web site for flash(actionscript) and excel (vba) connection. Thanks senthilkumar -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ HELP urgent
You Can use conditinoal formatting On Wed, Jul 13, 2011 at 4:05 PM, Jorge Marques wrote: > Hi friend, i don´t understand exactly what you want, but if you want to > highlight the entire row that has the negative numbers like this, or do you > want it to copy to another column the year and negative value? > > Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 > 2009 20 2011 29.66 2008 -11 1989 17.01 2005 15.02 2001 -20 1990 21.06 2008 > 17.01 > Is this what you what? > > I´m new at this, but i made this code, maybe not very programming accurate, > but the best i did :S > > "Sub Colorize() > ActiveSheet.Cells.Interior.ColorIndex = xlNone > For Each Cell In ActiveSheet.UsedRange > If Cell.Value < 0 Then > Cell.Offset(0, -1).Interior.ColorIndex = 38 > End If > Next > For Each Cell In ActiveSheet.UsedRange > If Cell.Value < 0 Then > Cell.Offset(0, 0).Interior.ColorIndex = 38 > End If > Next > End Sub" > > 2011/7/13 Rajan_Verma > >> *Please attach a sample file with more explaination..* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Puneet Jain >> *Sent:* Wednesday, July 13, 2011 12:45 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ HELP urgent >> >> ** ** >> >> >> >> Guys >> >> >> >> Need Help. >> >> >> >> In the series of cash flows, if at anytime the negative falue appears. a >> cell should indicate that negative value along-with the corresponding year >> in which that negative value appears. >> >> >> >> *Cash Available* >> >> >> >> 0.00 >> >> 6.71 >> >> 23.75 >> >> 21.06 >> >> 17.01 >> >> 20.00 >> >> 29.66 >> >> 21.06 >> >> 17.01 >> >> 15.02 >> >> 24.67 >> >> 21.06 >> >> 17.01 >> >> >> Regards >> >> >> >> Puneet >> >> 9899068873 >> >> -- >> >> -- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> -- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Rakesh Joshi -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ PROJECT DOUBT
Hi Sajid, First of all, your sheet is protected, I couldnt save it as.. and 2nd you are using wrong formulas.. specially which naming the range. In the form sheet you are trying to do vlookup on a blank source.. in the last sheet you are using a wrong name range for Vlookup.. We need an unprotected workbook in order to help you. On Wed, Jul 13, 2011 at 9:20 PM, SAJID MEMON wrote: > Dear Ashish ji thanks for co-operate me in my privious doubt > > DEARS EXPERTS, > > I have attached my small part of project plz help me for solve it > > VLOOKUP IS RESPONDING #NA > I HAVE USED FOLLOWING TWO FORMULAS > > =VLOOKUP(K13,PDATA,6,FALSE) > AND > =IF(ISNA(VLOOKUP(K13,PDATA,6,FALSE),"",VLOOKUP(K13,PDATA,6,FALSE)) > > BUT ITS NOT WORKING IN EXCEL 2003. > > AWAITING YOURS TIPS > > SAJID MEMON > > > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ HELP urgent
Try This
Sub GiveColor()
Dim rng As Range
Dim cell As Range
Set rng = Range("B2:B" & ActiveSheet.UsedRange.Rows.Count)
For Each cell In rng
If cell.Value < 0 Then
cell.Offset(0, -1).Resize(1, 2).Interior.ColorIndex = 38
End If
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Wednesday, July 13, 2011 4:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ HELP urgent
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire row that has the negative numbers like this, or do you
want it to copy to another column the year and negative value?
Year
Cash Available
2002
0
1983
6.71
1995
23.75
1994
21.06
2007
-11
2009
20
2011
29.66
2008
-11
1989
17.01
2005
15.02
2001
-20
1990
21.06
2008
17.01
Is this what you what?
I´m new at this, but i made this code, maybe not very programming accurate,
but the best i did :S
"Sub Colorize()
ActiveSheet.Cells.Interior.ColorIndex = xlNone
For Each Cell In ActiveSheet.UsedRange
If Cell.Value < 0 Then
Cell.Offset(0, -1).Interior.ColorIndex = 38
End If
Next
For Each Cell In ActiveSheet.UsedRange
If Cell.Value < 0 Then
Cell.Offset(0, 0).Interior.ColorIndex = 38
End If
Next
End Sub"
2011/7/13 Rajan_Verma
Please attach a sample file with more explaination..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Puneet Jain
Sent: Wednesday, July 13, 2011 12:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HELP urgent
Guys
Need Help.
In the series of cash flows, if at anytime the negative falue appears. a
cell should indicate that negative value along-with the corresponding year
in which that negative value appears.
Cash Available
0.00
6.71
23.75
21.06
17.01
20.00
29.66
21.06
17.01
15.02
24.67
21.06
17.01
Regards
Puneet
9899068873
--
--
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.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
Re: $$Excel-Macros$$ Binary Combinations Using VBA
Hi Rajan,
For some odd reason, putting in the parentheses does not affect the
outcome - runtime error continues to show up !
Appreciate any help you can give.
Thanks,
FG
On Jul 13, 3:42 am, "Rajan_Verma" wrote:
> Try this.
>
> Range("A" & Range("A65536").End(xlUp).Row +
> 1).Resize(ActiveSheet.UsedRange.Rows.Count,ActiveSheet.Columns.Count).ClearC
> ontents
> C = ActiveSheet.UsedRange.Columns.Count
> R = ActiveSheet.UsedRange.Rows.Count
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Financeguy
> Sent: Wednesday, July 13, 2011 2:09 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
>
> Hi,
>
> This works really well, except it shows an error at:
>
> Range("A" & Range("A65536").End(xlUp).Row +
> 1).Resize(ActiveSheet.UsedRange.Rows.Count,
> ActiveSheet.Columns.Count).ClearContents
> C = ActiveSheet.UsedRange.Columns.Count
> R = ActiveSheet.UsedRange.Rows.Count
>
> Is is because im using MS Excel 2003? or can it be easily fixed.
>
> Thanks again,
>
> Financeguy
>
> On Jul 11, 3:40 am, "Rajan_Verma" wrote:
> > Hi Try This
>
> > Sub MakeCobmination()
>
> > Application.ScreenUpdating = False
> > Dim t As Double
> > Dim Digit As Double
> > Dim SS As Double
> > Dim j As Double
> > Combination = InputBox("Enter Digit ")
> > SS = 2 ^ Combination
>
> > If Val(Combination) > 20 Then
> > MsgBox "you Can give till 20 ", vbInformation
> > Exit Sub
> > End If
> > t = 1
> > n = 1
> > lp = 1
> > j = 1
> > Cells.ClearContents
> > For lp = 1 To Combination
> > For n = 1 To SS / lp * 2
> > For i = 1 To lp
> > Cells(j, lp).Value = 0
> > j = j + 1
> > Next
>
> > For i = 1 To lp
> > Cells(j, lp).Value = 1
> > j = j + 1
> > Next
>
> > Cells(j, lp).Select
> > If ActiveCell.Row >= SS + 1 Then Exit For
> > Next
> > j = 1
> > Next
> > Range("A" & Range("A65536").End(xlUp).Row +
> > 1).Resize(ActiveSheet.UsedRange.Rows.Count,
> > ActiveSheet.Columns.Count).ClearContents
> > C = ActiveSheet.UsedRange.Columns.Count
> > R = ActiveSheet.UsedRange.Rows.Count
>
> > For H = 1 To R
> > For M = 1 To C
> > st = st & Cells(H, M).Value
> > Next
> > Cells(H, C + 1).Value = "'" & st
> > st = ""
> > Next
> > Range("A1").Resize(ActiveSheet.UsedRange.Rows.Count,
> > ActiveSheet.UsedRange.Columns.Count - 1).Columns.Delete
> > Application.ScreenUpdating = True
> > End Sub
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> > On Behalf Of Financeguy
> > Sent: Monday, July 11, 2011 1:28 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
>
> > Thanks, Rajan - we're getting closer, I can almost see it ..i
> > wanted an output that shows all the combinations of 0 and 1 using 7
> > digits.
>
> > The output looks like:
>
> > 0101010
> > 010
> > 0001000
> > 001
> > 1010101
> > 000
> > 1101100
> > 0110011
> > ..and this list goes on for a total of 2 ^ 7 times = 128
> > different combinations
>
> > Appreciate your help in getting me to my goal !
>
> > best,
> > Financeguy
>
> > On Jul 10, 12:26 pm, "Rajan_Verma" wrote:
> > > Try This
>
> > > Sub MakeCombination()
>
> > > Dim Zero As Integer
>
> > > Dim One As Integer
>
> > > Zero = Range("A1").Value
>
> > > One = Range("B1").Value
>
> > > Dim Combination As Integer
>
> > > Combination = Range("C1").Value
>
> > > Dim st As String
>
> > > For i = Combination To 1 Step -1
>
> > > st = WorksheetFunction.Rept(Zero, Combination)
>
> > > st = WorksheetFunction.Substitute(st, Zero, One, i)
>
> > > Range("H" & Combination - i + 1).Value = "'" & st
>
> > > Next
>
> > > End Sub
>
> > > From: excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com]
> > > On Behalf Of Financeguy
> > > Sent: Sunday, July 10, 2011 9:28 AM
> > > To: excel-macros@googlegroups.com
> > > Subject: $$Excel-Macros$$ Binary Combinations Using VBA
>
> > > Hi All,
>
> > > I'm trying to generate a list of binary combinations as follows:
>
> > > cell A1: 0
>
> > > cell A2: 1
>
> > > cell A3: 7
>
> > > I'm requesting help to create the following output in separate columns
> > using
> > > VBA:
>
> > > 0 0 0 0 0 0 1
>
> > > 0 0 0 0 0 1 0
>
> > > 0 0 0 0 1 0 0
>
> > > and so on.. for a total of 2 ^ 7 times in columns A through G
>
> > > Any hel
Re: $$Excel-Macros$$ Problem with counters
PLease post a sample file with clear requirement. On Wed, Jul 13, 2011 at 1:44 PM, Juan Antonio Castillo Guerrero < castill...@gmail.com> wrote: > Hello group! > > I'm doing an Excel spreadsheet in which I posed the following problem, I > put a sample of what I have and a sample of what you need to get. > > Sheet1 > A1: Subject > Format: Text > A2: Document Code > format: > AAA-BBB-99 999-L-1 > AAA-BBB-99 999-F-1 > AAA-BBB-99 999-T-1 > AAA-BBB-99 999-E-1 > AAA-BBB-99 999-M-1 > 99 999-AAA-CCC-L-1 > 99 999-AAA-CCC-F-1 > 99 999-AAA-CCC-T-1 > 99 999-AAA-CCC-E-1 > 99 999-CCC-AAA-M-1 > > 9 Where is the project code (no change) > AAA-BBB-CCC and AAA are the different destinations there are 6 different > L, F, G, E, F are Letters, Fax, Transmitals, E-mails, Moms > > This is how it should be mounted Excel > > Now I put an example of how it should be: > > We started in A2 > > A2: B2 Invoice Mail: 9-AAA-BBB-E-1 > A3: B3 Mail Invoice: 9-AAA-BBB-E-2 > A4: B4 Mail Invoice: 9-AAA-CCC-E-1 > A5: B5 Mail Invoice: 9-AAA-BBB-E-3 > A6: B6 Mail Invoice: 9-AAA-CCC-E-2 > A7: Letter Rejected B7: 9-AAA-BBB-L-1 > > I mean, there we have 3 emails from AAA to BBB the counter is what changes > . We also have 2 emails from AAA to CCC the counter increases. > We also have a letter from AAA to BBB is 1 meter. > > I want to know what counter number for each case would be next. That is, > having somewhere that if cell A8, I included an email from AAA to BBB > would put the 00,004 which is the corresponding. > > I you can lend a hand? If you need more information I will be here. > Greetings and thank you very much! > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ HELP urgent
Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire row that has the negative numbers like this, or do you want it to copy to another column the year and negative value? Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009 20 2011 29.66 2008 -11 1989 17.01 2005 15.02 2001 -20 1990 21.06 2008 17.01 Is this what you what? I´m new at this, but i made this code, maybe not very programming accurate, but the best i did :S "Sub Colorize() ActiveSheet.Cells.Interior.ColorIndex = xlNone For Each Cell In ActiveSheet.UsedRange If Cell.Value < 0 Then Cell.Offset(0, -1).Interior.ColorIndex = 38 End If Next For Each Cell In ActiveSheet.UsedRange If Cell.Value < 0 Then Cell.Offset(0, 0).Interior.ColorIndex = 38 End If Next End Sub" 2011/7/13 Rajan_Verma > *Please attach a sample file with more explaination..* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Puneet Jain > *Sent:* Wednesday, July 13, 2011 12:45 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ HELP urgent > > ** ** > > > > Guys > > > > Need Help. > > > > In the series of cash flows, if at anytime the negative falue appears. a > cell should indicate that negative value along-with the corresponding year > in which that negative value appears. > > > > *Cash Available* > > > > 0.00 > > 6.71 > > 23.75 > > 21.06 > > 17.01 > > 20.00 > > 29.66 > > 21.06 > > 17.01 > > 15.02 > > 24.67 > > 21.06 > > 17.01 > > > Regards > > > > Puneet > > 9899068873 > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Books
if any one have pdf file pls send me J.Mothilal On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > I need book for learning chart itself. If anything is there pls send it to > me. > > Thanks, > > Chandra Shekar B > > On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma wrote: > >> *Here are some good books name which are free on internet ..* >> >> * * >> >> *VBA and Macros Microsoft Excel 2010 (MrExcel Library)* >> >> *VBA Beginner How To Computer Programming Concepts and Visual Basic* >> >> *Excel_2007_VBA_Programming_for_Dummies* >> >> *Excel Programming WIth VBA and .Net* >> >> *Excel Programming Absalute Bigginers* >> >> *Excel Power Programming 2003 With VBA* >> >> *Excel 2007 Power Programming With VBA* >> >> * * >> >> * * >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar >> *Sent:* Wednesday, July 13, 2011 12:10 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Books >> >> ** ** >> >> Hi, >> >> >> >> Can anyone suggest which book will be the best ot learn Charts (Like >> Bullet Chart and Doughnut chart with Indication). If anyone have ebook >> please post it. Thanks!. >> >> >> >> Regards, >> >> >> >> Chandra Shekar B >> >> -- >> >> -- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> -- >> 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.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Books
I need book for learning chart itself. If anything is there pls send it to me. Thanks, Chandra Shekar B On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma wrote: > *Here are some good books name which are free on internet ..* > > * * > > *VBA and Macros Microsoft Excel 2010 (MrExcel Library)* > > *VBA Beginner How To Computer Programming Concepts and Visual Basic* > > *Excel_2007_VBA_Programming_for_Dummies* > > *Excel Programming WIth VBA and .Net* > > *Excel Programming Absalute Bigginers* > > *Excel Power Programming 2003 With VBA* > > *Excel 2007 Power Programming With VBA* > > * * > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar > *Sent:* Wednesday, July 13, 2011 12:10 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Books > > ** ** > > Hi, > > > > Can anyone suggest which book will be the best ot learn Charts (Like Bullet > Chart and Doughnut chart with Indication). If anyone have ebook please post > it. Thanks!. > > > > Regards, > > > > Chandra Shekar B > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > 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.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Problem with counters
Hello group! I'm doing an Excel spreadsheet in which I posed the following problem, I put a sample of what I have and a sample of what you need to get. Sheet1 A1: Subject Format: Text A2: Document Code format: AAA-BBB-99 999-L-1 AAA-BBB-99 999-F-1 AAA-BBB-99 999-T-1 AAA-BBB-99 999-E-1 AAA-BBB-99 999-M-1 99 999-AAA-CCC-L-1 99 999-AAA-CCC-F-1 99 999-AAA-CCC-T-1 99 999-AAA-CCC-E-1 99 999-CCC-AAA-M-1 9 Where is the project code (no change) AAA-BBB-CCC and AAA are the different destinations there are 6 different L, F, G, E, F are Letters, Fax, Transmitals, E-mails, Moms This is how it should be mounted Excel Now I put an example of how it should be: We started in A2 A2: B2 Invoice Mail: 9-AAA-BBB-E-1 A3: B3 Mail Invoice: 9-AAA-BBB-E-2 A4: B4 Mail Invoice: 9-AAA-CCC-E-1 A5: B5 Mail Invoice: 9-AAA-BBB-E-3 A6: B6 Mail Invoice: 9-AAA-CCC-E-2 A7: Letter Rejected B7: 9-AAA-BBB-L-1 I mean, there we have 3 emails from AAA to BBB the counter is what changes. We also have 2 emails from AAA to CCC the counter increases. We also have a letter from AAA to BBB is 1 meter. I want to know what counter number for each case would be next. That is, having somewhere that if cell A8, I included an email from AAA to BBB would put the 00,004 which is the corresponding. I you can lend a hand? If you need more information I will be here. Greetings and thank you very much! -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Delayed Days
Thanks it's works. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Wednesday, July 13, 2011 1:20 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Delayed Days Use this in K2 =-(DATE(LEFT(I2,4),MID(I2,5,2),RIGHT(I2,2))-DATE(LEFT(J2,4),MID(J2,5,2), RIGHT(J2,2))) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Virkar,Nilesh Sent: Wednesday, July 13, 2011 12:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Delayed Days Hi All, I would like to take delayed days from attached file. The formula should like below. Colum I - Colum J = Delayed Days The date format need to be same for further analysis. Thanks in advance for your support. Best Regards Nilesh P please consider the environment before printing this e-mail. Thank you -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Binary Combinations Using VBA
Try this.
Range("A" & Range("A65536").End(xlUp).Row +
1).Resize(ActiveSheet.UsedRange.Rows.Count,ActiveSheet.Columns.Count).ClearC
ontents
C = ActiveSheet.UsedRange.Columns.Count
R = ActiveSheet.UsedRange.Rows.Count
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Financeguy
Sent: Wednesday, July 13, 2011 2:09 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
Hi,
This works really well, except it shows an error at:
Range("A" & Range("A65536").End(xlUp).Row +
1).Resize(ActiveSheet.UsedRange.Rows.Count,
ActiveSheet.Columns.Count).ClearContents
C = ActiveSheet.UsedRange.Columns.Count
R = ActiveSheet.UsedRange.Rows.Count
Is is because im using MS Excel 2003? or can it be easily fixed.
Thanks again,
Financeguy
On Jul 11, 3:40 am, "Rajan_Verma" wrote:
> Hi Try This
>
> Sub MakeCobmination()
>
> Application.ScreenUpdating = False
> Dim t As Double
> Dim Digit As Double
> Dim SS As Double
> Dim j As Double
> Combination = InputBox("Enter Digit ")
> SS = 2 ^ Combination
>
> If Val(Combination) > 20 Then
> MsgBox "you Can give till 20 ", vbInformation
> Exit Sub
> End If
> t = 1
> n = 1
> lp = 1
> j = 1
> Cells.ClearContents
> For lp = 1 To Combination
> For n = 1 To SS / lp * 2
> For i = 1 To lp
> Cells(j, lp).Value = 0
> j = j + 1
> Next
>
> For i = 1 To lp
> Cells(j, lp).Value = 1
> j = j + 1
> Next
>
> Cells(j, lp).Select
> If ActiveCell.Row >= SS + 1 Then Exit For
> Next
> j = 1
> Next
> Range("A" & Range("A65536").End(xlUp).Row +
> 1).Resize(ActiveSheet.UsedRange.Rows.Count,
> ActiveSheet.Columns.Count).ClearContents
> C = ActiveSheet.UsedRange.Columns.Count
> R = ActiveSheet.UsedRange.Rows.Count
>
> For H = 1 To R
> For M = 1 To C
> st = st & Cells(H, M).Value
> Next
> Cells(H, C + 1).Value = "'" & st
> st = ""
> Next
> Range("A1").Resize(ActiveSheet.UsedRange.Rows.Count,
> ActiveSheet.UsedRange.Columns.Count - 1).Columns.Delete
> Application.ScreenUpdating = True
> End Sub
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Financeguy
> Sent: Monday, July 11, 2011 1:28 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Binary Combinations Using VBA
>
> Thanks, Rajan - we're getting closer, I can almost see it ..i
> wanted an output that shows all the combinations of 0 and 1 using 7
> digits.
>
> The output looks like:
>
> 0101010
> 010
> 0001000
> 001
> 1010101
> 000
> 1101100
> 0110011
> ..and this list goes on for a total of 2 ^ 7 times = 128
> different combinations
>
> Appreciate your help in getting me to my goal !
>
> best,
> Financeguy
>
> On Jul 10, 12:26 pm, "Rajan_Verma" wrote:
> > Try This
>
> > Sub MakeCombination()
>
> > Dim Zero As Integer
>
> > Dim One As Integer
>
> > Zero = Range("A1").Value
>
> > One = Range("B1").Value
>
> > Dim Combination As Integer
>
> > Combination = Range("C1").Value
>
> > Dim st As String
>
> > For i = Combination To 1 Step -1
>
> > st = WorksheetFunction.Rept(Zero, Combination)
>
> > st = WorksheetFunction.Substitute(st, Zero, One, i)
>
> > Range("H" & Combination - i + 1).Value = "'" & st
>
> > Next
>
> > End Sub
>
> > From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
> > On Behalf Of Financeguy
> > Sent: Sunday, July 10, 2011 9:28 AM
> > To: excel-macros@googlegroups.com
> > Subject: $$Excel-Macros$$ Binary Combinations Using VBA
>
> > Hi All,
>
> > I'm trying to generate a list of binary combinations as follows:
>
> > cell A1: 0
>
> > cell A2: 1
>
> > cell A3: 7
>
> > I'm requesting help to create the following output in separate columns
> using
> > VBA:
>
> > 0 0 0 0 0 0 1
>
> > 0 0 0 0 0 1 0
>
> > 0 0 0 0 1 0 0
>
> > and so on.. for a total of 2 ^ 7 times in columns A through G
>
> > Any help is much appreciated.
>
> > Thanks in advance,
>
> > Finance guy
>
> > --
>
>
---
> -
> > --
> > 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.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quick
RE: $$Excel-Macros$$ Delayed Days
Use this in K2 =-(DATE(LEFT(I2,4),MID(I2,5,2),RIGHT(I2,2))-DATE(LEFT(J2,4),MID(J2,5,2),RIGH T(J2,2))) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Virkar,Nilesh Sent: Wednesday, July 13, 2011 12:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Delayed Days Hi All, I would like to take delayed days from attached file. The formula should like below. Colum I - Colum J = Delayed Days The date format need to be same for further analysis. Thanks in advance for your support. Best Regards Nilesh P please consider the environment before printing this e-mail. Thank you -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Numbering
Hey ankur,
I want to ask something
Sub test()
Sheet1.Range("A2:A15").Clear
Dim i, j As Long
Range("a1").Value = InputBox("put your value")
For i = 1 To Sheets(1).Cells(1, 1).Value
Cells(i + 1, 1).Value = i
Next i
End Sub
In this code what is "i" & "j" ?
*
Kαяαη*
On Mon, Jul 11, 2011 at 1:37 PM, ankur wrote:
> *hi kalyan
> as per ur requirementfind the solution...tell me if it helps u ..
>
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 11, 2011 at 9:49 AM, santosh bahuguna <
> santoshbahug...@gmail.com> wrote:
>
>>
>> Please find the attached file and let me know if is this you are looking
>> for
>>
>>
>> Regards
>> Santosh Bahuguna
>>
>> On Sat, Jul 9, 2011 at 1:42 PM, karunanithi ramaswamy
>> wrote:
>>
>>> Mr Santhosh,
>>> your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
>>> i.e., REQUIRED NUMBERING FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
>>> AM I RIGHT?
>>> R.KARUNANITHI
>>>
>>> --- On *Sat, 7/9/11, santosh bahuguna *wrote:
>>>
>>>
>>> From: santosh bahuguna
>>>
>>> Subject: Re: $$Excel-Macros$$ Numbering
>>> To: excel-macros@googlegroups.com
>>> Date: Saturday, July 9, 2011, 3:59 AM
>>>
>>>
>>> Use Simple formula
>>>
>>> =COUNTIF(A$1:A1,A1)
>>>
>>>
>>> Please let me know if you looking for this only
>>>
>>>
>>> Regards
>>> Santosh Bahuguna
>>>
>>>
>>>
>>> On Fri, Jul 8, 2011 at 8:33 AM, Rajan_Verma
>>> http://mc/compose?to=rajanverma1...@gmail.com>
>>> > wrote:
>>>
>>> *Hi
>>> Try this*
>>>
>>> * *
>>>
>>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>>
>>> *On Error GoTo Err:*
>>>
>>> *If Target = Range("A1") Then*
>>>
>>> *For i = 1 To Range("A1").Value*
>>>
>>> *Range("A" & i + 1).Value = i*
>>>
>>> *Next*
>>>
>>> *End If*
>>>
>>> *Err:*
>>>
>>> *End Sub*
>>>
>>> * *
>>>
>>> *From:*
>>> excel-macros@googlegroups.com[mailto:
>>> excel-macros@googlegroups.com]
>>> *On Behalf Of *NOORAIN ANSARI
>>> *Sent:* Friday, July 08, 2011 5:38 PM
>>> *To:*
>>> excel-macros@googlegroups.com
>>> *Cc:* Kal xcel
>>> *Subject:* Re: $$Excel-Macros$$ Numbering
>>>
>>> ** **
>>>
>>> kalyan babu.
>>>
>>> Please try it..also
>>>
>>>
>>>
>>> =IF(A2="","",COUNTA($A$2:A2))
>>>
>>> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel
>>> http://mc/compose?to=kalx...@gmail.com>>
>>> wrote:
>>>
>>> Dear Experts,
>>>
>>>
>>>
>>> I want the formula for below mention query...
>>>
>>>
>>>
>>> user will put 100 in A1, from A2 autometically numbering will start like
>>> this
>>>
>>>
>>>
>>> A21
>>>
>>> A32
>>>
>>> A43
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>> .
>>>
>>>
>>>
>>> till 100
>>>
>>>
>>>
>>> What will be the formula??
>>>
>>>
>>>
>>> Please help
>>>
>>>
>>>
>>> Thanks in advance
>>>
>>>
>>>
>>> Kalyan Chatterjee
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to
>>> excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Thanks & regards,
>>>
>>> Noorain Ansari
>>>
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>
RE: $$Excel-Macros$$ HELP urgent
Please attach a sample file with more explaination.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Puneet Jain Sent: Wednesday, July 13, 2011 12:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP urgent Guys Need Help. In the series of cash flows, if at anytime the negative falue appears. a cell should indicate that negative value along-with the corresponding year in which that negative value appears. Cash Available 0.00 6.71 23.75 21.06 17.01 20.00 29.66 21.06 17.01 15.02 24.67 21.06 17.01 Regards Puneet 9899068873 -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Delayed Days
Hi All, I would like to take delayed days from attached file. The formula should like below. Colum I - Colum J = Delayed Days The date format need to be same for further analysis. Thanks in advance for your support. Best Regards Nilesh P please consider the environment before printing this e-mail. Thank you -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Test.xlsx Description: Test.xlsx
RE: $$Excel-Macros$$ Regarding Excel formulas and addins
See the Mention Links http://www.office-excel.com/ http://www.ozgrid.com/VBA/excel-add-in-create.htm From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi Sent: Wednesday, July 13, 2011 10:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Regarding Excel formulas and addins Dear Members I want to know about the new advanced excel formulas and addins. Please send me some useful links or files by which i can know about that by downloading all that.Specially if those links also having finance related funcion or addins that will great for me also. Thanking you Regards LKModi -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Books
Here are some good books name which are free on internet .. VBA and Macros Microsoft Excel 2010 (MrExcel Library) VBA Beginner How To Computer Programming Concepts and Visual Basic Excel_2007_VBA_Programming_for_Dummies Excel Programming WIth VBA and .Net Excel Programming Absalute Bigginers Excel Power Programming 2003 With VBA Excel 2007 Power Programming With VBA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Wednesday, July 13, 2011 12:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Books Hi, Can anyone suggest which book will be the best ot learn Charts (Like Bullet Chart and Doughnut chart with Indication). If anyone have ebook please post it. Thanks!. Regards, Chandra Shekar B -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
