Did this helped?
On Jul 29, 2014 4:02 PM, Vaibhav Joshi v...@vabs.in wrote:
Ok, Simple!
You can use 3D formual to sum all 35 sheets particular cell in to yours
All data sheet. Need to ensure that there are all one after another.Check
cell b4 of all data sheet.
for leave formula check Emp5
Change macro security mode to medium. Don't enable macro else file will get
close automatically.
On Jul 30, 2014 11:49 AM, Rohit Jadhav rohitj...@gmail.com wrote:
Hi Vibhav,
The password password is not working. When I enter it first time, I get
a window asking for write password. Whether you
Try this:
http://email.about.com/od/gmailtips/qt/How-to-Get-Certain-Email-Statistics-in-Gmail.htm
http://gmailblog.blogspot.in/2012/04/know-your-gmail-stats-using-gmail-meter.html?m=1
Cheers
On Jul 30, 2014 2:15 PM, Nagendra Joshi nitin620@gmail.com wrote:
Dear Team,
Please help me on
by colour ,
Regards
On Friday, July 25, 2014, Vaibhav Joshi v...@vabs.in wrote:
Don't you think there will be too much of pop ups, instead how about
highlighting it with color?
Cheers!!
On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta jocky6...@gmail.com
wrote:
Hi team,
I need some help
What you mean by used range?? You mean upto only last row of column A or
the last column of sheet??
On Tue, Jul 29, 2014 at 3:55 PM, Nur Hossain nur2...@gmail.com wrote:
Dear all , Below code inside macro is working fine for my case
Sheets(input).Columns(A:A).Copy Sheets(output).Range(A1)
lr = Sheets(input).Range(A Rows.Count).End(xlUp).Row
Sheets(input).Range(A1:A lr).Copy Sheets(output).Range(A1)
Cheers
On Tue, Jul 29, 2014 at 4:11 PM, Nur Hossain nur2...@gmail.com wrote:
Joshi da , only last row of column A
On Tue, Jul 29, 2014 at 4:35 PM, Vaibhav Joshi v...@vabs.in
cheers!!
On Tue, Jul 29, 2014 at 4:18 PM, Nur Hossain nur2...@gmail.com wrote:
Joshi da , yes it works nice , thanks for your time..
On Tue, Jul 29, 2014 at 4:43 PM, Vaibhav Joshi v...@vabs.in wrote:
lr = Sheets(input).Range(A Rows.Count).End(xlUp).Row
Sheets(input).Range(A1:A lr
...@gmail.com wrote:
Dear Joshi da, it works perfectly thanks for your different idea
except IF formula..
On Sat, Jul 26, 2014 at 1:51 PM, Vaibhav Joshi v...@vabs.in wrote:
you can also use:
=VLOOKUP(A1,{red,us2;sta,ru2;ida,cu2;pco,us3;pid,ru3;pde,cu3},2,0)
Cheers!!
On Sat, Jul
hi
password is password, but before enabling macro delete all content of sheet
1
Cheers!!
On Mon, Jul 28, 2014 at 1:41 PM, Rohit Jadhav rohitj...@gmail.com wrote:
Hi Vaibhav
I want to see the code can you please provide the password for
the file.
On Thursday, July 24, 2014
at 10:54 AM, Vaibhav Joshi v...@vabs.in wrote:
did this helped?
On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Pl refer attachment, due to your data formula became complex, you can
check example next to it for an explanation.
Cheers!!
On Fri, Jul 25, 2014 at 3:45
password is password
On Mon, Jul 28, 2014 at 6:41 PM, SUDHIR VERMA newinex...@gmail.com wrote:
what is password for attached file
On 24 July 2014 20:21, Vaibhav Joshi v...@vabs.in wrote:
Hi
Check this file.
In sheet 1 Cell A1 put begining date, in cell B1 put date put formula
=A1+10
you can also use:
=VLOOKUP(A1,{red,us2;sta,ru2;ida,cu2;pco,us3;pid,ru3;pde,cu3},2,0)
Cheers!!
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote:
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1=red,us2,)
Don't you think there will be too much of pop ups, instead how about
highlighting it with color?
Cheers!!
On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta jocky6...@gmail.com wrote:
Hi team,
I need some help in creating macro for an excel sheet. I have worksheet in
which 18 nos of in and out
On Friday, July 25, 2014, Vaibhav Joshi v...@vabs.in wrote:
Don't you think there will be too much of pop ups, instead how about
highlighting it with color?
Cheers!!
On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta jocky6...@gmail.com
wrote:
Hi team,
I need some help in creating macro
Hi
Welcome to the group..
Cheers!!
On Fri, Jul 25, 2014 at 5:09 PM, Renu Khandelwal renu.191282...@gmail.com
wrote:
Hi Excel Group
My name is Renu and I am looking job in MIS profile. I love to learn
Excel, VBA, MS-Access, I want to increase my knowledge through with group
discussion.
did this helped?
On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Pl refer attachment, due to your data formula became complex, you can
check example next to it for an explanation.
Cheers!!
On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash bhanu...@gmail.com wrote
Hi
Check this file.
In sheet 1 Cell A1 put begining date, in cell B1 put date put formula
=A1+10 so that on the tenth date after date mentioned in cell A1 macro will
work.
You need to hide row 1 also hide sheet1 set property very hidden. after
that lock macro.
When file is opened macro will
Pl refer:
office.microsoft.com/en-us/excel-help/features-that-are-unavailable-in-shared-workbooks-HP005201080.aspx
Cheers!!
On Wed, Jul 23, 2014 at 2:38 PM, Suman ksuman1...@gmail.com wrote:
Hi,
I have created a macro on *Change event* to protect a particular column
(Column A) when the
for solution, then i connected to Mr
Vaibhav Joshi in conference
means Mr Vaibhav Joshi spoke me my customer at a time
my customer no 9898989696 called for solution, then i connected to Mr
Vinod in conference
means Mr Vinod spoke me my customer at a time
you made input box
for manual entry
i i
Hi
whats logic behind picking up of last 2 lines in result sheet??
On Tue, Jul 22, 2014 at 2:29 PM, City Motors citymotors2...@gmail.com
wrote:
Bhai,
i attached sample data with result in sheet2
On 22 July 2014 13:33, Vaibhav Joshi v...@vabs.in wrote:
ok send me sample data
or link it will open a box window and ask me
for where i want to attach file.
Is it possible with the help of VBA. Please help.
Thanks Regards
Ashu Kenith
On 7/21/14, Vaibhav Joshi v...@vabs.in wrote:
Pl refer this, done minor changes!
Cheers!!
On Mon, Jul 21, 2014 at 8:22 PM, Ashish
-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi
*Sent:* Monday, July 21, 2014 10:08 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need some help with creating a macro
hey
Yes we can do wat you want, can you share sample sheet..
Cheers!!
On Mon, Jul
Cheers Ashish Kumar ji!!
On Mon, Jul 21, 2014 at 10:21 AM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Vaibhav,
Its Great buddy.
Regards
Ashish
On 19 July 2014 22:02, Vaibhav Joshi v...@vabs.in wrote:
Check this..
Cheers!!
On Sat, Jul 19, 2014 at 2:32 PM, Vijay vijaymailsi
Hey
check this sheet, click blue button to run macro..
When prompted enter what identifies your boss, by default i have taken your
example given so just enter to continue..
On copying data you will get Msg done..
Awaiting your feedback..
Cheers!!
On Mon, Jul 21, 2014 at 12:54 PM,
Hi
Macro which you gave is not related to what you wanna do!!
what exactly you wanna do when outlook receives email etc...
Cheers!!
On Mon, Jul 21, 2014 at 10:00 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA
MACROS excel-macros@googlegroups.com wrote:
Dear expert,
I have a macro
Private
Check this:
http://stackoverflow.com/questions/11263483/how-do-i-trigger-a-macro-to-run-after-a-new-mail-is-received-in-outlook
Cheers!!
On Mon, Jul 21, 2014 at 1:41 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Macro which you gave is not related to what you wanna do!!
what exactly you wanna
Ok,
can you explain one example too for better inderstanding...
Cheers!!
On Mon, Jul 21, 2014 at 2:02 PM, VETRI S P spvetri...@gmail.com wrote:
On Saturday, July 19, 2014 12:09:23 PM UTC+5:30, Vabz wrote:
can you attach sample sheet to make work simpler..
Cheers!!
Sir,
Sample File
hold that call and connect to
you via conference call and you spoke me and my customer.
means any conference log entry sir,
thanks for replying soon,
From:
Vikas
On 21 July 2014 13:40, Vaibhav Joshi v...@vabs.in wrote:
Hey
check this sheet, click blue button to run macro..
When
what you are trying to achieve?
On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar deepuk...@gmail.com wrote:
Dear Friends,
Please find attached Daily Reporting Formate of Excel in the summary sheet
I am unable to get the vales using indirect function.
Please help me friends.
--
Regards,
Report Jul 2014_07112014
Nitin Report Jul 2014_07042014
Nitin Report Jun 2014_06252014
Thanks.
Regards,
Nitin Balodi
Sent from my Windows Phone
--
From: Vaibhav Joshi v...@vabs.in
Sent: 19-07-2014 21:25
To: excel-macros@googlegroups.com
Subject: Re
on every row from C to N Based on three other cells
in O,P Q.
On Fri, Jul 18, 2014 at 2:30 PM, Vaibhav Joshi v...@vabs.in wrote:
Cheers. .
On Jul 18, 2014 4:50 PM, Ahmed Emam aaa222e...@gmail.com wrote:
Thanks for your support
On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi v...@vabs.in
can you attach sample sheet to make work simpler..
Cheers!!
On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P spvetri...@gmail.com wrote:
Sir,
I have two Excel sheets in which one is Master Data Sheet other one is
Normaldatasheet ( here data of two is same but all the data from Master
data
Hi
you can run macro thru one go by creating macro..
Sub AllMacro()
Call Macro1
Call Macro2
Call Macro3
End Sub
On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote:
Sir,
i created 3 macro
i want run all 3 macro at a time
means macro1,macro2,macro3
macro1
On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi v...@vabs.in wrote:
Check this!!
Cheers!
On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam aaa222e...@gmail.com wrote:
I have an excel sheet and i want some cells to be highlighted by some
colors if other 3 cells filled by text.
please see
Hi
PFA
Cheers!!
On Fri, Jul 18, 2014 at 9:27 AM, renuka chari jva.ch...@gmail.com wrote:
Dear sir,
i was prepared a macro for autofilter the range based on column a1 in
unique values and
paste this range into sheet2 side by side
in this i have succed in the autofilter the range data but
If it doesn't work then you need to change your regional settings of
Windows!!
Goto Control panel, Select Regional Language, in format Tab select
Additional settings,
Select currency tab, goto digital grouping select second option from top
with coma after 3rd digit.
Cheers!!
On Fri, Jul
Cheers!!
On Fri, Jul 18, 2014 at 9:09 PM, renuka chari jva.ch...@gmail.com wrote:
Thanks alot sir
On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote:
Hi
PFA
Cheers!!
On Fri, Jul 18, 2014 at 9:27 AM, renuka chari jva@gmail.com wrote:
Dear sir,
i was prepared a
Ok,
here you go..From First sheet press Blue button to run Macro..
Cheers!!
On Thu, Jul 17, 2014 at 5:01 PM, Prakash Gusain gusainprak...@gmail.com
wrote:
Yes they are static
On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote:
Is header in Raw data static?
On Wed, Jul 16,
in which environment you are using excel file? what is version of excel?
On Thu, Jul 17, 2014 at 5:11 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hello,
I am getting the following/attached error, while saving the attached excel
file.
[image: Inline image 1]
What would have been the
Select one column at a time containing data, then goto Data Text to
column (or just press Alt + D then E).
Select Fixed width press Next 2 time, now select Date existing date
format viz. DMY for Date-Month-Year and press finish.
Cheers!!
On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara
hi do you want output to be shown in excel sheet?
On Wed, Jul 16, 2014 at 2:10 PM, daya p princedaya2...@gmail.com wrote:
Hi Friends,
I need your help to find common kgid no (like aadhar card no) which is
entered in A,B,C,D .up to n th column (up to n no of section)
i tried
chek this for other way outs...
http://investmentefforts.blogspot.in/2013/02/learn-to-use-excel-to-get-real-time.html
http://www.mrexcel.com/tip103.shtml
Cheers!!
On Tue, Jul 15, 2014 at 7:35 PM, Dhaval Shah todhavals...@gmail.com wrote:
Hello friends
is it any easy way to import Dat
check this too...
http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using-google-docs.html
http://www.marketcalls.in/spreadsheet/vba-macro-to-download-bhavcopy.html
On Tue, Jul 15, 2014 at 7:40 PM, Vaibhav Joshi v...@vabs.in wrote:
chek this for other way outs
Chek Rule no. 3.
On Jul 13, 2014 12:04 PM, daya p princedaya2...@gmail.com wrote:
sir,
my request prob not done by group members
is any expert? pls see.
Subject: $$Excel-Macros$$ quick help
To: excel-macros@googlegroups.com
i am new member,
the file contains sales vlook data unlock
Cheers!!
On Thu, Jul 10, 2014 at 12:17 PM, amar takale amartak...@gmail.com wrote:
thanks vabs brother
On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Check this.. cell in green is what you want..
Cheers!!
On Tue, Jul 8, 2014 at 7:14 PM, amar takale
CHeers!!
On Thu, Jul 10, 2014 at 4:03 PM, Hilary Lomotey resp...@gmail.com wrote:
THANKS SO MUCH
On Mon, Jul 7, 2014 at 1:39 PM, Vaibhav Joshi v...@vabs.in wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is
eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup
pl share sheet with example..
Cheers!!
On Wed, Jul 9, 2014 at 12:17 PM, Rajeev rajeevk...@gmail.com wrote:
Dear Group,
We use subtotal for row now I like to following please help if it is
possible: -
1 In one worksheet i am using Column A1 to EL82
2
Of *Vaibhav Joshi
*Sent:* 09 July 2014 12:25
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Subtotal for visible/unhidden column
pl share sheet with example..
Cheers!!
On Wed, Jul 9, 2014 at 12:17 PM, Rajeev rajeevk...@gmail.com wrote:
Dear Group,
We use
Hi
Pl refer :
http://www.excel-easy.com/vba/loop.html
http://www.exceltip.com/using-loops/using-loops-in-vba-in-microsoft-excel.html
http://www.learn.net.au/vba/vba-loops
http://www.ozgrid.com/VBA/loops.htm
http://www.excel-pratique.com/en/vba/loops.php
How do you want output to be presented?
On Jul 9, 2014 8:45 PM, maryann jiangqiyangf...@gmail.com wrote:
Dear Guru,
I would like to calculate the weighted average of rating (weighted by
exposure) till the sum of exposure reaches certain value. please see table
below:
BuyerExposure
Hi
In that case you will get 1st lowest value!
Are you looking for both values ?
Cheers!!
On Tue, Jul 8, 2014 at 9:36 PM, Deb b.debapr...@gmail.com wrote:
Hi Vabz,
Thanks for the quick reply and its wonderful. But i have noticed there is
an issue. Suppose I have 6 cells where first 3
check this..
i have added one more UDF MultiMode in second yellow cell to get multiple
liked value...
Cheers!!
On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
In that case you will get 1st lowest value!
Are you looking for both values ?
Cheers!!
On Tue, Jul 8
Hi Bill,
As per me if you want record time/date change if cell value change then
time should be changed only if new value old value is not same.
PFA. Macro cheks for change in cell value in range A1 to J1, existing val
is capture in cell L1, if new val is not matching to existing val then only
check this..
On Mon, Jul 7, 2014 at 1:56 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi Bill,
As per me if you want record time/date change if cell value change then
time should be changed only if new value old value is not same.
PFA. Macro cheks for change in cell value in range A1 to J1
change cell ref of cell T1 to output sheet..or just type =output!A2
Thanks
On Mon, Jul 7, 2014 at 4:39 PM, Hilary Lomotey resp...@gmail.com wrote:
thanks boss but when i criteria date the it doesnt change
On Fri, Jul 4, 2014 at 9:37 AM, Vaibhav Joshi v...@vabs.in wrote:
[image: Boxbe
Welcome on board..
Cheers!!
On Mon, Jul 7, 2014 at 6:37 PM, Nitin Balodi nitinbal...@live.com wrote:
Hi All,
I am Nitin Balodi, I work as a Associate into Commercial Operations with
an MNC in Noida.
Excel is an important aspect in my reporting automation and analysis.
Feels good to be
Cheers!!
Glad it worked for you..
On Mon, Jul 7, 2014 at 8:07 PM, jun a city.abfk0...@gmail.com wrote:
Dear Vabz,
Apology for the very late response. Thank for the amazing solution and
your hardwork into this. The macro works great, many thanks for making
changes to the macro. I
Great!! Cheers!!
On Mon, Jul 7, 2014 at 9:32 PM, Bill Q ronsmith...@gmail.com wrote:
Perfect. Thanks for all your help Pramod, Ashish Vabz !!
On Sunday, 6 July 2014 13:53:24 UTC-4, Bill Q wrote:
Hi,
I meant return date/time stamp. not look.
Example:
- The date/time
Chek dis...
it has bot macro for normal name for alpha numeric name too...
Cheers!!
On Sat, Jul 5, 2014 at 3:32 PM, renuka chari jva.ch...@gmail.com wrote:
please provide/
On Thursday, 3 July 2014 00:03:44 UTC+5:30, renuka chari wrote:
*dear group,*
*please provide the vba macro
Cheers!!!
On Jul 5, 2014 11:40 PM, renuka chari jva.ch...@gmail.com wrote:
www,,
thanks vab sir,,,
thanks alot,
On Saturday, 5 July 2014 16:37:05 UTC+5:30, Vabz wrote:
Chek dis...
it has bot macro for normal name for alpha numeric name too...
hi
did this helped?
Cheers!!
On Wed, Jul 2, 2014 at 2:53 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Check Att, In sheet1 i hav assigned Macro to button, click to run.
Cheers!!
On Wed, Jul 2, 2014 at 4:59 AM, Missy786 misbah.ali...@gmail.com wrote:
Could someone please provide some
you!
Regards
Amar
On Wed, Jul 2, 2014 at 12:57 AM, Vaibhav Joshi v...@vabs.in wrote:
Hey
Check att
hope it is as per your need..
Cheers!!
On Tue, Jul 1, 2014 at 4:21 PM, amar takale amartak...@gmail.com
wrote:
Dear Vabs
I would appreciate very much if you can help
Hi
What exactly you mean by formatting, share sample file.
Cheers!!
On Wed, Jul 2, 2014 at 5:36 PM, Hukam Chand hukamchand0...@gmail.com
wrote:
Can anybody help to me to the same as mentioned in subject line
I am done with it but not able to do proper formatting.
Thanks in advance..!!
Hi
what exactly you want to do?
Cheers!!
On Wed, Jul 2, 2014 at 9:37 PM, Hilary Lomotey resp...@gmail.com wrote:
Hello Experts,
Hope i i find you well. i am trying to extract unique Data from the
information in the output data in the file attached after i have extracted
data based on
try this..
Sub Issuer()
Range(B5:B100).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range(V5), Unique:=True
End Sub
Cheers!!
On Wed, Jul 2, 2014 at 10:56 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
what exactly you want to do?
Cheers!!
On Wed, Jul 2, 2014 at 9:37 PM, Hilary Lomotey
Hi
PFA
Pl let the code be in separate module not in sheet module.
I had mapped last row on Col A due to which you might not be getting result
on all Rows..
Cheers!!
On Mon, Jun 30, 2014 at 8:32 PM, jun a city.abfk0...@gmail.com wrote:
Dear Vabz,
Apology for the late response, as i was
Use formula iferror...
Syntex is iferror(yourformula,0)
Cheers!!
On Tue, Jul 1, 2014 at 12:46 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sir / Madam,
Please see the attachment. I am facing a problem which i highlighted in
the excel sheets with yellow color.
Is there
On 6/29/14, Vaibhav Joshi v...@vabs.in wrote:
Hi
Is this format is fixed or subject to change?
If format is fixed then is if by chance you get more than 3 receipts
than
what?
What you want Macro to do? Where you want calculated Interest amount to
be
shown in sheet?
Cheers
It should not be so.. let me re-test it.
On Tue, Jul 1, 2014 at 4:30 PM, jun a city.abfk0...@gmail.com wrote:
Hi Vabz,
Thank you very much for your great help.
The logic works great, but I am sorry to keep burdening you again but I am
unable to get the macro to work on dataset of 100,000
.
Thanks.
On Jul 1, 2014 5:51 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
PFA
I have developed macro on my understanding, click button to run macro.
When prompted select row in col A for which you want to cal Int.
Cal Int will be added in Current Int. column.
Cheers!!
On Tue, Jul 1, 2014
Hi
Check dis..if you find any prob then share sample data with 5000 + lines, i
test on 6000 lines data got filled in less than 30 sec.
Cheers!!
On Tue, Jul 1, 2014 at 4:31 PM, Vaibhav Joshi v...@vabs.in wrote:
It should not be so.. let me re-test it.
On Tue, Jul 1, 2014 at 4:30 PM, jun
...@gmail.com
wrote:
Hi pramod vaibhav
Thank you for your reply
I am still facing the interest calculation problem
I have mensioned detail explanation in attached file.
Can you please make macros for this calculation
Regards
On Jun 28, 2014 11:27 AM, Vaibhav Joshi v...@vabs.in wrote
those cells or convert cells without macros.
2014-06-28 11:13 GMT+05:30 Vaibhav Joshi v...@vabs.in:
Hi
I have created macro, goto sheet 2, press Alt + F8 and press enter to get
what you want.
Cheers!!
On Fri, Jun 27, 2014 at 3:42 PM, Vijayendra Rao vijayendrar...@gmail.com
wrote:
Dear
Did this got resolved at your end or do you need help on this?
On Mon, Jun 23, 2014 at 11:01 PM, Sean M smc...@gmail.com wrote:
Hey Everyone,
I'm having a hard time finding a solution to this issue and I'm hoping
someone
with more Excel/VBA knowledge than my novice self can offer some
Did this got resolved at your end or do you need help on this?
On Tue, Jun 24, 2014 at 10:39 PM, yogananda muthaiah
yogananda.mutha...@gmail.com wrote:
Hello Champs,
Attached Excel in Sheet1 contains sample table view in A , B , C D
Column. Would need your help in getting output generated
Did this got resolved at your end or do you need help on this?
On Wed, Jun 25, 2014 at 10:50 AM, Pravin Gunjal isk1...@gmail.com wrote:
Good Morning,
I would like to email the attached data
in body text of email
in a single click
to all customers.
A
separate mail must be sent for
Did this got resolved at your end or do you need help on this?
On Mon, Jun 23, 2014 at 3:36 AM, Jim Bucklin jim.buck...@gmail.com wrote:
Hi, I have been racking my brain on this one and can’t figure out a
solution…
I have a spreadsheet that tracks expenses by category (Staffing, Travel
Did this got resolved at your end or do you need help on this?
On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas kalpesh.shiv...@gmail.com
wrote:
Hi Group
Can anyone help me on this
Currently I am using (IF) formula for doing this calculation with is
very long confusing.
I have four
Hi
Is macro module protected? if you can open WB then its not diff. to
unprotect VBA module.
You can google it around to know how to unprotect it. Pl note rule 3 Don't
post questions regarding breaking or bypassing any security measure.
Cheers!!
On Fri, Jun 20, 2014 at 10:33 AM, Ankur Gupta
even after entering the design mode. Is there any way
i can check the code for macro written? Please advise me better. I have
very less idea about this.
Please help me
On Thu, Jun 19, 2014 at 11:38 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Is macro module protected? if you can open WB
hi
Pl refer tutorial on drill down:
http://www.contextures.com/excel-pivot-table-drilldown.html
Cheers!!
On Fri, Jun 20, 2014 at 3:26 PM, Capt. Jack Sparrow lucky60...@gmail.com
wrote:
Hi Team,
Can you please help me with a code which can copy data for a particular
name (e.g. alliance)
Cheers!!
On Thu, Jun 19, 2014 at 4:03 PM, SG sonal...@gmail.com wrote:
Thankyou so much Vabz
On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote:
Chek this,,,
On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com wrote:
yeah got it...one more thing..in reports, we can't
Hi
chek this.. http://www.contextures.com/xlDataVal02.html
Cheers!!
On Wed, Jun 18, 2014 at 12:17 PM, Rakesh kumar rakesh.apt...@gmail.com
wrote:
Dear Friends,
i want to use data validation in excel.
first validation - Value would not be repeat in list.
and
In second Validation ,
Hi
In cell C2 put * (only asterik) instead of ALL.
Cheers!!
On Wed, Jun 18, 2014 at 6:10 PM, SG sonal...@gmail.com wrote:
Hi Experts,
I'm looking for a solution to summarise the data based on multiple
criterias in drop downs. My data has 3 dropdowns.I have tried it using
advance filter
when you say ALL, for excel / computer it is * (asterik), remember old
days when DOS were used where command was Dir *.*
Cheers!!
On Wed, Jun 18, 2014 at 6:48 PM, SG sonal...@gmail.com wrote:
Amazing Vabz...thanksss..Can you please explain the idea behind this???
On Wednesday, June 18,
Cheers!!
On Wed, Jun 18, 2014 at 6:58 PM, Rohan Young rohan.j...@gmail.com wrote:
On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi v...@vabs.in wrote:
ActiveSheet.Range(G j).Value = strFile
ITS DONE now, Gr8 dear, excellent
thanks alot bro, very-2 thanks to you :-)
--
Are you =EXP
Hey
You can increase line spacing..
Sub para()
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
If Not (Len(oPara.Range.Text) 1 And Not
oPara.Range.ListFormat.ListType = bulletList) Then
With oPara
.SpaceAfter = 0
Chek this,,,
On Wed, Jun 18, 2014 at 7:08 PM, SG sonal...@gmail.com wrote:
yeah got it...one more thing..in reports, we can't say customer to select
* for All because it's not user friendly. What to do in that case??
On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote:
when you
provide me solution on this
Regards
On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
Hi
Use this file.
Cheers!!
On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote:
HI
Since date format is not the same excel can search directly what you
want,
however
. furthermore you can see in the attachement.
[image: cid:image001.gif@01C80A4D.0DE9E110]
*Delin.F*
On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
You can change display format by going to cell property select custom
and type dd.mm.
If by doing so
problem.
Cheers!!
On Tue, Jun 17, 2014 at 4:18 PM, Jocky Beta jocky6...@gmail.com wrote:
Hi every time I received new sheet from my colleague in. That
situation your sheet not working
Regards
On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
I didnt get you what you are trying to say
Hey
How do you want to fetch? Formula or Macro?
On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I want to fetch data from one sheet to another sheet by referring the
data, Attached sheet will explain you what i want exactly.
Request all of you to kindly
A
e.g. cell A8 value will be fetched.
Hope it helps.
Cheers!!
On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote:
Hi vaibhav,
Fist upon thanks for the reply. I will prefer both the way
It would be very helpful If u help me on the same.
Regards
On 6/16/14, Vaibhav
Hi
You need to use count if formula to get what you want..in range you need to
specify both the column where probable value would be.
Refer file in my previous post with yellow colored range.
Cheers!!
On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii koukinom...@gmail.com wrote:
Sorry I'm an
whats issue?
On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar shiv1...@gmail.com wrote:
Dear friends
Can anybody throw some light and help me as to where I am going wrong in
conditional formatting!
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email:
Zolf
can you share final result.
Cheers!!
On Thu, May 15, 2014 at 2:33 PM, Frank Zolf anthonyfoxtr...@gmail.com
wrote:
Nice try, but this inverts the output and there is too much movement. So,
it's not scalable.
Anyone else? Challenge closes 10:00 GMT 20/05/2014.
Optimise processor use
Hi
Check yellow cells..
Cheers!!
On Sun, Jun 15, 2014 at 11:05 AM, Noah Shalii koukinom...@gmail.com wrote:
Hi, thanks for the help.
However, this only seems to work with the set of values I provided as an
example.
i was wondering if there is a way it would work with any set of numbers I
This one is whole mail body as required by you..
On Tue, May 20, 2014 at 5:07 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
PFA..
You can change it to as per your need.
Cheers!!
On Tue, May 20, 2014 at 4:33 PM, khagesh khera khagesh.kh...@gmail.com
wrote:
Dear Expert,
I am working
0 10 11 12
On Wed, Jun 11, 2014 at 2:15 PM, Vaibhav Joshi v...@vabs.in wrote:
hi
can you illustrate an example.. we can help you on that..
Cheers!!
On Wed, Jun 11, 2014 at 2:17 AM, Will Sob will00...@gmail.com wrote:
thanks it did work but it did not build the triplets i specify
at 10:42 PM, Vaibhav Joshi v...@vabs.in wrote:
Check this link.:
http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html
Cheers
On Jun 11, 2014 9:39 PM, Rohan Young rohan.j...@gmail.com wrote:
On Wed, Jun 11, 2014 at 3:11 PM, Rohan
701 - 800 of 910 matches
Mail list logo
