date:20110218

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

2011-02-18 Thread ashish koul

see if it helps
On Sat, Feb 19, 2011 at 11:13 AM, San Pat  wrote:

> Hi Group,
>
> I need a urgent help to extract data by given MM/Year from a raw data.
>
> Basically, I am looking for a macro which will extract data from the raw
> data for a given MM/Year. See the attached reference sheet.
>
> Regards,
>
>  --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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


Copy of Extract_Data_By_Month_Year.xlsm
Description: Binary data

$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

2011-02-18 Thread Ayush

Hi Rashid,

You can find the macro at the link below :
http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html

Let us know if you have any questions:

Regards
Ayush Jain
Group Manager

On Saturday, February 19, 2011 12:47:51 PM UTC+5:30, rashid memon wrote:
>
> Dear Experts,
>
> i want to convert PDF file to Excel so plz provide me macro
>
> file is attached...
>
>
> Looking forward to receive your kind attention.
>
>
> Thanks & Best Regards
>
> Rashid Hussaini
>
> Email:- *mr.rash...@gmail.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

$$Excel-Macros$$ how i convert pdf file to Excel using macro.

2011-02-18 Thread rashid memon

Dear Experts,

i want to convert PDF file to Excel so plz provide me macro

file is attached...


Looking forward to receive your kind attention.


Thanks & Best Regards

Rashid Hussaini

Email:- *mr.rashidme...@gmail.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


KMO stock report op, 19.02.2011.pdf
Description: Adobe PDF document

Re: $$Excel-Macros$$ Excel Formula Help

2011-02-18 Thread Sanjoy Nath

As Your formula is circular , it will cause error
Go to Excel Options>Formula>Iterations>Check the box on
restart excel

Error will not get there



On Fri, Feb 18, 2011 at 8:33 PM, vitorjose  wrote:

> I prepare construction estimates and am required in some cases to add
> costs for providing a performance bond.  I arrive at a total price
> lets say $1,000,000 then add in bond cost at $10 per thousand
> (10,000).  If am successful i receive a contract for 1,010,000 from my
> customer.  When i go to my bonding company to purchase my bond they
> charge me based on the total contact amount, the bond costs me
> 10,100.  So you see i am 100 short from what i included in my
> estimate.  This doesn't seem like a big amount but when you get to
> much larger projects  it can be significant.  At first glance this
> could be done by turning on creating a circular reference and turning
> on iteration.  I am wondering if there is any other way of doing this
> which doesn't create a circular reference.
>
> Thanks for your help
> Victor  P
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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 needed to extract data by MM/Year

2011-02-18 Thread San Pat

Hi Group,

I need a urgent help to extract data by given MM/Year from a raw data.

Basically, I am looking for a macro which will extract data from the raw
data for a given MM/Year. See the attached reference sheet.

Regards,

-- 
--
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


Extract_Data_By_Month_Year.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Help, please, with debugging a function

2011-02-18 Thread Dave Bonallack


Hi,
The logic appears to be a bit weird:

If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then
Range(rCell.Address).Select
Exit Sub
End If

If the first cell in the selected range is not empty, or has dependents, then 
that cell is selected, and the sub exits.
What do you actually want the macro to do with what it finds?
 
Regards - Dave.
 

> Sub Whats_In_Range()
> Dim rCell As Range
> For Each rCell In Selection.Cells
> If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then
> Range(rCell.Address).Select
> Exit Sub
> End If
> 
> Next rCell
> MsgBox "Nothing found."
> End Sub
> 
> Function HasDependents(ByRef CellPassedIn As Range) As Boolean
> Dim objRng As Range
> On Error Resume Next
> Set objRng = CellPassedIn.Dependents
> On Error GoTo 0
> HasDependents = Not objRng Is Nothing
> End Function
> 
> -- 
> --
> 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$$ Special Suffix Identification

2011-02-18 Thread ashish koul

try this

On Sat, Feb 19, 2011 at 12:42 AM, Pehrson, Dave  wrote:

> Thanks for your quick response, you’re getting close, the following is an
> example of what I’m trying to achieve.  Column A is the original data, and
> Column A together with Column B is the desired result.
>
>
>
> 188-512
>
> 76-544
>
> 84-737-JP
>
> JP
>
> AT-2-CH
>
> CH
>
> CAA-166
>
> FPC-7
>
> FW-34-CH
>
> CH
>
> HD-12B-TH
>
> TH
>
> LMT-495781
>
> MA-101
>
> MAU/EX-3173
>
> MB-16B
>
> MBU-10A
>
> STB-2-CH
>
> CH
>
> WG-9A-JP
>
> JP
>
> WHG-104
>
> WHG-57
>
> WJ-115-TH
>
> TH
>
> WT-458
>
> WTE-12-CH
>
> CH
>
> WYL-240B-TH
>
> TH
>
> WYLA-1-TH
>
> TH
>
>
>
> Thanks for your support
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Friday, February 18, 2011 11:46 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Special Suffix Identification
>
>
>
>
> See if it helps
>
> On Fri, Feb 18, 2011 at 11:14 PM, Diamond Dave 
> wrote:
>
> I have a series of numbers with the number of characters being
> variable and either Alfa or numeric, and sometimes characters are
> separated with a “-“, and some ending with -CH, -JP, -MX, -TH, -CC, -
> AF.
>
> What I want to do is in the next column, enter a suffix matching the
> list from above.
>
> Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
> be blank,  WMF-123-MX would show MX
>
> Any help in sorting out this problem would be appreciated.  if there
> is a formual that could be incorporated into a macro or just a stand
> alone macro either will work for me.
>
> Thanks
> Diamond Dave
>
> --
>
> --
> 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 
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile 
>
>
>
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


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


TESTS.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Insert Column

2011-02-18 Thread Sayyad1284

Thanks Paul ...

On Feb 18, 6:45 pm, Paul Schreiner  wrote:
> This may not be the most elegant, but it works:
> Assuming that your week numbers are in row 1, then:
>
> Option Explicit
> Sub Seq_Columns()
>     Dim nCols, C
>     Application.ScreenUpdating = False
>     nCols = ActiveCell.SpecialCells(xlLastCell).Column
>     C = 2
>     Do While C < nCols
>     If (Cells(1, C).Value <> "") Then
>     If (IsNumeric(Cells(1, C).Value)) Then
>     If (IsNumeric(Cells(1, C + 1).Value)) Then
>     If (Cells(1, C + 1).Value <> Cells(1, C).Value + 1) Then
>     Cells(1, C + 1).EntireColumn.Insert Shift:=xlToRight, 
> _
>   CopyOrigin:=xlFormatFromLeftOrAbove
>     Cells(1, C + 1).Value = Cells(1, C).Value + 1
>     nCols = nCols + 1
>     If (Cells(1, C + 1).Value = 52) Then Exit Do
>     End If
>     End If
>     End If
>     End If
>     C = C + 1
>     Loop
>     Application.ScreenUpdating = True
> End Sub
>
> Paul
>
> 
> From: Sayyad1284 
> To: MS EXCEL AND VBA MACROS 
> Cc: sayyad1...@hotmail.com
> Sent: Fri, February 18, 2011 4:34:51 AM
> Subject: $$Excel-Macros$$ Insert Column
>
> Helllo Experts,
>
> I have a situation as follows,
>
> my data is distributed in coloumns , represnts weeknumbers as
>
> 8 9 10 11 .. 52
>
> some times if there are no values for a particular weeks then the
> data will look as
>
> 8 13 14 15 16
>
> what i want is is there are gaps in weeks so the I need to insert no.
> columns in between ,
>
> for e.g. if there is 8 & next number is 13 , the program should add 4
> columns ..
>
> this needs to be done through out the range where ever there are no
> consecutive weeks
>
> Need your suggestions
>
> --
> ------
>
> 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.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://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$$ Nedd help with product distribution in production plan

2011-02-18 Thread pawel lupinski

Hi Nath,

I hope, that I've understood you correctly (english is not my first language  
). 
the weightages are:
group -> as its indicate different department/machinery
name -> as its indicate product
many many many thanks
Pawel 

From: Sanjoy Nath 
To: excel-macros@googlegroups.com
Sent: Fri, February 18, 2011 11:20:14 AM
Subject: Re: $$Excel-Macros$$ Nedd help with product distribution in production 
plan

