$$Excel-Macros$$ Email with Picture in existing Macro

ue End If End If Next FileCell .Send 'Or use .Display End With Set OutMail = Nothing End If Next cell Set OutApp = Nothing With Application .EnableEvents = True

Re: $$Excel-Macros$$ Create a Pivot based on Another Pivot

D VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macro

Re: $$Excel-Macros$$ Macro send different files to different recipients

Hi, Any update on this? Do I need to run/duplicate this macro for each email? also strangely If I run the macro, I then start receiving duplicate emails in my email box, do I need to activate/deactivate something? Thank you very much in advance, jorge On 16 March 2016 at 13:01, Jorge Marques

Re: $$Excel-Macros$$ Macro send different files to different recipients

> Application.DisplayAlerts = True > If (Err.Number = 0) Then > Send_Mail = True > Else > Send_Mail = False > End If > > Application.DisplayAlerts = True > > End Function > *Paul* > - > > &

Re: $$Excel-Macros$$ Macro send different files to different recipients

you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Tuesday, March 15, 2016 11:28 AM, Jorge Marques &g

$$Excel-Macros$$ Macro send different files to different recipients

attached to an email separately from each and sent to u...@company1.com Report 2 sent to u...@company2.com So 4 reports, 4 emails sent separately but same text (subject, description) A 1000 thanks in advance :). -- Best Regards, Jorge Marques -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ SQL Queriies in Excel sheets

..@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Best Regards, Jorge Marques -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Extract data in worksheet in xml format to another sheet

Hi guys I have an excel that has 44800 lines(I have a xml that I insert in the excel), it is inventory information, my doubt is How can I copy the lines that start with https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Opening only file in folder

quot;\Logi Macro Project\VEEE\week_to_date-export.xls" Set oWSHShell = Nothing Workbooks.Open Filename:=OpenFile It will be filename "monthly report" and inside will only be one file. Is is possible to have Macro to open that only file in the folder? Thank you -- Best Regards, Jorge

Re: $$Excel-Macros$$ Help Opening in folder using general path

ry this > > Sub tes() > Dim oWSHShell As Object, OpenFile As String > > Set oWSHShell = CreateObject("WScript.Shell") > OpenFile = oWSHShell.SpecialFolders("Desktop") & > "\data_source\week_to_date-export.xls" > Set oWSHShell

$$Excel-Macros$$ Help Opening in folder using general path

t.xls" how can I change this to everyone, to open the excel in their computer without always have to change the user when I provide the excel? Like a sort of C:\...\Desktop\data_source\week_to_date-export.xls? thank you very much -- Best Regards, Jorge Marques -- Are you

Re: $$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

d With > Range("B5").Select > > With ActiveSheet.PivotTables("PivotTable1").PivotFields("ASIN") > .Orientation = xlColumnField > .Position = 1 > End With > Range("B6").Select > > With ActiveShe

$$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

les("PivotTable1").PivotFields("FC") .Orientation = xlColumnField .Position = 1 End With With ActiveSheet.PivotTables("PivotTable1") .ColumnGrand = False .RowGrand = False End With -- Best Regards, Jorge Marques -- Are you =E

Re: $$Excel-Macros$$ Help delete rows with dynamic worksheets

reenUpdating = True > Application.DisplayAlerts = True > Application.Calculation = xlCalculationAutomatic > End Sub > > > > On Thu, Jun 6, 2013 at 6:21 PM, Jorge Marques wrote: > >> Hi guys, >> >> I have a file that has 4 worksheets A,B,C,D and eveyrone has 3 columns >>

$$Excel-Macros$$ Help delete rows with dynamic worksheets

the file with only A worksheet or A & B, so it varies and my macro gives an error, is it possible to the macro to check if the 4 columns exist and delete rows of Columns AGE with blank cells? Thank you very much. -- Best Regards, Jorge Marques -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc

Re: $$Excel-Macros$$ Macro to take Itens from Inventory sheet that don't exist in Sheet Raw Data - my code gives error

