area below the list Box, because there is no data
in the Form Load will fail, press the End button to exit the error.
2013/8/26 pawel lupinski
Hi All,
>
>unfortunately workbook is too big to share, but I've done some something
>(below):
> ActiveSheet.Shapes.Rang
problem is that something (macros) switching off/hiding listbox.
Thanks for support
Pawel
From: Prince
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Monday, August 26, 2013 8:05 AM
Subject: Re: listbox issue
Hi Pawel,
Pls shere your work
Hi All,
I have quite serious problem with the list box (ActiveX). when I use it on the
sheet where is placed is fine, but when I run any macro that is going to
different sheets suddenly is becoming disable. in order to activate it I need
to switch design mode click on list box and switch off d
013# Then
AnotherCode
Else
CurrentCode
End If
End Sub
Sub AnotherCode()
MsgBox "This Your Another Code"
End Sub
Sub CurrentCode()
MsgBox "This Your Current Code"
End Sub
On 14-08-2013 16:45, pawel lupinski wrote:
Hi All,
>
>is anyone
Hi All,
is anyone can help me on this:
I'd like to run macro base on following criteria: when I open file, macro is
checking today's date and if today is greater than e.g. 18/08/2013 macro is
execution another code.
if anyone give me some few lines of the code I'll be appreciated.
Regards
Hi All,
quick question is anybody know how to download weather forecast (7/10 days)
into excel. link / web site?
regards,
Pawel
--
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 All,
I've macro like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B23:HH400")) Is Nothing Then
ActiveWorkbook.Names("ActiveRow").RefersTo = "=" & ActiveCell.Row
End If
End Sub
unfortunately I can't undo any changes. Is the anyway
your file (it's working only on one condition, that you account_no column is
SORTED!!!)
I didn't want to advice you to do pivot table as per request function.
awel
From: raghunandan rallapalli
To: excel-macros@googlegroups.com
Sent: Tuesday, December 11, 2012
ot; module rather than a "sheet" module.
In your sample file, you would put in Cell A3:
=check(B3:AZ3)
let me know if this is what you are looking for.
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 tim
p the numbers in Nums
''''''''''''''''''''''''''''''''''
Dim N As Long
Dim D As Double
For N = LBound(Nums) To
Hi All,
I'd like to create function that will check for me if the cell in the row has
value below 0. The issue of mine is that lookup value is not cosistly in the
same column. so could be like this:
I'm looking value in column C then F them Z then AC so there is not real
sequence for it.
Fun
Paul - congratulation !!!
Pawel
From: "resp...@gmail.com"
To: excel-macros@googlegroups.com
Sent: Monday, December 3, 2012 9:55 PM
Subject: Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *
I couldn't agree more. Thumbs up Paul. Great
ok found it
http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=210201
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Thursday, November 8, 2012 1:34 PM
Subject: $$Excel-Macros$$ run macro from another fil
Hi All,
I'd like to ask you for help. I'd like to run macro from different file. So I
have master file where I have all data, this data a copied to another file and
after that macro need to be run. issue is: each day name of the file is
different so I can use stable one like
Application.Run
Hi All,
Can you help me on this example. I’m looking for excel function that will be
summarized what I have to buy and I’ve bought already.
I have table with requirements. On this base I’m ordering components from
different suppliers. For my budget I need to know how much I’ve already paid
and
'--
Cells(Targ.Row, "D").Value = "" 'Remove value in Column "D"
End If
End If
Next Targ
End Sub
Paul
-----
iple e.g.
column H, M, R ... etc.
Sorry I'm new to VBA and I'll be appreciated for your help
Regards,
Pawel
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of pawel lupinski
Sent: 02 November 2012 5:35
To: excel-macros@googlegroups.com
Subject: $
Hi All,
I need your help on this. I'd like to run macro when I delate value from the
cell. So I pushing "delate" and macro run. I couldn't find anything on the web
so if you can help me on this.
regards,
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discus
Hi All,
I'd like you to help me on stock cover formula that will help me calculate
stock coverage. Please look inside the file.
regards
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
("rngRange").Offset(1).Resize(UBound(VarArrResult)).Value =
Application.Transpose(VarArrResult)
Set objDicMap = Nothing
Set rngCell = Nothing
End Sub
Keep Excelling J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:excel-macros@googlegroups.com [mailto:excel-macros@go
Hi All,
I'd like to ask you for favour, can you help me with these. I have a table
"code" with codes. From this table I'd like to excclude all codes for table "to
delete" (tab table). Right now I'm using "or" function in vba, but when I want
to add something, each time I need to open VB and chan
Thanks a lot for that, I didn't thnik is possible but I needed to try.
Thanks
Pawel
From: Vabz
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Friday, September 21, 2012 2:01 PM
Subject: $$Excel-Macros$$ Re: color coding of REPT function
Hi All
I wonder if its possible to have color coding on "REPT" function. e.g. I'd like
to have 30 "g"s in red, 45 "g"s in green and 25 "g"s in orange. If you have any
ideas I'll be appreciated.
Pawel
PS. I don't want to use a graph for it.
--
Join official facebook page of this forum @
https:/
Tue, Sep 18, 2012 at 9:42 PM, pawel lupinski wrote:
Hi All,
>I need your help regarding to this: what I want is to sum up column D base on
>condition in column N.
>Regards,
>Pawel--
>Join official facebook page of this forum @
>https://www.facebook.com/discussexcel
>
Hi All,
I need your help regarding to this: what I want is to sum up column D base on
condition in column N.
Regards,
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate th
Sorry guys but someone used my nick and send it throught
Can admin look at it, please.
Real :)
Pawel
From: pawel lupinski
To: clai...@rhl.co.uk
Sent: Tuesday, September 18, 2012 9:21 AM
Subject: $$Excel-Macros$$ hello
this is interesting http
this is interesting http://www.newsisto.net/jobs/?article=18116
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
om
Subject: Re: $$Excel-Macros$$ hide column VBA
Sub sample()
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then
Cells(1, i).EntireColumn.Hidden = True
End If
Next
End Sub
On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote:
Hi All,
>
>I wonder if
Cells(1, i).EntireColumn.Hidden = True
End If
Next
End Sub
On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote:
Hi All,
>
>I wonder if you can help me, I'd like to hide all columns if the value in row
>1 is equal "1", I've written code but something is not workin
Hi All,
I wonder if you can help me, I'd like to hide all columns if the value in row 1
is equal "1", I've written code but something is not working. I'm new to VBA so
if you can help me. Code is below:
Sub HideColumn()
Dim a As Integer
Range("a1").Select
For a = a + 1 To 10
If ActiveCel
can,
As long as ever you can.” - John Wesley
-
____
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Mon, August 13, 2012 7:36:01 PM
Subject: $$Excel-Macros$$ macro for detecting date in row
Hi All,
I
Hi All,
I'd like to have a macro that will detect curent date (eg in column "H")
then copy all all columns from "A" to column "H" (column "H" excuded so range
A:G) and paste all these column as value
Thanks
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexc
;)
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, August 08, 2012 12:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula base on condition
Hi All,
I'm looking for formula that will be checking cell base
Hi All,
I'm looking for formula that will be checking cell base on the condition that
last 8 digits will be match, with 8 digits from different cell. Pls see
attachement.
Regards,
Pawel
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (112
I've just send you.
Thanks
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Tuesday, August 7, 2012 7:49 PM
Subject: Re: $$Excel-Macros$$ Re: Auto Filling of Color - Need Help
Or, if you do not know the name ON the shape and you don’t ha
Hi Prince,
Unfortunatelly I think as well that the macro is the only one solution for
this, but is outside of my confort zone.
Thanks anyway
Pawel
From: Prince Dubey
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Monday, July 16, 2012 5
ll base on condition formating
Please try paste special format
Sent on my BlackBerry® from Vodafone
____
From: pawel lupinski
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 07:38:57 -0700 (PDT)
To: excel-macros@googlegroups.com
ReplyTo: ex
Hi All,
I'd like to ask you for favour. I have an issue with copy of the colour from
condition formating to new place.
What I'd like to do is: copy values and colour to "Sheet2" cell B3 in the way
that I will have the value and the same colour.But the issue is colour can not
be base on conditio
be more appropriate.
Is this a project you want me to do for free or for hire?
Don
Guillett
Microsoft Excel Developer
SalesAid
Software
dguille...@gmail.com
From: pawel lupinski
Sent: Saturday, July 14, 2012 11:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro
Don
Guillett
Microsoft Excel Developer
SalesAid
Software
dguille...@gmail.com
From: pawel lupinski
Sent: Saturday, July 14, 2012 9:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro with multiple rows
Sorry All correct file
Hi All,
I'd like to ask you he
rksheets
If Not Len(Replace(WSheet.Name, "_Delete", "")) = Len(WSheet.Name) Then
Application.DisplayAlerts = False
WSheet.Delete
Application.DisplayAlerts = True
End If
Next
End Sub
Hope it will help to you.
On Fri, Jul 13, 2012
ening file on the external server
try to calculate required calculation with the help of macros.
Divaker
On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:
Hi All,
>
>I need your help on this issue. I have quite big file (21MB) that is doing a
>lot of calculation between tab
Hi All,
I need your help on this issue. I have quite big file (21MB) that is doing a
lot of calculation between tabs, in order to run this file more efficient I've
switch off calculation, and I'm switch it on when needed. When I've done this
file on my computer its opening slowly but not so ba
=xlCalculationManual
your macro
Application.Calculation=xlCalculationautomatic
end
sub
Don
Guillett
Microsoft Excel Developer
SalesAid
Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, July 11, 2012 1:56 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ switch
3:05 AM
Subject: Re: $$Excel-Macros$$ switch on anf off calculation
Use this line in your macro :-
Application.Calculation=xlCalculationManual
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
____
From: pawel lupinski
Hi All,
can you help me on this. I have quite large excel file, because there is a lot
of calculation, I'd like to switch off excel calculation and when I'll be
closing file schitch on calculation. I mean by macro (manually I know how to do
this :) )
thanks a lot
Pawel
--
FORUM RULES (9
:$E$23,B4&"*",$F$5:$F$23)
see attached sheet.
--
Thanks & regards,
Noorain Ansari
http://www.noorainansari.com/
www.excelmacroworld.blogspot.com
On Thu, Jul 5, 2012 at 1:55 AM, pawel lupinski wrote:
Hi All,
>I need your help on this particular task. Does anyone know how t
Congrats Rajan
Pawel
From: Aamir Shahzad
To: excel-macros@googlegroups.com
Sent: Wednesday, July 4, 2012 7:18 PM
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12)
Congrats Rajan
Aamir Shahzad
On Wed, Jul 4, 2012 at 10:55 PM,
tton3_Click()
Sheet1.ChartObjects("Chart 1").Chart.SetSourceData
Sheet1.Range("team3").CurrentRegion
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of pawel lupinski
Sent: 05 June 2012 3:37
Hi Rajan,
is there any chance, that you can explain me how you've done it?
Regards,
Pawel
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Monday, June 4, 2012 2:11 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button
HTH
Regards
Rajan v
((RIGHT(B3:B17,1)="e")*(C3:H17>0))
Don
Guillett
Microsoft MVP Excel
SalesAid
Software
dguille...@gmail.com
From: pawel lupinski
Sent: Sunday, June 03, 2012 1:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ counting "E" in the
column
Dear All,
I n
Don,
love it (great reply) :)
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Sunday, June 3, 2012 6:55 PM
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
I like my solution.
Don
Guillett
Microsoft MVP Excel
Congratulation Rajan Verma, thanks for support.
Regards,
Pawel
From: Prajakt Pande
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI ; jainayus...@gmail.com; Don
Guillett ; Marieswaran Smw ;
a...@lovetour.info
Sent: Sunday, June 3, 2012 6:58 PM
Subject
d the same formula provided by
Don
On Wed, May 30, 2012 at 7:28 PM, dguillett1 wrote:
glad to help
>
>
>Don Guillett
>Microsoft MVP Excel
>SalesAid Software
>dguille...@gmail.com
>
>From: pawel lupinski
>Sent: Wednesday, May 30, 2012 8:43 AM
>To: excel-macros@goog
cel-Macros$$ adjusting graph
Define a name such as mydata
=OFFSET(Arkusz2!$B$9,0,0,1,COUNTA(Arkusz2!$8:$8))
and use that in the source
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Tuesday, May 29, 2012 7:06 PM
To: excel-macros@googlegroups.co
(Arkusz2!$8:$8))
and use that in the source
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Tuesday, May 29, 2012 7:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ adjusting graph
Dear All,
I have a problem with adjusting graph
Hi Noorain
Please send the files
thanks
Pawel
From: Aruna jayaram
To: excel-macros@googlegroups.com
Sent: Tuesday, May 29, 2012 8:29 PM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files for excel 2007.
thanks
On Tue, May 29, 2012 a
ANSARI
wrote:
Dear Pawel,
>
>Please try this one.
>
>=INDIRECT(ADDRESS(MATCH($B6,INDIRECT(G$4&"!$B:$B"),0),12,1,0,G$4),FALSE)
>
>--
>Thanks & regards,
>Noorain Ansari
>www.noorainansari.com
>www.excelmacroworld.blogspot.com
>
>
&
Hi All,
I'm new to macros so I'd like to ask you for advice. Can you look at code below
and help me to improve. What I'd like to do is make changes to BOLDED line
("Windows("LowRisk EPlan SAUCE week 19.xls").Activate") in order to activeted
open file (in this case file is called "LowRisk EPlan
color depending from cell value
Hi,
PFA
On Mon, Apr 30, 2012 at 5:11 AM, pawel lupinski wrote:
Hi All,
>
>I'm asking you for help, I have a problem with compering two cells base on
>conditions. There is no problem if everything is running in order, but if
>there is a gap .
Hi All,
I'm asking you for help, I have a problem with compering two cells base on
conditions. There is no problem if everything is running in order, but if there
is a gap ... there is wrong answer given, pls see attachment and if you can
advice I'll be appreciated.
Regards,
Pawel
--
FOR
Haseeb / Maries
thank you very much I can always count on you both. It realy help me a lot.
Thanks a lot.
Pawel
From: Haseeb A
To: excel-macros@googlegroups.com
Sent: Monday, April 23, 2012 4:59 PM
Subject: Re: $$Excel-Macros$$ sequence help needed
Hello
@googlegroups.com] On
Behalf Of pawel lupinski
Sent: Wednesday, April 04, 2012 2:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ format cell
Hi All,
Can you help me with cell format I need to format it in the way that should
change input "0204177" to "R0204177",
Hi All,
Can you help me with cell format I need to format it in the way that should
change input "0204177" to "R0204177", but the difficult of my is that number of
digit can be vary from 6 to 7. Please see inside the file.
Regards,
Pawel
--
FORUM RULES (986+ members already BANNED for violation
I realy don't know what are you looking for so check if this is what you are
looking for.
Regards,
Pawel
From: Darwin Chan
To: excel-macros@googlegroups.com
Sent: Tuesday, April 3, 2012 12:02 PM
Subject: $$Excel-Macros$$ To calculate the maximum and minimum
Hi Again,
Thanks again, it's all working, I have a lot to learn what is great, you've
shown me the magic.
thanks
Pawel
____
From: pawel lupinski
To: "excel-macros@googlegroups.com"
Sent: Sunday, April 1, 2012 10:45 PM
Subject: Re: $$Excel
thanks a lot.
Pawel
From: Haseeb A
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Sunday, April 1, 2012 7:42 PM
Subject: $$Excel-Macros$$ Re: format a cell
Hello Pawel,
Another one.
=TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"00\:00")
If you want
e...@gmail.com
From: pawel lupinski
Sent: Thursday, March 29, 2012 7:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
Maries,
this is great, realy simplistic working fine, but what I find out today is that
people have tendency to input "2.3" what means
d, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD
>wrote:
>
>Dear Noorain,
>>
>>I think he want 532, and I'd like to be converted to 05:32
>>
>>
>>
>>
>>From: NOORAIN ANSARI
>>To: excel-macros@googlegroups.com
>>Sent: Wednesday,
Hi Kiran,
the easiest way of doing it is pivot table (so you can manage as you want)
both request attached. From the macro point of view I can't help you
with, but I've got your piont sometimes you want to see it to be able to learn
it.
Regards,
Pawel
ps I couldn't send you attachment - limi
: Wednesday, March 28, 2012 7:55 AM
>
>Subject: Re: $$Excel-Macros$$ format a cell
>
>
>
>Dear Pawel.
>
>Please try it..
>
>=TIME(LEFT(C4,1),RIGHT(C4,2),0)
>
>--
>
>Thanks & regards,
>Noorain Ansari
>http://noorainansari.com/
>http://excelmacrow
Hi All,
I need your help on this simple task i don't know how to do this and for you it
will be easy.
I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32
and be converted to 5:32.
I've tried to change cell format like "hh:mm", "[hh]:mm" but its not working
what
s.
Look for _ in col_____ in column_, why__
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, February 15, 2012 8:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ bom explosion help needed
Hi Don,
thanks aga
quot;).PivotFields("Date").CurrentPage =
Range("B4").Value
ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").CurrentPage =
Range("B4").Value
End If
End Sub
Thats it.
Regards,
MARIES.
On Sun, Feb 12, 2012 at 3:50 PM, pawel
HI MARIES,
Can you let me know how you've done this, please
Regards,
Pawel
From: Maries
To: excel-macros@googlegroups.com
Sent: Sunday, February 12, 2012 5:33 AM
Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
Hi,
Find the attached file.
thanks Mate
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Friday, February 10, 2012 8:07 PM
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
Aw shucks.
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent
available and use data
validation to pick col B
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Friday, February 10, 2012 1:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ explosion maco needed pls
yes - you are the one
thanks again "the gre
r Field:=1, Criteria1:=Cells(i, "b")
.Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2)
.AutoFilter
End With
End With
Next i
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Friday, February 10, 2012 12:25 PM
To: excel-macros@googlegroups.c
r each of the 3 codes.
Do you want to further restrict by reference in c5:c16 or is that meaningless
like the dates in d516
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Friday, February 10, 2012 12:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
Hi All,
Its nice staff do you have this in English it looks great but I don't get a
word from it :)
Regards,
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Thursday, February 9, 2012 5:36 PM
Subject: Re: $$Excel-Macros$$ Offset Formula
Hi All,
I have the question if any of you were using scheduler123 for production
planing is based on excel and macros so if yes can you let me know is useful?
or maybe anyone of you have such demo, I'll be appreciated of any your thoughts
.
Regards,
Pawel
--
FORUM RULES (986+ members alread
eets.Count)
ActiveSheet.Name = "Week " & _
InputBox("Enter week NUMBER ie: 10")
End Sub
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, February 08, 2012 5:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MASTER macro.
H
Hi All,
I know you can help me as many times before,so this time I'd like to ask you
for help with simple macro.
I'd like to do macro that will copy "MASTER" tab to the end of the tabs, but
this macro (will be perfect) if can ask user for week number,
and change name "MASTER" to "week and th
result by IF function
regards,
Pawel
From: anu gomathi
To: excel-macros@googlegroups.com
Sent: Tuesday, September 6, 2011 9:00 PM
Subject: $$Excel-Macros$$ Help in IF Function
Hi All,
Please help me to put the IF function for the below table. If the table v
both file from Haseeb and Ashish working GRAET!!!
thanks a lot to you both
Pawel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Joi
pawel lupinski
Hi All,
>I realy need your help with formating of the cells. see inside.
>Thanks
>Pawel
>
>--
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tip
Hi Mate,
See attachement I've done it in two ways. First by PIVOT TABLE, second by
function. Try if it helps.
Regards,
Pawel
From: San Pat
To: excel-macros
Sent: Sat, March 5, 2011 2:28:42 AM
Subject: $$Excel-Macros$$ Help needed - Extract data by customer
hey Mate, let me know what are you looking for (position), so maybe I can help
you. In the attachement you have sample of media supervisor. I don't know if
this help, so on Monday I'll find something.
Pawel
From: sudhir kumar
To: Excel Group
Sent: Fri, Marc
Thanks Mate, its great
From: STDEV(i)
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Fri, March 4, 2011 6:31:35 PM
Subject: Re: $$Excel-Macros$$ help with formating
see inside if it help
On Fri, Mar 4, 2011 at 8:33 PM, pawel lupinski wrote
Hi All,
I realy need your help with formating of the cells. see inside.
Thanks
Pawel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
tocalculate and distribute the optimum load to
each shift.
On Fri, Feb 18, 2011 at 2:21 PM, pawel lupinski wrote:
Hi All,
>I need to ask you for help, cos I've stacked.
>I nedd help with distribution products from schedule to different shift.
>See attachement, it will put som
Hi All,
I need to ask you for help, cos I'vestacked.
I nedd help with distribution products from schedule to different shift.
See attachement, it will put some light on it.
Thanks in advance
Pawel
--
---
thanks!!!
From: danial mansoor
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 4:02:58 AM
Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range
use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an
ar
thanks a lot!!! superb
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 5:33:44 AM
Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range
check the attachment
On Wed, Feb 9, 2011 at 8:32 AM, danial manso
94 matches
Mail list logo