use the solver optimeser.
Parameterise the weightages.If you provide me the weightages , then I can write 
the macro for you that will autocalculate 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 some light on it.
>Thanks in advance
>Pawel 
>
> 
>-- 
>--
>
>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
>

-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)
-- 
--

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$$ Help, please, with debugging a function

2011-02-18 Thread DaveO

I wrote some code to search a range of cells to locate non-blank cells
and cells with dependents. (A clever contributor on these forums, Jim
Cone, was pivotal- thank you, Jim!)

I had this code running correctly at one point, but lost the file that
contained the working code. I've tried to recreate it, but with no
success so far. This code compiles but all it does is return the cell
pointer to the upper left corner of the selected range. Can anyone
tell me what I've done wrong? ~Thanks.

Sub Whats_In_Range()
Dim rCell As Range
For Each rCell In Selection.Cells
  If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then
Range(rCell.Address).Select
Exit Sub
  End If

Next rCell
MsgBox "Nothing found."
End Sub

Function HasDependents(ByRef CellPassedIn As Range) As Boolean
Dim objRng As Range
On Error Resume Next
Set objRng = CellPassedIn.Dependents
On Error GoTo 0
HasDependents = Not objRng Is Nothing
End Function

-- 
--
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$$ Special Suffix Identification

2011-02-18 Thread Pehrson, Dave

Thanks for your quick response, you're getting close, the following is
an example of what I'm trying to achieve.  Column A is the original
data, and Column A together with Column B is the desired result.

 

188-512


76-544


84-737-JP

JP

AT-2-CH

CH

CAA-166


FPC-7


FW-34-CH

CH

HD-12B-TH

TH

LMT-495781


MA-101


MAU/EX-3173


MB-16B


MBU-10A


STB-2-CH

CH

WG-9A-JP

JP

WHG-104


WHG-57


WJ-115-TH

TH

WT-458


WTE-12-CH

CH

WYL-240B-TH

TH

WYLA-1-TH

TH

 

Thanks for your support

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul
Sent: Friday, February 18, 2011 11:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification

 


See if it helps 

On Fri, Feb 18, 2011 at 11:14 PM, Diamond Dave 
wrote:

I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a "-", and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.

What I want to do is in the next column, enter a suffix matching the
list from above.

Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
be blank,  WMF-123-MX would show MX

Any help in sorting out this problem would be appreciated.  if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.

Thanks
Diamond Dave

--

--
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  

akoul.wordpress.com  

My Linkedin Profile  

 

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$$ Special Suffix Identification

2011-02-18 Thread Pehrson, Dave

Paul, thanks for your interest and quick response.

 

Please reference response in Red

 

The following is an example of the variability of characters. Note the
one parts in red are the parts I want to identify

 

188-512


76-544


84-737-JP

JP

AT-2-CH

CH

CAA-166


FPC-7


FW-34-CH

CH

HD-12B-TH

TH

LMT-495781


MA-101


MAU/EX-3173


MB-16B


MBU-10A


STB-2-CH

CH

WG-9A-JP

JP

WHG-104


WHG-57


WJ-115-TH

TH

WT-458


WTE-12-CH

CH

WYL-240B-TH

TH

WYLA-1-TH

TH

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner
Sent: Friday, February 18, 2011 11:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification

 

Is the length of the PREFIX consistent? No

that is:  in your example, you're using wyl- and WMF-

is it always 3 characters. No

 

also, you said SOMETIMES the suffix is preceded by: "-"

what is it otherwise? If there is a suffix, it will be preceded by an
"-" Yes, that is correct

 

Is it always a 2 character suffix (if present)? Yes 2 is the current
limit

 