lue > Sheets("Raw Data").Range("a65356").End(xlUp).Offset(0, 2).Value = > Sheets("Inventory").Range("e" & i).Value > Sheets("Raw Data").Range("a65356").End(xlUp).Offset(0, 3).Value = > Sheets("Inventory").

$$Excel-Macros$$ Macro to take Itens from Inventory sheet that don't exist in Sheet Raw Data - my code gives error

Selection.Copy Sheets("Raw Data").Select Cells(1, 1).Select Selection.End(xlDown).Offset(1, 0).Select ActiveSheet.Paste End If End Sub If possible to pass the columns E from sheet Inventory to D in Raw data, and columns H to columns E. Thank you very much. -- Best Regar

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

om it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/gro

Re: $$Excel-Macros$$ Pivot data to different worksheets

It works like a charm Paul, thanks a million :). JM On 15 May 2013 11:57, Jorge Marques wrote: > Hi Paul, > > I take it that your "Column Labels" in row 2 are to be the sheet names? > Then you want to copy the data in each column to that sheet? > > Yes everything c

Re: $$Excel-Macros$$ Pivot data to different worksheets

-- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Jorge Marques >

$$Excel-Macros$$ Pivot data to different worksheets

ng, it can 5, 6, 10, depends on the, how can I copy each column to a new worksheet until the number of columns ends? Thanks a million guys. -- Best Regards, Jorge Marques -- 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 pa

Re: $$Excel-Macros$$ What is Ylookup in Excel...

; You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send em

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi all Excelers, Jorge Marques from Portugal, work in a Logistic Company and Excel is now part of my life, my learning curve in VBA is improving alot since I discovered this group, also use chandoo.org because it has some awesome stuff, regarding formulas and Charts. In my spare time I´m learning

Re: $$Excel-Macros$$ Google Map and Excel Integration Using VBA

