$$Excel-Macros$$ Re: Index and Offset Formula Help

2009-04-22 Thread Suryaprasad.bv
where is it attached..? On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master wrote: > > Hi, > > other possible solution is attached. Using offset and Array formula. > > > Fabio > > > > > > --~--~-~--~~~---~--~~

$$Excel-Macros$$ making rows into colums

2009-04-22 Thread gabo
I have a spreadsheet where I need to combine some rows into columns. Listed below is an example of the spreadsheet. Cust Id Name Item Qty 1 Joe table 1 1 Joe Chair2 2 Sam table1

$$Excel-Macros$$ Re: Conditional Formats on Cells

2009-04-22 Thread Sam K
Hi Why dont you try excel 2007 in that you can you use lol :) On Tue, Apr 21, 2009 at 6:26 PM, Steve wrote: > > Hi, > > Can anyone tell me if there is a limit on the number of conditions you > can place on a cell? I've got 5 and actually need 6, however, when I > select apply, the last conditi

$$Excel-Macros$$ Re: Filter Pivots

2009-04-22 Thread Fabio_XL_Master
Hi, It's possible using macros: Public Sub AplicaFiltros() Dim auxWks As Worksheet Dim auxPivot As PivotTable On Error GoTo AplicaFiltros_ERRO For Each auxWks In ThisWorkbook.Worksheets For Each auxPivot In auxWks.PivotTables 'auxPivot.RefreshTable

$$Excel-Macros$$ Re: Index and Offset Formula Help

2009-04-22 Thread Fabio_XL_Master
Hi, other possible solution is attached. Using offset and Array formula. Fabio --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video an

$$Excel-Macros$$ Re: Calculation of FDR Interest

2009-04-22 Thread Roopesh Kapur
You are more than welcome mate, pls share the outcome. Rgds, Roopesh Kapur _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sergio Abadesso Sent: Wednesday, April 22, 2009 9:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: C

$$Excel-Macros$$ Re: Calculation of FDR Interest

2009-04-22 Thread Sergio Abadesso
Hello Roopesh, thanks for your positive feedback and your plenty of ideas for improvement. I will defenitly work on a full-fledged solution. In the next step I will put in all your recommendations and will post a new Version in the next days. Thanks and regards, Sergio 2009/4/22 Roopesh Kapur

$$Excel-Macros$$ Re: Go to new row after column X

2009-04-22 Thread Paul Schreiner
What your "new" code is doing is very similar to what I gave you. the primary difference is that mine was using absolute column value, for the destination (goto next row, first column) theirs is calculating the number of rows and columns to move relative to the current position. Offset (1) row pos

$$Excel-Macros$$ Re: Go to new row after column X

2009-04-22 Thread lucahk
Dear Paul, thank you very much for your reply and your help ! :) I am also happy you think what I am doing is cool, eheh ! I have several excel files, one for each product I have to check. Each file I only use 1 sheet. Your assumption that I know nothing about VBA is totally correct, and I thank y

$$Excel-Macros$$ Code for copying a picture from excel to word

2009-04-22 Thread Ajay Varshney
HI, I have copied a pdf picture to an excel file. Now I want that picture to be copied from excel into the word file by using VBA. Macro could be written in Excel or Word. Can somebody help me with the code for this. I have copied the picture from pdf to excel manually. If somebody has code fo

$$Excel-Macros$$ Re: Go to new row after column X

2009-04-22 Thread Paul Schreiner
Interesting... really cool too.. Is this Excel file one that you use all the time? or is it new each time? all on the same sheet? or new sheets? How much do you know about programming in Excel VBA? I'm rather than wait for 3-4 emails, I'm going to "assume" that you don't know VBA... you'll have

$$Excel-Macros$$ Re: Calculation of FDR Interest

2009-04-22 Thread Sergio Abadesso
Hi Shafiq, I always tried to attach the files through the group Window because I didn't know that it is possible to write an answer through E-Mail. It works fine now! Thank you! Regards, Sergio 2009/4/22 shafiq online > > Attached file and send it through email.what the problem ! > >

$$Excel-Macros$$ Re: Select range -- VVIMP

2009-04-22 Thread H Upadhyay
Dear Paul, Thanks a lot, Regards Harish Upadhyay 9773284902 On 4/21/09, Paul Schreiner wrote: > > I may not understand all of your criteria, but I can get you started. > Excel has "events". > the one you want is the Worksheet_SelectionChange event. > Right-click on the sheet1 tab and selec

$$Excel-Macros$$ Go to new row after column X

2009-04-22 Thread lucahk
Dear all, I have a problem I would like if some of you could please help me solve. I use a digital caliper to measure some parts and check their quality. Each part I take several measures (diameters, height, thickness,...); let say one object needs to be measured in 5 different points. I have a

$$Excel-Macros$$ Re: Calculation of FDR Interest

2009-04-22 Thread shafiq online
Attached file and send it through email.what the problem ! > Date: Tue, 21 Apr 2009 01:34:32 -0700 > Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest > From: groups.abade...@googlemail.com > To: excel-macros@googlegroups.com > > > Hello Ashish, > > I am working on a soluti