Are you wanting a  Excel Function solution? or VBA solution?  I'm not
sure which is easier, not being a programmer, I have found that if I can
write a formula, I can record It into a macro (not always effiecnt but
it works, but I have worked either way.  What is the easiest?

 

Paul

 



From: Diamond Dave 
To: MS EXCEL AND VBA MACROS 
Sent: Fri, February 18, 2011 12:44:09 PM
Subject: $$Excel-Macros$$ Special Suffix Identification

I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a "-", and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.

What I want to do is in the next column, enter a suffix matching the
list from above.

Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
be blank,  WMF-123-MX would show MX

Any help in sorting out this problem would be appreciated.  if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.

Thanks
Diamond Dave

-- 

--
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$$ Query

2011-02-18 Thread Aamir Shahzad

Thanks Ashish, Its nice, please explain how this formula is working

On Thu, Feb 17, 2011 at 5:29 AM, ashish koul  wrote:

>
>
> IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),"Doubtful",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Loss"),"Loss",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Substandard"),"Substandard","Regular")))
>
> type this in e4
> On Wed, Feb 16, 2011 at 9:59 PM, Aamir Shahzad 
> wrote:
>
>> Maximum 4 classifications
>> 1) Regular
>> 2) Substandard
>> 3) Doubtful
>> 4) Loss
>>
>> On Tue, Feb 15, 2011 at 8:34 PM, ashish koul wrote:
>>
>>> will it be these three classifications only
>>>
>>>
>>> On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad >> > wrote:
>>>
 Thanks *Ashish *for reply but can you please provide formula without
 pivot. Condition you have understand that if sum of any classification is
 grater then others,it shows that value.



 On Tue, Feb 15, 2011 at 8:14 AM, ashish koul wrote:

>
>
> On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad <
> aamirshahza...@gmail.com> wrote:
>
>>
>> Hi all experts,
>>
>> Please resolve my query by formula. sheet attached.
>>
>> Regards,
>>
>> Aamir Shahzad
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile
>
>
> 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

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> 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

Re: $$Excel-Macros$$ Special Suffix Identification

2011-02-18 Thread ashish koul

See if it helps
On Fri, Feb 18, 2011 at 11:14 PM, Diamond Dave  wrote:

> I have a series of numbers with the number of characters being
> variable and either Alfa or numeric, and sometimes characters are
> separated with a “-“, and some ending with -CH, -JP, -MX, -TH, -CC, -
> AF.
>
> What I want to do is in the next column, enter a suffix matching the
> list from above.
>
> Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
> be blank,  WMF-123-MX would show MX
>
> Any help in sorting out this problem would be appreciated.  if there
> is a formual that could be incorporated into a macro or just a stand
> alone macro either will work for me.
>
> Thanks
> Diamond Dave
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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


TESTS_NEW.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Special Suffix Identification

2011-02-18 Thread Paul Schreiner

Is the length of the PREFIX consistent?
that is:  in your example, you're using wyl- and WMF-
is it always 3 characters.

also, you said SOMETIMES the suffix is preceded by: "-"
what is it otherwise?

Is it always a 2 character suffix (if present)?

Are you wanting a  Excel Function solution? or VBA solution?

Paul





From: Diamond Dave 
To: MS EXCEL AND VBA MACROS 
Sent: Fri, February 18, 2011 12:44:09 PM
Subject: $$Excel-Macros$$ Special Suffix Identification

I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a “-“, and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.

What I want to do is in the next column, enter a suffix matching the
list from above.

Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
be blank,  WMF-123-MX would show MX

Any help in sorting out this problem would be appreciated.  if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.

Thanks
Diamond Dave

-- 
--

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$$ Special Suffix Identification

2011-02-18 Thread Diamond Dave

I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a “-“, and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.

What I want to do is in the next column, enter a suffix matching the
list from above.

Example: original number:  wyl-927-TH  would read TH,  wyl-987 would
be blank,  WMF-123-MX would show MX

Any help in sorting out this problem would be appreciated.  if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.

Thanks
Diamond Dave

-- 
--
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 SOS

2011-02-18 Thread ashish koul

see if this helps or you want to do it by  macro

On Fri, Feb 18, 2011 at 4:03 PM, Surendra wrote:

> HI Team,
>
>
>
> Please help.
>
>
> Regards,
>
> surendra
>
> Regards,
>
> Surendra Singh
> 9301334795
>
> 
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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


tests abc-1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please Help

2011-02-18 Thread ashish koul

arre you using excel 2003 or 2007

if you are using 2007 simply apply filter by color


On Fri, Feb 18, 2011 at 3:49 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:

> Dear All,
>
> I have cash entries in one workbook and I want total of some specific
> entries in different workbook.
>
> Please can you help me on the same.
>
> Regards,
> Shrinivas
>
> --
>
> --
> 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 
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Import .csv & match records

2011-02-18 Thread Dave

Hi,

Thanks for the macro.

What I meant was that code 1 and code 2 uniquely defines a row so if
there is  data item in the .csv file than it the macro should insert
the row in from of the code1 (column A) and code 2 (column B). Im my
spreadsheet  I have 12 monthly tabs which all look exactly the same
setup of montly_totals.xls is as below:

Code 1   Code 2  YR  MM  CoName   Dept_name   Quantity   $amount
A5   B5c5   d5e5  f5
g5   g6

Will I insert this macro as a module on every monthly tab in
montly_totals.xls ? And run it for each tab?
Will this macro insert any new data that it does not find in the
montly_totals.xls  but finds in the .csv file?

thanks for your help


newby Dave

On Feb 17, 11:15 am, Paul Schreiner  wrote:
> Piece of cake...
> I can probably write it in 20 minutes.
> =
> Option Explicit
> Dim Col_Array_Code1, Col_Array_Code2, Col_Array_YR, Col_Array_MM
> Dim Col_Array_CoName, Col_Array_Dept, Col_Array_Qty, Col_Array_Amt
> Dim Code1, Code2, YR, MM
> Dim CoName, Dept, Qty, Amt
> Dim fso
>    
> Public Const ForReading = 1, ForWriting = 2, ForAppending = 3
> Sub ReadData()
>     Dim CSVFile, R, f, str, StrArray
>     CSVFile = "P:\DAM\WI_JAN_2011.csv"
>     Set_Defaults
>     Set fso = CreateObject("Scripting.FileSystemObject")
>     Set f = fso.OpenTextFile(CSVFile, ForReading)
>     Do While Not f.atendofstream
>     RecCnt = RecCnt + 1
>     If (RecCnt Mod 100 = 0) Then Application.StatusBar = "Searching
> Commercial Archives for: " & MatNo & " : " & RecCnt
>     str = f.readline
>     StrArray = Split(str, ",")
>    
>     Code1 = Trim(StrArray(Col_Array_Code1))
>     Code2 = Trim(StrArray(Col_Array_Code2))
>     YR = Trim(StrArray(Col_Array_YR))
>     MM = Trim(StrArray(Col_Array_MM))
>     CoName = Trim(StrArray(Col_Array_CoName))
>     Dept = Trim(StrArray(Col_Array_Dept))
>     Qty = Trim(StrArray(Col_Array_Qty))
>     Amt = Trim(StrArray(Col_Array_Amt))
>    
>     Loop
> End Sub
> Sub Set_Defaults()
>     Col_Array_Code1 = 0
>     Col_Array_Code2 = 1
>     Col_Array_YR = 2
>     Col_Array_MM = 3
>     Col_Array_CoName = 4
>     Col_Array_Dept = 5
>     Col_Array_Qty = 6
>     Col_Array_Amt = 7
>    
> End Sub
> ===
>
> However, something you said makes me think it might not be as easy to PLACE 
> the
> data.
>
> In the sheet for each month,
> you have 200 "accounts"
> and the combination of Code1 & Code2 defines a "record".
>
> You want to read the .csv file and copy the records to the appropriate
> "accounts"...
>
> That implies that the sheets in the monthly_totals workbook
> have a specific "layout" that you want to maintain.
>
> I need to know what that layout is so that I can "find" the appropriate
> "account".
>
> I think I'm going to need a copy of the Monthly_totals.xls workbook.
> and, it would help if I had one or more of the .csv files.
> Otherwise, I have to spend more time making up fake data than actually writing
> code!
>  
>  
> Paul
>  
>
> 
> From: Dave 
> To: MS EXCEL AND VBA MACROS 
> Sent: Thu, February 17, 2011 9:32:15 AM
> Subject: $$Excel-Macros$$ Import .csv & match records
>
> I  am on Excel 2003,. I have a spreadsheet with 12 monthly tabs one
> for
> every month of the year January, February … December.. This file is
> called montly_totals.xls and is located in P:\DAM\WI_FTP.  There are
> a
> total of 200 accounts set up in each of these monthly tabs. Each of
> these accounts starts with a code in A1 & B1 . These are 4 character
> codes like below:  They are sorted by Code 1.
> Code 1 + Code 2 uniquely identify a record.
>
> Code1  Code2
>
> 0845    MTRA
> 1016    
> 1017    LEGL
> 1605    1605
> 1605    OSLA
>     0001
>     0002
>
> Every month I download a comma delimited file named as WI_JAN_2011,
> WI_FEB_2011 and so on till WI_DEC_2011.  This file is located in P:
> \DAM
> \WI_FTP This file may contain 10 to 150 accounts with updated
> information for that specific month.  They also have the same codes
> as
> above. The format of the comma delimited file is :
>
> Code1,Code2,YR,MM,CoName,Dept_name,Quantity,$amount
>
> 0010,,11,01,Iron works    ,Grills                      ,
> 00130,003448635,
>
> (they are all on one line)
>
> Currently every month I have to open each monthly tab  and manually
> copy and paste the correct Information from the  comma delimited file
> into the exact columns in my montly_totals.xls spreadsheet. The
> columns I copy are : YR,MM,CoName,Dept_name,Quantity,$amount
>
> I want a macro that would read this comma delimited file and insert
> these  new monthly  updated values to  the  correct account numbers.
> I was thinking that it could key on Code1 & Code2  fields. Once there
> is a match between the codes i.e Code1+C