1001 congratulations Ashish, this is amazing, Excel is every more powerful than I thought :), Ashish, is it possible to also import this information to the excel? [image: Inline images 1] On 20 October 2012 07:49, Ashish Bhalara wrote: > THank you very much Mr. Ashish Koul, its very useful and

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi, I´m sorry to be writing in this post, but I don´t think it is necessary to open a new post, because I have the same problem but my mail is between <>, I can I extract this? thanks On 28 August 2012 14:53, vijayajith VA wrote: > Hi Zibrean,, > > Please use below formula > > =TRIM(RIGHT(SUBSTI

Re: $$Excel-Macros$$ Alternative to OR condition

all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:*

Re: $$Excel-Macros$$ Alternative to OR condition

m>noorainansari.com<http://www.noorainansari.com> > http:// <http://www.excelvbaclinic.blogspot.com> > excelvbaclinic.blogspot.com <http://www.excelvbaclinic.blogspot.com> > http://accesssqclinic.blogspot.in/ > > > On Tue, Jul 31, 2012 at 5:11 PM, Jorge Marques wrot

Re: $$Excel-Macros$$ Alternative to OR condition

t 3:50 PM, Hilary Lomotey wrote: >> >>> Thnks Marques, but not sure i follow your suggestion, can you be more >>> explicit. thanks >>> >>> >>> On Tue, Jul 31, 2012 at 10:06 AM, Jorge Marques wrote: >>> >>>> Do you the C4 to CX

Re: $$Excel-Macros$$ Alternative to OR condition

Do you the C4 to CX if it founds the value on column A it returns D1 else if the C4 to Cx isn´t on column A returns E1? 2012/7/31 Hilary Lomotey > Hello Experts > > is there another way to write an OR formula . Example, i want to exempt > some people from say tax, so i list them and write a form

Re: $$Excel-Macros$$ Turning a if macro to a select case macro

Case Else > 'Do Nothing > End Select > > Regards, > Sam Mathai Chacko > > > On Fri, Jul 27, 2012 at 7:27 PM, Jorge Marques wrote: > >> Hi, >> Ok I looked in several forums none explained, I only noticed then the >> code onl

$$Excel-Macros$$ Turning a if macro to a select case macro

Hi guys, can anybody help me turning this If macro to an case macro. Sub friday() For i = 1 To 200 For j = 1 To 200 If Cells(2, j).Value = "sexta-feira" And Cells(i, 1).Value = 512 Or Cells(2, j).Value = "sexta-feira" And Cells(i, 1).Value = 513 Or Cells(2, j).Value = "sexta-feira" And Cells(i,

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

Hi Asa, just to give a feedback on this, it was very good, perfect solution. thank you very much. 2012/7/6 Jorge Marques > Hi Asa, > > Thank you very much for your help. This weekend I will analyze your > solution, many thanks in advance for your time and support, I expect t

$$Excel-Macros$$ Sum on 2 conditions(one in column one in row) to another cell

Hi guys I have a report which I downloaded from crystal report to excel,, choosing the dates and then compiling the report to excel. I´m trying to do a Macro which has to go to 3 conditions and then sum to another column segunda-feira terça-feira quarta-feira quinta-feira sexta-feira segunda-

Re: $$Excel-Macros$$ Can´t get around a macro

ys of the past month and so the vlookup to "clear" the colors and start from 1 again Any suggestion to a more precise and clean code? thank you 2012/7/12 Jorge Marques > Hi guys, > > I have this macro I´ve made with a vlookup that one of you kindly help, I > then developed a ma

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

e formulas for the error values you specified. > > ** ** > > Hopefully this gets you going. I recommend double-checking my logic. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Beha

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

(below the first range or above the last range) > > ** smaller than 1 "error", bigger than 100 should give "ask for budget", > if you wish i can put here my if formulas that i used for one transporter. > ** > > Asa > > ** ** > > *From:* excel-macros@g

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

same > formula) and Excel will return the intersection of that row and column, > which will be a single matching cell. > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behal

$$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

Hi guys i have a sheet where I every month i calculate the costs for logistics, there are 3 conditions (KM, Weight in KG, and Volumes), where i have to calculate depending on the data put in the columns B,C,D if it is zone 1,2,3 and has the volumes or weight under those limits it puts those values

Re: $$Excel-Macros$$ Help on Changing code on Color Macro

excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Jorge Marques > *Sent:* 02 May 2012 15:36 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Help on Changing code on Color Macro > > ** ** > > Hi guys, i have this Mac

Re: $$Excel-Macros$$ Help on Changing code on Color Macro

2012/5/3 Jorge Marques > Yes Rajan you´re absolutely right, thank you very much, it was supposed > to be the excel in the ppt, > > I was thinking, instead of putting Green on "Não" and Red "Sim" can´t we > do the macro to put Green whenever the day is = Toda

Re: $$Excel-Macros$$ Email Sheet with message

Talal, i´m also a beginner, i´m using some books, but i haven´t found any extensive one in VBA, i use recording methods to see what the code performs, and use other posts to see what it returns in the excel provided, it has helped me a lot improving my skills, i notice that i not still able to buil

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Perfect, I wasn´t aware of that. Thank you very much. 2012/2/29 dguillett1 > range uses Range9(“a1:z21”) > cells uses cells(1,1) or cells(1,”a”) for Row first and column second. > result is the same > > Don Guillett > SalesAid Software > dguille...@gmail.com >

Re: $$Excel-Macros$$ Formula not working

;compact" to your way in order to be more stable? 2012/2/29 xlstime > =IF(AND(AND(A2>=126,A2<=375),(B2>=500)),10,0) > > > > > On Wed, Feb 29, 2012 at 10:57 PM, Jorge Marques wrote: > >> Hi guys, i don´t know, how is this, my formula is wrong, if i change the &g

$$Excel-Macros$$ Formula not working

Hi guys, i don´t know, how is this, my formula is wrong, if i change the weight beyond the limits it keeps giving 10. how can i change this, i think it´s simple, but i´m not finding a solution. Thank you -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

testing >> >> For i = Cells(Rows.Count, "Z").End(xlUp).Row To 2 Step -1 >> If Cells(i + 1, "Z") = Cells(i, "Z") Then >> >> Sam >> >> >> On Wed, Feb 29, 2012 at 4:41 PM, Jorge Marques wrote: >> >>> Sorry

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

, how can i turn this around, is it done in the code line: If Cells(i + 1, 1) = Cells(i, 1) do i have to change the 1 to the correspondent Column of Z? Thank you again :). 2012/2/22 dguillett1 > Glad to help > > Don Guillett > SalesAid Software > dguille...@gmail.com > >

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

gmail.com > > *From:* Aamir Shahzad > *Sent:* Monday, February 20, 2012 11:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and > counting > > Dear Jorge, > > See the third table in attached sheet. >

$$Excel-Macros$$ Help on gathering duplicate summing and counting

Hi friends, i have a problem, 1. i trying to use a report and i have to sum the column H, G, F, if the orders numbers are equal and 2. leave the information in column B,C,D, gathered. 3. The problem is that i was doing it with formulas, but didn´t have a dinamic range that´s the first, 4. then the

$$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column

Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, 2012, the problem is that i need to compare days, like if i choose to see day 10 January of 2012 with the 2011, i must compare the same number of cells with values, so it has to compare 11 january 2011 that has 7 numbered sums

Re: $$Excel-Macros$$

Can you explain what you need exactly? 2011/10/29 hanna habiel > Dear All, > > good day for all , > > i need your help for the attached file > > thanks > hanna > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ How to learn vba

Hi friend, I use a lot this simple example of a loop until with an inputbox. 2011/10/21 NOORAIN ANSARI > Dear sandeep/Mr. excel, > > Please find attached Sheet with Example. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Need Urgent help

well friend i´m learning by recording and then studying the code, there are many books, but i don´t like them very much, too much writing confuses, i prefer to see "live" excel and study them and test them, i find very useful, Ashish Koul blog and twitter, it´s being very useful to my learning, mos

$$Excel-Macros$$ Help on inputbox

Hi friends i have an issue, i use this do loop to fill cells with a certain text, how i want to choose what i put in "Month i want" and write in columns C until C reaches the value "total", what i pretend is a inputbox where i choose what to write. i think i have to use dim as integer and them de

Re: $$Excel-Macros$$ Help required on Importing Data

if your data format doesn´t change i recomend using links, i use links for a database which doesn´t change the format, but i have another database i have to add new data every month which is always changing values and cells, for that i use a copy paste macro which copies all the data by selecting c

Re: $$Excel-Macros$$ Please explain about loop

Are you refering to loop while,or loop until? 2011/7/25 neil johnson > Hi All, > > Please explain loop with real example in sheets . much appreciated if you > will provide attached sheet with example of loop . > > Thanks > > -- > >

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

ps.com] *On Behalf Of *Jorge Marques > *Sent:* Thursday, July 21, 2011 10:44 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving > same error > > ** ** > > Hi guys, i have this macro i use to copy a range fr

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Yes, the names are all ok, i double checked it, even try to change names, but doesn´t work :S 2011/7/21 Anish Shrivastava > Please check if the sheet name is "Pivot". > if not then rename it to Pivot. > On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote: > >>

