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

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

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

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 co

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

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

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

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 pe

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

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

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

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 ma

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

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

Re: $$Excel-Macros$$ Insert Column

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

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

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

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

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

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

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

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

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 F

Re: $$Excel-Macros$$ Query

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,"Doubt

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

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

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 VB

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

Re: $$Excel-Macros$$ HELP SOS

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

Re: $$Excel-Macros$$ Please Help

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

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

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 s

$$Excel-Macros$$ Excel Formula Help

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 bo

$$Excel-Macros$$ Re: Please Help

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:

Re: $$Excel-Macros$$ Insert Column

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,

Re: $$Excel-Macros$$ HELP SOS

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 quest

$$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. J

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

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

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

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

$$Excel-Macros$$ Please Help

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.

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,

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

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

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

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

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