$$Excel-Macros$$ Excel Formula Help

2011-02-18 Thread vitorjose

I prepare construction estimates and am required in some cases to add
costs for providing a performance bond.  I arrive at a total price
lets say $1,000,000 then add in bond cost at $10 per thousand
(10,000).  If am successful i receive a contract for 1,010,000 from my
customer.  When i go to my bonding company to purchase my bond they
charge me based on the total contact amount, the bond costs me
10,100.  So you see i am 100 short from what i included in my
estimate.  This doesn't seem like a big amount but when you get to
much larger projects  it can be significant.  At first glance this
could be done by turning on creating a circular reference and turning
on iteration.  I am wondering if there is any other way of doing this
which doesn't create a circular reference.

Thanks for your help
Victor  P

-- 
--
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$$ Re: Please Help

2011-02-18 Thread KishorKumar4U

Hi Shinivas,
 
  You can use the data sorting by the font color to get your 
data sorted. So that you can easily copy and paste into next sheet.
 
Thanks,
Kishor

-- 
--
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$$ Insert Column

2011-02-18 Thread Paul Schreiner

This may not be the most elegant, but it works:
Assuming that your week numbers are in row 1, then:

Option Explicit
Sub Seq_Columns()
    Dim nCols, C
    Application.ScreenUpdating = False
    nCols = ActiveCell.SpecialCells(xlLastCell).Column
    C = 2
    Do While C < nCols
    If (Cells(1, C).Value <> "") Then
    If (IsNumeric(Cells(1, C).Value)) Then
    If (IsNumeric(Cells(1, C + 1).Value)) Then
    If (Cells(1, C + 1).Value <> Cells(1, C).Value + 1) Then
    Cells(1, C + 1).EntireColumn.Insert Shift:=xlToRight, _
  CopyOrigin:=xlFormatFromLeftOrAbove
    Cells(1, C + 1).Value = Cells(1, C).Value + 1
    nCols = nCols + 1
    If (Cells(1, C + 1).Value = 52) Then Exit Do
    End If
    End If
    End If
    End If
    C = C + 1
    Loop
    Application.ScreenUpdating = True
End Sub

Paul



From: Sayyad1284 
To: MS EXCEL AND VBA MACROS 
Cc: sayyad1...@hotmail.com
Sent: Fri, February 18, 2011 4:34:51 AM
Subject: $$Excel-Macros$$ Insert Column

Helllo Experts,

I have a situation as follows,

my data is distributed in coloumns , represnts weeknumbers as

8 9 10 11 .. 52

some times if there are no values for a particular weeks then the
data will look as

8 13 14 15 16

what i want is is there are gaps in weeks so the I need to insert no.
columns in between ,

for e.g. if there is 8 & next number is 13 , the program should add 4
columns ..

this needs to be done through out the range where ever there are no
consecutive weeks