$$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Hi guys, i have this macro i use to copy a range from column D of a worksheet of a workbook to column G of another workbook and worksheet, but it keeps giving me the same error saying that it´s "subscript out of range" in the line in yellow. Public wb, wbmes As Workbook Sub filldatabase() Call Abr

Re: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work

gt; Do Until Cells(i, 2).Value = "Total" > Cells(i, 1).Value = "2010 Real" > i = i + 1 > Loop > End Sub > > > On Thu, Jul 14, 2011 at 5:39 AM, Jorge Marques wrote: > >> Hi guys, i have this table where i want to fill the column A with "2010 >

$$Excel-Macros$$ Help My "Do Loop" statement doesn´t work

Hi guys, i have this table where i want to fill the column A with "2010 Real" but stopping when in the same row the column B is "Total" i used Do & Loop but i can´t seem to find the right code. sub fill2010real() Do until range("B:B").value = "Total" range("A:A").value = "2010 Real" loop end sub

Re: $$Excel-Macros$$ HELP urgent

Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire row that has the negative numbers like this, or do you want it to copy to another column the year and negative value? Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009 20 2011 29

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

in the formula > > > On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques wrote: > >> Hi guys, i have a pivot table that is feeded through another workbook, >> then i calculate the rest of the pivot with the option "Calculated fields" >> but i have a problem, each t

