Hi Guys,
Still waiting for some resolution in this group.
Pls help.
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment and send that mail to a particular distor
> list
Hi Guys,
Cant anyone here help me pls. Does no one know OUTLOOK MACROS
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment and send that mail to a particular distor
> li
Dear Experts,
I want help in macro which can attach 4 mail with standard subject line
into one mail as an attachment and send that mail to a particular distor
list. .
For example I receive mail1, mail2, mail3, mail4
then I want all 4 mails to be attaches in on mail (Mail All) as an
attachment an
Here, give this a try.It was a simple matter to have it select the text box
after completing.
The other problem was because basically, there are 16,384 columns in each
row.When you add or delete the row, you're "changing" 16,384 cells.
so, the macro is running 16,384 times!
I added a line in whic
Respected Mr. Paul
your idea of creating text box is really very nice .. But when i started
using this i found two issues
1] When ever i change any cell -- crusor should automatically goes to that
box only & not as normal
as next cell or down ...
2] If i delete any raw or insert any raw then
Thank you very much for explaining in details.
God Bless you & all members of our wonderful groups.
Excel can do so much wonders that we can not have think it before.
On 3 March 2016 at 19:10, Paul Schreiner wrote:
> I can make the changes, but you will still need to rely on others to make
> c
I can make the changes, but you will still need to rely on others to make
changes!
I'll try to explain:
Macros have "scope":That is: Macros (Subroutine or Function) are stored in VBA
"Modules"There are several types of Modules.The most common are "Sheet"
modules, "Standard" modules and "Form" mo
Respected All
Last time some brothers have help to make this file perfect
I want some clarification / suggestion on this file
I have approx more than 1000 entries to do in this file
1]When I start inserting lines & copy past
Easily done, provided you give us some details!
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
First, thanks in advance for any help you can provide.
I am trying to build a macro that will take the information entered in one
sheet and, based on the date, put the information into the appropriate cell
in a different sheet.
For instance, I want information in Worksheet1:B4 stored in
Work
Dear Paul
Really great thanks for help.
Regards
Shrinivas
On Fri, Feb 5, 2016 at 6:08 PM, Paul Schreiner
wrote:
> Change your macro to:
> Sub MyFilter()
> Dim lngStart As Long, lngEnd As Long, thisWB As Workbook
> Dim NewWB As Workbook
>
> Set thisWB = ActiveWorkbook
> '
Change your macro to:Sub MyFilter() Dim lngStart As Long, lngEnd As Long,
thisWB As Workbook
Dim NewWB As Workbook
Set thisWB = ActiveWorkbook
'-
' Create a new workbook
'-
Workbooks.Add
Dear Paul
Thanks for reply.
Cant get it.
Can you please modify it for me and send it back
Thanks in Advance
Regards
Shrinivas
On Thu, Feb 4, 2016 at 6:16 PM, Paul Schreiner
wrote:
> In your macro, you CREATE the new workbook:
>
> Workbooks.Add
> ActiveWorkbook.SaveAs Filename:=thisWB.Pat
In your macro, you CREATE the new workbook:
Workbooks.Add
ActiveWorkbook.SaveAs Filename:=thisWB.Path & "\filter.xls"
But then you immediately CLOSE it!
ActiveWorkbook.Close savechanges:=False
So, then when you filter the data, copy it to the clipboard and select
Sheet1,it's in the CU
Dear All
Please find attached sheet which contain macro.
Basically there is data in sheet Book "Filter Macro".
I need to filter this data on Date basis and filter data need to paste in
new workbook.
Every time filter data then new wokbook will be created.
Now my problem is that its filterd the data
Thanks sir!!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Saleem Ansari
Sent: Thursday, January 14, 2016 4:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help Required
PFA
On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan
>
>
>
multiply it by 1 simply !! Regards,Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor th
PFA
On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan
wrote:
> Dear Experts.
>
>
>
> I want change Date Format
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussex
Dear Experts.
I want change Date Format
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Thanks Pankaj and others.
It works fine. Thanks a lot pankaj. Im going to apply in my base data if
any concern kindly help... Thanks
Regards,
Ganesh N
On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma
wrote:
> Dear Ganesh,
>
> I hope it should be ok.
>
>
> Sub lookup_list()
> Dim wf As Objec
Dear Ganesh,
I hope it should be ok.
Sub lookup_list()
Dim wf As Object: Set wf = Application.WorksheetFunction
Dim list As Range: Set list = Range("A1", Range("A" &
Rows.Count).End(xlUp))
Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long
On Error Resume Next
For
Dear Team,
Thanks, But I not get the correct answer.
I will say again in the column A I have the list of number. In column E I
have some date. I want to check any one in the list (column A) is appearing
in column E single cell. If cell E2 have the any number in Column A then i
need the answer as
check it !
*Pankaj Sharma *
*MIS Analyst*
*Greater Kailash-1, New Delhi*
*Email *
*p ankaj123...@gmail.com *
*Skype** pankaj.sharma_pj*
On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N wrote:
> Dear team,
>
> I want to find the any of the gi
AS.RO
http://www.metabras.com/sigle/21-ani-otel-banner.png
P Think green!. Do you really need to print this email?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ganesh N
Sent: 22 December 2015 13:38
To: excel-macros@googlegroups.com
Subject: $$Excel-M
Dear team,
I want to find the any of the given list of value matches (part) in the
particular cell using formula or macro.
Please find the attached excel.
If the solution in formula that would be great!!
If you have any concern let me know.
Thanks Team,
Regards,
Ganesh N
--
Are you =EXP(E:RT
Dear Friends
pls help to merge one by one rows in one cell
file attached
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pag
Sir,
I have an attached tamplete called advice, I want to make a data sheet each
time I save a work book from the advice. Please help Thanks in advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
See if this works
On Sun, Nov 22, 2015 at 4:55 PM, Izhar wrote:
> can we use vlookup or match,index function over here to sort column A like
> column B, if possible can anyone do it for me, I tried on column E:I but
> failed
> Thanks in advance
> NOTE:
> Priority is the formula if not possible t
can we use vlookup or match,index function over here to sort column A like
column B, if possible can anyone do it for me, I tried on column E:I but
failed
Thanks in advance
NOTE:
Priority is the formula if not possible then you may use macro
--
*Izhar Ul Haq*
Cell# 009203069072597
--
Are y
the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Mandeep Baluja
To: MS EXCEL AND VBA MACROS
Cc: schreiner_p...@att.net; abhishek....@gmail.com
Sent: Friday, November 6, 2015 2:23 AM
Subject: Re: $$Excel-Macros$$ Help with Custom Vlookup
ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> -
>>
>> --
>> *From:* Abhishek Jain >
>> *To:
u can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Abhishek Jain
> *To:* Paul Schreiner
> *Sent:* Thursday, November 5, 2015 7:25 AM
> *Subje
times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Abhishek Jain
To: MS EXCEL AND VBA MACROS
Cc: Paul Schreiner
Sent: Tuesday, November 3, 2015 2:56 AM
Subject: $$Excel-Macros$$ Help with Custom Vlookup
Hi
Hi All,
I intend to use this piece of UDF I found on internet for my requirement -
Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)
Dim r As Range
Dim result As String
result = ""
For Each r In lookuprange
If r = lookupval Then
result = result & " " & r.Offset(0,
Is there any macro for searching a text inside the workbook if I have 100
workbook in a folder, I'm using windows 7 enterprise edition, this facility
was available in XP but I dont know how to search in windows 7, let me
clear I'm talking about inside the workbook not the name of the workbook
Than
Dear Experts ,
I need help with the below code.
This code emails the current active file as an attachment while also
copying a specific range of cells from the sheet. It works fine except that it
removes the user signature.
I want to pick the user signature.
Sub sumit()
Dim outapp
Noticed that the time mentioned for "seconds" part is differentiated by a
decimal while it should be a colon (like it is done for the hours-minutes
part) so as to enable excel to read it as "time". Once you correct that,
you can simply deduct the down time from up time to get the difference and
set
Assuming that your values are stored in column A from cell 1 to 50, you
could use this formula in cell B1 and drag it down -
=RANK(A1,$A$1:$A$50)
HTH
Abhishek
On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote:
> Hi Experts,
>
> I need a formula to assign number value example is given below wh
Dear Experts,
I want total duration time
DATETIME_UP
DATETIME_DOWN
Total Duration Required
9/1/2015 04:06.5
9/1/2015 05:04.1
HRS:MIN:SS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Hi Experts,
I need a formula to assign number value example is given below where i need
is if the value is max then assign 4, below that 3, below that 2, below
that 1
Value 1000 1 100 10
required 43 1 2
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
ces you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: GENIUS
To: MS EXCEL AND VBA MACROS
Cc: schreiner_p...@att.net
Sent: Saturday, August 22, 2015 1:16 AM
Subject: Re: $$Excel-Macros$
mp;TEXT($B4,"mm.dd.")&"!$A$2:$B$55"),2,FALSE),"")
>>
>> You drag THAT across and down.
>>
>> Then, as long as the new sheets are named in the proper format:
>> "transaction_mm.dd.", then the Petty Cash sheet will update
>> appropriately.
>>
>> If
format:
> "transaction_mm.dd.", then the Petty Cash sheet will update
> appropriately.
>
> If you can give me the proper sheet name format, I could make sure the
> formula is corrected.
>
> *Paul*
>
>
> -
>
ys you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Izhar
To: excel-macros@googlegroups.com
Sent: Friday, August 21, 2015 7:14 AM
Subject: $$Excel-Macros$$ help re
in this workbook, I have two worksheets namely PETTY CASH SHEET and
TRANSANCTION, I need a formula through which I may be able to transfer
amount from TRANSANCTION sheet to PETTY CASH SHEET in the date and
respective accounts mentioned in the TRANSANCTION sheet, in this workbook
I've provided only
u can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Izhar >
> *To:* excel-...@googlegroups.com
> *Sent:* Saturday, August 15, 2015 1:36 AM
> *Subject:* $$Excel-Macros$$ HELP REQUIRED
>
> look at the sheet, in this sheet
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Izhar
To: excel-macros@googlegroups.com
Sent: Saturday, August 15, 2015 1:36 AM
Subject: $$Excel-Macros$$ HELP REQUIRED
look at the sheet, in
look at the sheet, in this sheet I want to search the article start with M
with numbers not MN with numbers becoz when I try to search M as picture
has shwon in the sheet, it shows MN with number also but I need only M with
Numbers after filtering I have also highlighted the ARTICLES please help me
Dear Paul,
Thank you for the clarification, it is great help.
I am now able to make it work for various users.
Thanks a ton.
gargeeDate: Tue, 11 Aug 2015 12:41:11 +
From: schreiner_p...@att.net
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with saveas file code
The
-
From: gargee singh
To: "excel-macros@googlegroups.com"
Sent: Sunday, August 9, 2015 8:47 AM
Subject: $$Excel-Macros$$ Help with saveas file code
Dear
Experts, I have this code which opens the saveas dialogue box and prepopulates
thefile name an
Dear Experts,
I have this code which opens the saveas dialogue box and prepopulates the
file name and the extension type which then allows the user to select a folder
to save the file.
I want to be able to save the file in my documents without asking the user
to select a folder , the catc
Hello Sarah, I can help you.
You could better detail what you need?
Regards,
Basole.
2015-07-06 12:33 GMT-03:00 Sarah Cartwright :
>
>
> Hi-
> I am in need of assistance with VBA code development to create a shareable
> template that can automatically generate a graph based on a user-friendly
Hi-
I am in need of assistance with VBA code development to create a shareable
template that can automatically generate a graph based on a user-friendly
front end interface. This is a paid job- if anyone can provide assistance,
please let me know.
Thanks
Sarah Cartwright
--
Are you =EXP
Dear Mandeep,
Please Help.
Regards,
Kumar Bhanushali
DISCLAIMER
The information contained in this e-mail including attachment is meant
only for the addressee and may contain confidential and privileged
information. Any use, distribution, printing, retransmission,
dissemination, copying or d
Hi
I'm not able to access any help from Excel 2007. I have attached the error
snap shot here. I tried reinstalling Excel but after sometime it comes
back. I also downloaded latest updates from MS site but it did not make any
difference. Has any one faced & solved this problem successfully. Als
pls check
On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote:
> Dear Experts,
>
>
>
> Kindly find the sheet and do the needful formula
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.
Dear Experts,
Kindly find the sheet and do the needful formula
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread t
=IF(C5<0,0,IF(C5>380,C5-B5,IF(AND(D5>0,D5<=380),C5,"NA")))
Drag down...
On Wed, May 20, 2015 at 11:22 AM, ankit sharma wrote:
> Dear Experts i want a formula that fulfill my both conditions pls solve
> this.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
Dear Experts i want a formula that fulfill my both conditions pls solve
this.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accura
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in the database name available A,B,C,D,E only then the
data for each should be make separate.
Thanks in advance.
Regards
Nasir Shaikh
--
Are you =EXP(E:RT) or =NOT(EXP(
Dear Sir,
My company has two shifts say Ist shift working =6:00 to 14:00 ans
second shift 14:00 to 22:00
i have large data of employees (rotating shifts) and want to calculate
which employee worked in which shift
Excel is on that format
EmployeeCode Shift
Dear Experts,
Kindly Help on urgent basis to get it resolve as below .
suggest any formula to get the exact data as i required. reference sheet
attached
I have data as below source 1 1 1 1 1 1 1 1 1 1 1 1 RAKESH A
B C DMUKESH A B C D E GAURAV A B
Hi!
I'm trying to connect a Excel file into a Oracle Database, for make updates
in some tables. But i get the same error, again and again, in the last 4
hours. The error is attached.
What i've done:
- Installed the ODBC driver in the Control Panel
- Checked the "Microsoft Activex Data 2.7" option
Hi,
Just want to solve the questions with analysis.
please find the enclosed attachment and answer the question. I also trying
to solve. But needed Gurus help.
Thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Check this out,
Want this result ??
Regards,
Mandeep baluja
Snapdeal.com
On Thursday, April 9, 2015 at 12:30:21 PM UTC+5:30, Vijayendra wrote:
>
> Dear Experts,
>
> Can you please help me to put vlookup or Index&Match formula for multiple
> column. Attached is the excel workbook.
>
> --
> ಧನ
Dear Experts,
Can you please help me to put vlookup or Index&Match formula for multiple
column. Attached is the excel workbook.
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
Cheers!!
On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao
wrote:
> Dear Vaibhav,
>
> Thank you very much for your quick support. This is very helpful.
>
> Regards,
> Vijayendra
>
> 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
>
>> PFA with #N/A handler...
>>
>> On Fri, Mar 13, 2015 at 1:08 PM, Vija
Dear Vaibhav,
Thank you very much for your quick support. This is very helpful.
Regards,
Vijayendra
2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
> PFA with #N/A handler...
>
> On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>> Can you please help me to put vlookup
Hi,
Please I need help with the attached file. I want a formula that calculates
how many times (10, 13, 17) combination has appeared within the range D5:I32
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
PFA with #N/A handler...
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> A
check this..
Cheers!!
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> Ar
Dear Experts,
Can you please help me to put vlookup or any other formula for the the
second row. Attached is the my file and request you to help on the same.
Regards,
Vijayendra
94491 67631
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Use Data==> Filter to get non zero values...
On Wed, Mar 11, 2015 at 1:34 PM, Harish P Y wrote:
> Hi,
>
> Needed help with the file attached file.I want to get the data of only the
> non zero elements from abstract sheet to abstract 2 sheet.
> kindly help me in this regard. tried pivot table but
Do let us know if you need any help..
Cheers!!
On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta wrote:
> Thanks
> On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
>
>> Hi
>>
>> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>>
>> Cheers!!
>>
>> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh
Thanks
On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
> Hi
>
> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>
> Cheers!!
>
> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta
> wrote:
>
>> Dear Friedns,
>>
>> Kindly help me in creating a conditional formating calander just like
>>
Hi
check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
Cheers!!
On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta wrote:
> Dear Friedns,
>
> Kindly help me in creating a conditional formating calander just like
> goole calander.
>
> My basis needs are as follows:-
>
>
> 1. Start Date
Dear Friedns,
Kindly help me in creating a conditional formating calander just like
goole calander.
My basis needs are as follows:-
1. Start Date
2. End Date
3. Days of Week( Could be Sunday to Monday any)
4. Start time of Class
5. End time of Class
This could be for many teachers.
Depending
Dear Friends
Pls find attached file of my work
In sheet two sheets one is main sheet & another is daily data
in main sheet yellow mark is the difference of two dates i want to do this
automatic becuase @ present i do it mannual and its taking too much time
pls give me suggestion
Warm Regards,
Dear experts,
I want to some of times as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi
Share excel file for more clarity..
Cheers!!
On Wed, Feb 11, 2015 at 11:26 AM, Enock Wangila wrote:
> Hi Guys,
>
> Please help me find a solution to this challenge. I need a formula that
> helps me fill multiple cells in a different worksheet by entering a value
> in a single cell in anothe
Hi Guys,
Please help me find a solution to this challenge. I need a formula that
helps me fill multiple cells in a different worksheet by entering a value
in a single cell in another worksheet. For instance, I have a cell with a
value of 5000 in one worksheet and I need a formula to populate 9
Great..Cheers!
On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com <
singla.kris...@gmail.com> wrote:
> Hi Vabz,
>
> Thank you very much That worked like wonder...
>
> Many thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! J
Hi Vabz,
Thank you very much That worked like wonder...
Many thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate t
HI
Not clear on what you want, can you explain further...
Cheers!!
On Tue, Feb 3, 2015 at 11:15 AM, wrote:
> I'm pretty new at this and any help or direction is greatly appreciated.
>
> So here's what I'm trying to do.
>
> First you might wanna download my example file so you can follow along.
Hi,
check this file..
Put formula countif in next columncopy & paste down, you can see there is
Separate set of sequential numbering for Dr & Cr.
Once it is ok, copy & paste value for formula column & sort data AtoZ ..
Cheers!!
On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com <
singla.
Send with Excel file where you want to do this.
Pramod
On 3 Feb 2015 17:25, "singla.kris...@gmail.com"
wrote:
> Hi,
>
> Can somebody please help me in a small macro. My sheet have a column with
> some values and I want to sort them alternately.
>
> Current
> Dr.
> Cr.
> Dr.
> Dr.
> Cr.
> Cr.
> C
Hi,
Can somebody please help me in a small macro. My sheet have a column with some
values and I want to sort them alternately.
Current
Dr.
Cr.
Dr.
Dr.
Cr.
Cr.
Cr.
Dr.
Required
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Dr.
Cr.
Thanks in advance
Krishan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
I'm pretty new at this and any help or direction is greatly appreciated.
So here's what I'm trying to do.
First you might wanna download my example file so you can follow along.
Looking at sheet 1 we have our first drop down; "category" in A4. I want to
select an option there (Either Underlayme
You can do so using macro..else you need to use dependent columns for data
validation list.
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar
wrote:
>
> Hi,
> I need help on Dependent Data validation.
> and please try to sol
Hi,
I need help on Dependent Data validation.
and please try to solve it without adding any other column.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464 <#>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo
rintOut
> End If
> Next i
> End Sub
>
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
> -- Forwarded message --
> From: As
Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
-- Forwarded message ------
From: Ashish Bhalara
Date: Fri, Dec 26, 2014 at 5:41 PM
Subject: $$Excel-Macros$$ Help on coding to change cell value after every
p
Dear experts,
I want to change cell value on every automatic printing as per series
given, please see attached file in which describe in detail.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Are you
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar
wrote:
>
> Welcome Ashu.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https
Welcome Ashu.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Dear Vaibhav/Ashish Sir,
Thanks for your help. I am looking for this only.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar
wrote:
>
> Hi Ashu,
>
> Check this!!
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
Hi Ashu,
Check this!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Dear Sir,
I want only single formula. I have some blank Cells in A and B column in
sheet 2. Query is attached please check again.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.
Hi Ashu,
Use Simple Vlookup function which is suggested by Vaibhav Sir.
and Delete NA# with help of filter.
It's simple.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.
Dear Sir,
I have some Blank cells in A column and Some Blank Cells in B Column in
sheet 2.
I want to match the C column data from Sheet 1.
only single formula required. If we don't want to put any formula in A and
B column but some cells are blank in both columns.
It is possible.
Thanks
Ashu K
101 - 200 of 1939 matches
Mail list logo