Need your suggestions

-- 
--

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 SOS

2011-02-18 Thread Paul Schreiner

Just a little piece of advice:
A subject line of: HELP SOS
does nothing to get the right person to look at your problem.
Some people are experts in Pivot Tables,
Some, know a lot about Date issues.
Others read in Text files, or report from external databases.

MANY are very busy and only open questions that pertain to their area of 
expertise.
I don't know of many people that specialize in SOS.

In fact, I normally immediately delete posts that do not explain the problem or 
issue
since there are many MORE people that have taken the time to do so...

Usually,the other people get their questions addressed first.
Then the non-specific questions get attention when the "experts" are bored...

Just some advice...

Paul





From: Surendra 
To: excel-macros@googlegroups.com
Sent: Fri, February 18, 2011 5:33:51 AM
Subject: $$Excel-Macros$$ HELP SOS

HI Team,



Please help.


Regards,

surendra

Regards,

Surendra Singh
9301334795
 -- 
--

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$$ HELP SOS

2011-02-18 Thread Surendra

HI Team,



Please help.


Regards,

surendra

Regards,

Surendra Singh
9301334795

-- 
--
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


Book1.xls
Description: Binary data

Re: $$Excel-Macros$$ RE: Excel graphs and formula for adding time spent

2011-02-18 Thread Sanjoy Nath

mod 60 calculations and mod 100 calculations are not same thing
   mathematical operators work in the mod 100 mode and time works in the
mod 60 mode

On Wed, Feb 16, 2011 at 2:38 AM, Prakash Gusain wrote:

> Dear Vinod,
>
> The sum formula is giving correct solution if you mean by 0:20 mins.
> Kindly explain where are you facing the issue or why do you think the sum
> for 4:30 is not correct.
>
> --
> Best Regards!
> Prakash Singh Gusain
>
> *Please visit my blog (**click here **
> )*
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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$$ Excel intrinsic constants/enumerations

2011-02-18 Thread Sanjoy Nath

Please provide the file and what you want.
We can help better



On Wed, Feb 16, 2011 at 2:56 AM, Jeff  wrote:

> Sanjoy,
>
> Thanks for your reply.  I suspect you are saying that if I press F2 in
> something like Visual Studio I will get a page come up that will show the
> values for the constants/enumerations. (I'm not at a place that I can check
> VS).My question may be a bit more fundamental.  When I try to compile
> the compiler says such are not defined.  So I think I need to do something
> similar as C and include some header file that defines the constants.  In my
> research I've come across the statement Imports which might be the way but
> unfortunately it did not work for me.
>
> Does it make sense what I'm asking?  I'm sure it's simple for all the
> experienced VB.NET  programmers.
>
> Thanks,
>
> Jeff
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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$$ Please Help

2011-02-18 Thread Chidurala, Shrinivas

Dear All,

I have cash entries in one workbook and I want total of some specific entries 
in different workbook.

Please can you help me on the same.

Regards,
Shrinivas

-- 
--
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


FA.xls
Description: FA.xls

Re: $$Excel-Macros$$ Nedd help with product distribution in production plan

2011-02-18 Thread Sanjoy Nath

use the solver optimeser.
Parameterise the weightages.If you provide me the weightages , then I can
write the macro for you that will autocalculate 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 some light on it.
>
> Thanks in advance
>
> Pawel
>
>
> --
>
> --
> 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
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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$$ columns into rows, with a twist

2011-02-18 Thread Sanjoy Nath

use transpose (ctrl+shift+enter)



On Fri, Feb 18, 2011 at 9:17 AM, ashish koul  wrote:

> send a mail on excel-macros@googlegroups.com and attach the workbook
>
> On Fri, Feb 18, 2011 at 5:43 AM, RFisher  wrote:
>
>> Hi Ashish,
>>  Sorry I'm really new to google groups. How do I "send" the sample
>> workbook? Can I post it here somewhere?
>> Thanks and sorry to ask so many questions.
>> Ryan
>>
>> On Feb 16, 8:19 pm, ashish koul  wrote:
>> > can you please send  the sample workbook
>> >
>> >
>> >
>> >
>> >
>> > On Thu, Feb 17, 2011 at 3:03 AM, RFisher  wrote:
>> > > Hi everyone,
>> > >  It's great to find a list with such a helpful group. I have a
>> > > question. I received some recent weather data (precipitation in mm)
>> > > for weather stations in Canada; however, the file isn't quite
>> > > formatted for how I need it in order to analyse it. The excel file is
>> > > formatting like the following (Station ID is the identification number
>> > > for the station, year is the year the measurements were made, month is
>> > > the month (1-12), decimals is a constant column, and the Day1-Day31
>> > > are maximum precipitation on each day of the month (see following data
>> > > outline):
>> > > StationID YearMonth Decimals Day1   Day 2   Day3
>> > > Day4Day 31
>> > > 23056  2003  13 0
>> > > 12.2 13   7   10
>> > > 23056  2003  23 1
>> > > 5   12 0.6  20
>> >
>> > > There are unfortunately several thousand rows and I need the table to
>> > > look like the following:
>> > > StationID Year   Month  Decimals DayPrecip
>> > > 23056  20031 3   10
>> > > 23056  20031 3   2   12.2
>> > > 23056  20031 3   313
>> > > 23056  20031 3   4 7
>> > > ...
>> > > 23056  2003 13   31   10
>> > > 23056  2003 231 1
>> > > etc
>> >
>> > > Note that there are several different stations, over 7 years and for
>> > > all months (January to December).
>> >
>> > > Thanks for any help. I hope that's enough information that you might
>> > > be able to provide a way to this automatically with a macro or some
>> > > other excel functions.
>> > > Thanks!
>> > > Ryan
>> >
>> > > --
>> >
>> > >
>> ------
>> > > 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.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks athttp://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 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> > P Before printing, think about the environment.- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> --
>>
>> --
>> 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 
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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

$$Excel-Macros$$ Insert Column

2011-02-18 Thread Sayyad1284

Helllo Experts,

I have a situation as follows,

my data is distributed in coloumns , represnts weeknumbers as

8 9 10 11 .. 52

some times if there are no values for a particular weeks then the
data will look as

8 13 14 15 16

what i want is is there are gaps in weeks so the I need to insert no.
columns in between ,

for e.g. if there is 8 & next number is 13 , the program should add 4
columns ..

this needs to be done through out the range where ever there are no
consecutive weeks


Need your suggestions

-- 
--
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$$ Nedd help with product distribution in production plan

2011-02-18 Thread pawel lupinski

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 



  

-- 
--
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


scheduling.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

$$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

$$Excel-Macros$$ how i convert pdf file to Excel using macro.

Re: $$Excel-Macros$$ Excel Formula Help

$$Excel-Macros$$ Help needed to extract data by MM/Year

RE: $$Excel-Macros$$ Help, please, with debugging a function

Re: $$Excel-Macros$$ Special Suffix Identification

Re: $$Excel-Macros$$ Insert Column

Re: $$Excel-Macros$$ Nedd help with product distribution in production plan

$$Excel-Macros$$ Help, please, with debugging a function

RE: $$Excel-Macros$$ Special Suffix Identification

RE: $$Excel-Macros$$ Special Suffix Identification

Re: $$Excel-Macros$$ Query

Re: $$Excel-Macros$$ Special Suffix Identification

Re: $$Excel-Macros$$ Special Suffix Identification

$$Excel-Macros$$ Special Suffix Identification

Re: $$Excel-Macros$$ HELP SOS

Re: $$Excel-Macros$$ Please Help

Re: $$Excel-Macros$$ Import .csv & match records

$$Excel-Macros$$ Excel Formula Help

$$Excel-Macros$$ Re: Please Help

Re: $$Excel-Macros$$ Insert Column

Re: $$Excel-Macros$$ HELP SOS

$$Excel-Macros$$ HELP SOS

Re: $$Excel-Macros$$ RE: Excel graphs and formula for adding time spent

Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations

$$Excel-Macros$$ Please Help

Re: $$Excel-Macros$$ Nedd help with product distribution in production plan

Re: $$Excel-Macros$$ columns into rows, with a twist

$$Excel-Macros$$ Insert Column

$$Excel-Macros$$ Nedd help with product distribution in production plan

31 matches

Site Navigation

Mail list logo

Footer information