$$Excel-Macros$$ Help what the hell is wrong with my pivot table?

Hi guys, i have a pivot table that is feeded through another workbook, then i calculate the rest of the pivot with the option "Calculated fields" but i have a problem, each time i open the 2 workbooks and make refresh, my calculated fields disappear leaving "#NAME" in the cells, and i have to do th

Re: $$Excel-Macros$$ Help Formating a dynamic table just some cells

.LineStyle = xlcontinous .ColorIndex = 0 .TintAndShade = 0 .Weight = xlThin End With End Sub 2011/6/27 Vasant > did u try > > Range("A1048576").end(xlup).row '-- to get the last populated row in > column A > > > On Mon, Jun 27, 2011

Re: $$Excel-Macros$$ PDF File

Mmm i have a doubt?is this trustable?if you have important company documents that you have to put in excel format? 2011/6/16 saggi > Yeah this is very useful siten quick tooo > > -- > > -- > Some important links

$$Excel-Macros$$ Help Formating a dynamic table just some cells

Hi guys i need your expertise, i have this macro and i need your advise, i just need to format the excel like i put in the example to format the cells with line upperlines around all data and only in the cells filled in column A. this is my code so far, i know to macro it, but the format of table k

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

Hi friend, i think you have to go to File > Info and then at your right there is Properties > Advanced Properties (i don´t know if these are the exact names, my excel is in portuguese). See if it helps, cheers 2011/6/4 Anil Bhange > Hi All, > > > > I am still facing problem, there is no Proper

Re: $$Excel-Macros$$ Help on macro to next empty worksheet to another workbook

Worksheets > If ws.UsedRange.Cells.Count < 1 Then ws.Delete > Next ws > Application.DisplayAlerts = True > Set ws = Worksheets.Add(After:=Sheets(Sheets.Count)) > 'ws.Name = ActiveSheet.Name > With ws > ws.Range("A1").PasteSpecial Paste:=xlPasteValues > En

$$Excel-Macros$$ Help on macro to next empty worksheet to another workbook

Hi guys i have this macro to copy paste sheets to another sheet on another workbook, can you help me?i need everytime i run the macro to paste it to the next blank worksheet of the destiny workbook. 1001 thanks in advance Sub copy_another_sheet() ' ' copy Macro ' ' Atalho por teclado: Ctrl+p '

$$Excel-Macros$$ fixing Format of pivot table noit working

Hi guys is there anyway to format a pivot table and it´s stays that way whether i insert or take the options from and columns labels and row labels because when i change the design of the pivot it put´s everything back to standard like Sum of Jan instead of Jan like i what i tried to do with a mac

Re: $$Excel-Macros$$ Fwd: Help on my solution, can´t seem to dynamic the pivot table with month macro

Found the solution by testing and using Excel help, thank you very though 2011/4/7 Jorge Marques > Hi guys i did a pivot table with a macro where i have to put the info each > month, in order to the pivot to refresh i did Ctrl + T to "table" the pivot > with headers in order

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

Congratulations Ashish especially for your help and also to this forum, i have to say my learnings in macro are exponential since this was created, i was a zero at the beginning! 2011/4/6 Aindril De > Congrats Ashish!! Keep up the good work!! Cheers > Andy > > > On Wed, Apr 6, 2011 at 3:21 PM, N

Re: $$Excel-Macros$$ copy macro error

Ohh thank you very much :) 2011/4/6 ashish koul > try this > > Sub Datacopy() > > > Sheets("teste").Range(Sheets("teste").Cells(1, 1), > Sheets("teste").Cells(Sheets("teste").Range("a65356").End(xlUp).Row, > 3)).Copy > > > With Sheets("destino") > .Cells(Sheets("destino").Range("a6

$$Excel-Macros$$ copy macro error

Hi, can someone please tell what i did wrong, this is my first macro all by myself, but it gives me a error, i made a macro where i what to copy sheet "teste" to sheet "destino" but without range, so that when i introduce new values to column A,B,C and execute the macro it copys all values to desti

Re: $$Excel-Macros$$ Help on condition and return value

FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND(" > ",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,"")) > > --- > Ms.Exl.Learner > --- > > > On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques wrote: > >> Hi guys,

Re: $$Excel-Macros$$ Help on a simple question

formulas, but it turned out to be a total mess. :) 2011/3/27 Susan > You could try Power Pivot to merge and sort your various files into one > pivot table or chart. > > > > ~Susan > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.

$$Excel-Macros$$ Help on condition and return value

Hi guys, is there any way i can do to for example if a cell B2 has the following text "phillips LCD 32"" it returns philips to cell B1 but without extracting the character on the left, because if it gives me a OEM brand, i have to put the information corresponding by vendor and not brand. thx --

Re: $$Excel-Macros$$ Help on a simple question

Thousands sorry ashish koul, this was a draft mail i sent by mistake, it was previous to "$$Excel-Macros$$ Help on merging certain sheets to final workbook" > can you send the sample file of three reports with headers and final > output > > > > On Thu, Mar 10, 20

$$Excel-Macros$$ Help on pivot table

Hi, is it possible to do a pivot table of these workbook, but merging the 3 worksheets?the problem is that column C of the 3 worksheets are different and can´t be mixed if i choose for example Values of january, my first thought is like sheet4 but there i have to take the blanks manually and be car

$$Excel-Macros$$ Help on a simple question

in a separate folder and link them tom the pivot, will it be ok?. Thank you very much, Best Regards, Jorge Marques -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Re: very urgent

Here you have a simple pivot table excel. just play a little with the pivot table field list to undestand the concept. 2011/3/8 Jim > Hello, > I'm assuming that you are trying to understand pivot tables. There > are some great videos on www.youtube.com. > > Search for: excel pivot table >

Re: $$Excel-Macros$$ Help on merging certain sheets to final workbook

Ah, how can i stop a macro from copying a sheet to another if the difference there´s more than 3 blank cells in a row? 2011/3/7 Jorge Marques > Hi, i need your help friends, > in a earlier post we defined a merge from differents books to a single > workbook, it excellent, i have a doub

$$Excel-Macros$$ Help on merging certain sheets to final workbook

Hi, i need your help friends, in a earlier post we defined a merge from differents books to a single workbook, it excellent, i have a doubt, i have 3 workbooks i have to merge, that i want to copy in this conditions? workbook1 - copy only sheet2 but only this range of cells W4:W109 X4:X109 AR4..

Re: $$Excel-Macros$$ Fwd: Help on formula

Oh yes, thank you very much both you, it´s excellent, the more it´s simplified the better, i put in a formula with various conditions!1000 thanks :) 2011/3/7 OpenExcel.com > Hi Jorge, > > > If you want to further reduce your formula size, you can use > =IF(((P3>T3)+(Q3>U3)+(R3>V3)+(S3>W3))>=2,T

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

You want to pass the values to sheet2 like it is in there right A Total etc and then each time there´s a new costumer besides the one that are there already there, it automatically inserts the new costumer in sheet2 with same criterias? 2011/3/5 San Pat > Hi Friends, > > I have row data in th

Re: $$Excel-Macros$$ Fwd: Help on formula

gt;W3,1,0)>=2,true,false) > > Paul > > ------ > *From:* Jorge Marques > *To:* excel-macros@googlegroups.com > *Sent:* Thu, March 3, 2011 4:39:26 AM > *Subject:* $$Excel-Macros$$ Fwd: Help on formula > > Hi guys i need a help on a formula or at

$$Excel-Macros$$ Fwd: Help on formula

Hi guys i need a help on a formula or at least a way to change what i was thinking with a formula or macro i have two years that i have to compare, 2009 and 2010, they are in quarters(Q1,Q2;Q3,Q4) i made a formula that gives true or false under this condition if at least 2 of 4 quarters of 2010

$$Excel-Macros$$ Help on formula

Hi guys i need a help on a formula or at least a way to change what i was thinking with a formula or macro i have two years that i have to compare, 2009 and 2010, they are in quarters(Q1,Q2;Q3,Q4) i made a formula that gives true or false under this condition if at least 2 of 4 quarters of 2010

Re: $$Excel-Macros$$ Group Survey : Your feedback is important.

Is it online the survey? it appears in my screen "Thank you for taking the survey." when i click the link 2011/2/26 Ayush > Dear members, > > Thanks for all your contribution to group. I am very happy to see the great > engagement in the group. > > For me its very important to know what you fe

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

A cell but i was > wondering if there´s a tool ou way to do this! > > 2011/2/12 Paul Schreiner > >> I'm not sure what you mean by "the last A goes to the first B". >> >> Can you give an example? >> >> Paul >> >> ---

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

> I'm not sure what you mean by "the last A goes to the first B". > > Can you give an example? > > Paul > > ------ > *From:* Jorge Marques > *To:* excel-macros@googlegroups.com > *Sent:* Sat, February 12, 2011 9:47:21 AM > >

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

= Split(Range("A" & R).Value, ";") > *For C = 0 To UBound(StrArray) > *Cells(R, C + 1).Value = StrArray(C) > * Next C > Next R > Application.ScreenUpdating = True > > and it worked almost instantaneously instead of all the > screen &

$$Excel-Macros$$ Macro issue passing values from Cell to columns

Hi, i have a macro i´ve done, but it it has a problem, when it passes the data from cells A to various columns it stops no cell 20 in the sheet2 e the another stops at another cell number, i have the file attached here with the code below, can´t seem to discover the error, taking baby steps at this

$$Excel-Macros$$ Counting words or letters

Hi, is there anyway of counting words ou letters in a specific cell?thank you very much -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

Re: $$Excel-Macros$$ Sales Dashboard

I agree with Shahina, you should show more number informations, but in a esthetic way i prefer the second one, but brighten a little the colors! Regards, Jorge 2011/1/20 shannu shannu > not good, u r showcasing more data in charts and diagrams an dnot in > numbers. > > Regards, > Shahina > > -

Re: $$Excel-Macros$$ Macro with condition

It´s excellent, this will do fine! thank you very much Manoj :) 2011/1/5 Manoj kumar > Hi, > > Though not a macro... but still works the same...pls chk the attached > > > Regards, > Manoj Kumar > > > On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques wrote: > >>

$$Excel-Macros$$ Macro with condition

Hi guys, i´m need your help, i have a list of brands, that i need to put values of sales of the various shops , from cell B2:B15, and i need that when i select a brand from cell B1 it will copy automatically the value from cell B16 to the cells from D2 to K2, example, if i select "Adidas" it will c

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

ction.Copy > Sheets("Folha2").Select > Range("a1").Select > Sheets("Folha1").AutoFilter.Range.Copy Sheets("Folha2").Range("A1") > > > If Sheets("Folha1").FilterMode Then > Sheets("Folha1").ShowAllData &g

$$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

Hi guys i need badly your help, i want to copy the information of the range of cells from A7:G11 if the condition is true, in this case i want it to copy the information of the rows 8 and 10 to sheet number 2, thank you very much in advance, i put in anex an example of what i need. Jorge -- ---

Re: $$Excel-Macros$$ Excel 2007 to 2003

Can´t you install the compatibility pack? 2010/11/2 sachin83_1...@yahoo.com > hey friends, i need to knw is there any shortcut or key to convert > Excel 2007 to 2003 n vise versa, pls help me out > > -- > > -- >

  1   2   >