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

[Jorge Marques]

Hi guys,

I have the following macro below, I tried searching in internet, but cannot
find a way to put there. I would like to add a embed a picture to the
email, like always same picture (can located in a folder in my computer),
the goal is to be like sort of signature.

Sub SendEmailFile()

Dim OutApp As Object
Dim OutMail As Object
Dim sh As Worksheet
Dim cell As Range
Dim FileCell As Range
Dim rng As Range

With Application
.EnableEvents = False
.ScreenUpdating = False
End With

Set sh = Sheets("Contact List")

Set OutApp = CreateObject("Outlook.Application")

For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)

'Enter the path/file names in the C:Z column in each row
Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")

If cell.Value Like "?*@?*.?*" And _
   Application.WorksheetFunction.CountA(rng) > 0 Then
Set OutMail = OutApp.CreateItem(0)

With OutMail
.to = cell.Value
.Subject = "Monthly Customer Report"
.Body = "Dear " & cell.Offset(0, -1).Value & vbNewLine &
vbNewLine & "Thank you for contacting Vobbe" & vbNewLine & vbNewLine &
"Please find attached your daily digest" & vbNewLine & vbNewLine & "Thank
you" & vbNewLine & vbNewLine & "Kind Regards,"

For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Value
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
.ScreenUpdating = True
End With
End Sub



Thank you veru much in advance.
-- 
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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[Jorge Marques]

Hi,
I create pivot based on another pivot by using source range A:Z for
example, the thing is that in the filter I get then "blanks" but make sure
I cover all data when the pivot source gets updated with new data and
grows.I just then remove the blanks with filter.

Best,
JM

On 15 December 2016 at 00:59, Soumyendu Paul  wrote:

> Hi Experts,
>
> Can we create a pivot based on another pivot?(*Interview Question*)
>
>
> Regards,
> Soumyendu
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 email to excel-macros@googlegroups.com.
> Visit this group at https://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)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[Jorge Marques]

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

> Hi Paul,
> i have the Microsoft Outlook 15.0 Object Library.
>
> The Macros runs fine if I remove the updates and display alerts, if not it
> generates error.
>
> 'Application.ScreenUpdating = False
>  'Application.DisplayAlerts = False
>
> This is great starting point, my challenge now besides the error is how do
> I point 64 emails to 64 reports to 64 separate emails? I know there are not
> miracles but can this be done automatically, and not running the macro
> differently 64x? Or is that defined in the function below?
>
> Thank you very much,
> Jorge
>
>
>
>
>
>
> On 16 March 2016 at 12:28, Paul Schreiner  wrote:
>
>> In VBA, you'll need to include the "Microsoft Outlook 14.0 Object Library
>> "
>> (under Tools->References)
>>
>> then, this VBA code should work:
>> (use your own email addresses for "name@domain")
>> ---
>> Option Explicit
>> Sub Test_Mail()
>> Dim Stat, fso
>> Dim Mail_Addr_To, Mail_Addr_CC, Mail_Subject, Mail_Body, FileName
>>
>> Set fso = CreateObject("Scripting.FileSystemObject")
>> '
>> ' Note: the list of email addresses must be separated by (;)
>> '
>> Mail_Addr_To = "name@domain;name@domain"
>> Mail_Addr_CC = "name@domain"
>> Mail_Subject = "Test Email"
>> Mail_Body = "This is a test email from Outlook"
>> FileName = "C:\temp\TD_Drawings.txt"
>>
>> If (fso.fileexists(FileName)) Then
>> Stat = Send_Mail(Mail_Addr_To, Mail_Addr_CC, Mail_Subject,
>> Mail_Body, FileName)
>> End If
>> End Sub
>> Function Send_Mail(TO_Addr, CC_Addr, MsgSubject, MsgBody, MsgAttachment)
>> Dim I As Long, fso
>> Dim olApp As Outlook.Application
>> Dim olMail As MailItem
>> Dim Stat
>>
>> Application.DisplayAlerts = False
>>
>> Set fso = CreateObject("Scripting.FileSystemObject")
>> Set olApp = New Outlook.Application
>> Set olMail = olApp.CreateItem(olMailItem)
>> Err.Clear
>> Application.ScreenUpdating = False
>> Application.DisplayAlerts = False
>> Err.Clear
>> On Error Resume Next
>>
>> Set olApp = GetObject(, "Outlook.Application")
>>
>> '
>> ' If Outlook is not running, this starts it
>> '
>> If Err.Number <> 0 Then
>> Stat = Shell("outlook.exe ", vbNormalNoFocus)
>> Application.Wait (Now + TimeValue("0:00:04"))
>> Err.Clear
>> Set olApp = GetObject(, "Outlook.Application")
>> If Err.Number <> 0 Then
>> Exit Function
>> End If
>> End If
>> On Error GoTo 0
>> '
>> With olMail
>> .To = TO_Addr
>>  If (CC_Addr & "X" <> "X") Then _
>> .CC = CC_Addr
>> .Subject = MsgSubject
>> .body = MsgBody
>> If ((MsgAttachment & "X" <> "X") _
>> And (fso.fileexists(MsgAttachment))) Then _
>> .Attachments.Add MsgAttachment
>> .Send
>> End With
>>
>> Application.ScreenUpdating = True
>> Application.DisplayAlerts = True
>> If (Err.Number = 0) Then
>> Send_Mail = True
>> Else
>> Send_Mail = False
>> End If
>>
>> Application.DisplayAlerts = True
>>
>> End Function
>> *Paul*
>> -
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> --

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

[Jorge Marques]

Hi Paul,
i have the Microsoft Outlook 15.0 Object Library.

The Macros runs fine if I remove the updates and display alerts, if not it
generates error.

'Application.ScreenUpdating = False
 'Application.DisplayAlerts = False

This is great starting point, my challenge now besides the error is how do
I point 64 emails to 64 reports to 64 separate emails? I know there are not
miracles but can this be done automatically, and not running the macro
differently 64x? Or is that defined in the function below?

Thank you very much,
Jorge






On 16 March 2016 at 12:28, Paul Schreiner  wrote:

> In VBA, you'll need to include the "Microsoft Outlook 14.0 Object Library "
> (under Tools->References)
>
> then, this VBA code should work:
> (use your own email addresses for "name@domain")
> ---
> Option Explicit
> Sub Test_Mail()
> Dim Stat, fso
> Dim Mail_Addr_To, Mail_Addr_CC, Mail_Subject, Mail_Body, FileName
>
> Set fso = CreateObject("Scripting.FileSystemObject")
> '
> ' Note: the list of email addresses must be separated by (;)
> '
> Mail_Addr_To = "name@domain;name@domain"
> Mail_Addr_CC = "name@domain"
> Mail_Subject = "Test Email"
> Mail_Body = "This is a test email from Outlook"
> FileName = "C:\temp\TD_Drawings.txt"
>
> If (fso.fileexists(FileName)) Then
> Stat = Send_Mail(Mail_Addr_To, Mail_Addr_CC, Mail_Subject,
> Mail_Body, FileName)
> End If
> End Sub
> Function Send_Mail(TO_Addr, CC_Addr, MsgSubject, MsgBody, MsgAttachment)
> Dim I As Long, fso
> Dim olApp As Outlook.Application
> Dim olMail As MailItem
> Dim Stat
>
> Application.DisplayAlerts = False
>
> Set fso = CreateObject("Scripting.FileSystemObject")
> Set olApp = New Outlook.Application
> Set olMail = olApp.CreateItem(olMailItem)
> Err.Clear
> Application.ScreenUpdating = False
> Application.DisplayAlerts = False
> Err.Clear
> On Error Resume Next
>
> Set olApp = GetObject(, "Outlook.Application")
>
> '
> ' If Outlook is not running, this starts it
> '
> If Err.Number <> 0 Then
> Stat = Shell("outlook.exe ", vbNormalNoFocus)
> Application.Wait (Now + TimeValue("0:00:04"))
> Err.Clear
> Set olApp = GetObject(, "Outlook.Application")
> If Err.Number <> 0 Then
> Exit Function
> End If
> End If
> On Error GoTo 0
> '
> With olMail
> .To = TO_Addr
>  If (CC_Addr & "X" <> "X") Then _
> .CC = CC_Addr
> .Subject = MsgSubject
> .body = MsgBody
> If ((MsgAttachment & "X" <> "X") _
> And (fso.fileexists(MsgAttachment))) Then _
> .Attachments.Add MsgAttachment
> .Send
> End With
>
> Application.ScreenUpdating = True
> Application.DisplayAlerts = True
> If (Err.Number = 0) Then
> Send_Mail = True
> Else
> Send_Mail = False
> End If
>
> Application.DisplayAlerts = True
>
> End Function
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, March 15, 2016 5:49 PM, Jorge Marques 
> wrote:
>
>
>
> Hi Paul,
> Yes I use Outlook, Having Outlook opened for it to work is not an issue
> for me,  it is always open from the moment computer is on until is shut
> down. Providing the function would be more than helpful :). Thank you very
> much!
>
> Best,
> Jorge
>
> On 15 March 2016 at 19:15, Paul Schreiner  wrote:
>
> First of all, Excel doesn't have email capability.
> What it DOES do, however, is allow you to use your existing email software.
>
> At least somewhat.
>
> What email do you use?
> I use Outlook.
> With that, I can write a function that takes the email address and
> filename as input and creates/sends the appropriate email.
>
> But y

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

[Jorge Marques]

Hi Paul,
Yes I use Outlook, Having Outlook opened for it to work is not an issue for
me,  it is always open from the moment computer is on until is shut down.
Providing the function would be more than helpful :). Thank you very much!

Best,
Jorge

On 15 March 2016 at 19:15, Paul Schreiner  wrote:

> First of all, Excel doesn't have email capability.
> What it DOES do, however, is allow you to use your existing email software.
>
> At least somewhat.
>
> What email do you use?
> I use Outlook.
> With that, I can write a function that takes the email address and
> filename as input and creates/sends the appropriate email.
>
> But you have to have Outlook open for it to work.
>
> I can provide that function if it is helpful.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the 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 
> wrote:
>
>
>
> Hi all,
> I have been searching but haven´t found so far a macro similar to this
> one, the situation point is:
>
> Have one folder: C:\Users\username\Documents\Weekly Report\
>
> With 4 different reports:
>
> Report 1
> Report 2
> Report n...
>
>  for 4 different companies (Reports are the same but for different
> customers)
>
> Then a Email recipient excel with the emails I should send these reports
> every week
>
> Is there a way for me to open the Email Recipient excel run a macro, and
> then it sends 4 different emails with the respective reports attached to
> the respective email recipient?
>
> So Reports  should be 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? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://gr

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

[Jorge Marques]

Hi all,
I have been searching but haven´t found so far a macro similar to this one,
the situation point is:

Have one folder: C:\Users\username\Documents\Weekly Report\

With 4 different reports:

Report 1
Report 2
Report n...

 for 4 different companies (Reports are the same but for different
customers)

Then a Email recipient excel with the emails I should send these reports
every week

Is there a way for me to open the Email Recipient excel run a macro, and
then it sends 4 different emails with the respective reports attached to
the respective email recipient?

So Reports  should be 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? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Email Recipient.xlsx
Description: MS-Excel 2007 spreadsheet

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

[Jorge Marques]

Hi Luciano,
You want to filter sheet1 and return those results to another sheet? Not
sure if SQL can be used for that in Excel, but I use Power query to extract
specific data from a sheet that contains all data by using power query. I
can already select the columns I wish to use and also filter the conditions
then I just deploy it in another sheet!

Best,
Jorge

On 7 December 2015 at 11:40, luciano de souza  wrote:

> Hello all,
>
> This is my first message to the group and I am glad to participate in
> a so rich space.
>
> My first question is about the use of a sheet as a database. Suppose I
> have a sheet with these columns:
>
> Colunm 1: ID
> Colunm 2: Project
> Colunm 3: Activity
> Colunm 4: Task
> Colunm 5: Opened
> Colunm 6: Responsible
> Colunm 7: Status
>
> Reports can be mounted with formulas, but would be possible to use SQL
> to return a query directly from a sheet? Acording to searches in
> Google, the answer is yes. So I could select the active tasks ordering
> by responsible:
>
> select * from sheet1 where status='active' order by responsible;
>
> Microsoft Access seems more appropriate to this kind of task, but the
> knowledge about Access is very small. So I need a solution Excel
> based.
>
> Does someone have some example to solve this kind of problem?
> Which terms should I search to get more information about this topic?
>
> Best regards,
>
>
>
> --
> Luciano de Souza
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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.

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

[Jorge Marques]

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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

Hi guys,

I have this macro to open a excel file in a specific folder, I now want to
do the same in another folder, but the problem is that the file is always
changing name.

Set oWSHShell = CreateObject("WScript.Shell")
OpenFile = oWSHShell.SpecialFolders("Desktop") & "\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 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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

Worked perfectly, thank you very much.


On 1 August 2013 14:10, De Premor  wrote:

>  Ups Sorry, my fault, i haven't change a variable to fit yours
>
>
> 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 = Nothing
>
> Workbooks.Open Filename:=*OpenFile*
> End Sub
>
>
>  Pada 01/08/2013 18:59, De Premor menulis:
>
> Try 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 = Nothing
>
> Workbooks.Open Filename:=SaveDest
> End Sub
>
>
>  Pada 01/08/2013 15:36, Jorge Marques menulis:
>
> Hi guys,
>
>  I have developed a macro to open files and copy data from 1 workbook to
> another, this is a report, but now I need to send this to everyone in my
> department, the path i use for opening the file is
>
>  Workbooks.Open
> Filename:="C:\Users\marquesj\Desktop\data_source\week_to_date-export.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 =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post

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

[Jorge Marques]

Hi guys,

I have developed a macro to open files and copy data from 1 workbook to
another, this is a report, but now I need to send this to everyone in my
department, the path i use for opening the file is

Workbooks.Open
Filename:="C:\Users\marquesj\Desktop\data_source\week_to_date-export.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 =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

Thanks, I discovered the error, but ended up using your's macros, thank you
very much all.

On 7 June 2013 15:27, Bé Trần Văn  wrote:

> You try this Code, used for Version.
>
> Code:
> Sub PivotTable_Change()
> Dim PTCache As PivotCache
> Dim PT As PivotTable
> Application.ScreenUpdating = False
> 'Delete Pivot Sheet SPLIT neu no ton tai
> On Error Resume Next
> Application.DisplayAlerts = False
> Sheets("SPLIT").Select
> Columns("B:Q").Select
> Selection.Delete Shift:=xlToLeft
> On Error GoTo 0
> 'Get data starting from row 1 sheet Table1
> Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase,
> SourceData:=Sheets("Table1").Range("A1").CurrentRegion.Address)
> 'SPLIT selected worksheet
> Sheets("SPLIT").Select
> 'Sheet SPLIT, creating PivotTable from C3
> Set PT =
> PTCache.CreatePivotTable(TableDestination:=Sheets("SPLIT").Range("C3"),
> TableName:="PivotTable1")
> With PT
> ''Set PivotTable
> ActiveSheet.PivotTables("PivotTable1").AddDataField
> ActiveSheet.PivotTables( _
> "PivotTable1").PivotFields("TT"), "Count of TT", xlCount
>
> With ActiveSheet.PivotTables("PivotTable1").PivotFields("ASIN")
> .Orientation = xlRowField
>.Position = 1
> End With
> Range("B5").Select
>
> With ActiveSheet.PivotTables("PivotTable1").PivotFields("ASIN")
> .Orientation = xlColumnField
> .Position = 1
> End With
> Range("B6").Select
>
> With ActiveSheet.PivotTables("PivotTable1").PivotFields("FC")
> .Orientation = xlRowField
> .Position = 1
> End With
> End With
> End Sub
>
>
>
> 2013/6/7 Jorge Marques 
>
>> Hi guys, I don't know why but I have this recorded macro, that always
>> gives me an error when is putting the field "QTY" - Quantity in the Values
>> field? Can you help me?
>>
>> Private Sub splitf()
>>
>> Application.ScreenUpdating = False
>>
>> Range("A1").Select
>> Range(Selection, Selection.End(xlToRight)).Select
>> Range(Selection, Selection.End(xlDown)).Select
>> Application.CutCopyMode = False
>> ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$1000"), ,
>> xlYes).Name = _
>> "Table1"
>> Range("Table1[#All]").Select
>> ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
>> SourceData:= _
>> "Table1", Version:=xlPivotTableVersion14).CreatePivotTable
>> TableDestination _
>> :="SPLIT!R2C1", TableName:="PivotTable1", DefaultVersion:= _
>> xlPivotTableVersion14
>> Sheets("SPLIT").Select
>> Cells(2, 1).Select
>> ActiveSheet.PivotTables("PivotTable1").AddDataField
>> ActiveSheet.PivotTables( _
>> "PivotTable1").PivotFields("QTY"), "Count of QTY", xlCount
>> With ActiveSheet.PivotTables("PivotTable1").PivotFields("Count of
>> QTY")
>> .Caption = "Sum of QTY"
>> .Function = xlSum
>> End With
>> With ActiveSheet.PivotTables("PivotTable1").PivotFields("ASIN")
>> .Orientation = xlRowField
>> .Position = 1
>> End With
>> With ActiveSheet.PivotTables("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 =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed

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

[Jorge Marques]

Hi guys, I don't know why but I have this recorded macro, that always gives
me an error when is putting the field "QTY" - Quantity in the Values field?
Can you help me?

Private Sub splitf()

Application.ScreenUpdating = False

Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$1000"), ,
xlYes).Name = _
"Table1"
Range("Table1[#All]").Select
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Table1", Version:=xlPivotTableVersion14).CreatePivotTable
TableDestination _
:="SPLIT!R2C1", TableName:="PivotTable1", DefaultVersion:= _
xlPivotTableVersion14
Sheets("SPLIT").Select
Cells(2, 1).Select
ActiveSheet.PivotTables("PivotTable1").AddDataField
ActiveSheet.PivotTables( _
"PivotTable1").PivotFields("QTY"), "Count of QTY", xlCount
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Count of QTY")
.Caption = "Sum of QTY"
.Function = xlSum
End With
With ActiveSheet.PivotTables("PivotTable1").PivotFields("ASIN")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("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 =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

Works perfectly :), thanks a million.

On 6 June 2013 17:01, ashish koul  wrote:

> see if it helps
> Sub test()
> Dim wk As Worksheet
> Dim i As Long
> Application.ScreenUpdating = False
> Application.DisplayAlerts = False
> Application.Calculation = xlCalculationManual
>
> For Each wk In ThisWorkbook.Worksheets
> For i = wk.Range("a" & wk.Rows.Count).End(xlUp).Row To 2 Step -1
> If wk.Range("b" & i).Value = "" Then wk.Rows(i).Delete Shift:=xlUp
> Next
> Next
> Application.ScreenUpdating = 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
>> with "Name", "Age", "Profession", and I want to delete the rows that have
>> the column "Age" blank, I can do this with a static Macro fo check 4
>> columns, but sometimes I receive 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 Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> 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 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog <http://www.excelvbamacros.com/>*
> Like Us on 
> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>



-- 
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 page of this fo

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

[Jorge Marques]

Hi guys,

I have a file that has 4 worksheets A,B,C,D and eveyrone has 3 columns with
"Name", "Age", "Profession", and I want to delete the rows that have the
column "Age" blank, I can do this with a static Macro fo check 4 columns,
but sometimes I receive 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 Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.




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

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

[Jorge Marques]

Perfect Ashish, thank you very much :).

On 30 May 2013 17:55, ashish koul  wrote:

> see if it helps
>
> Sub incluvazios()
>
> Dim i As Long
>
> For i = 2 To Sheets("Inventory").Range("a65356").End(xlUp).Row
> If Application.WorksheetFunction.CountIf(Sheets("Raw
> Data").Range("a:a"), Sheets("Inventory").Range("b" & i).Value) = 0 Then
> Sheets("Raw Data").Range("a65356").End(xlUp).Offset(1, 0).Value =
> Sheets("Inventory").Range("b" & i).Value
> 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").Range("h" & i).Value
> End If
> Next
>
> End Sub
>
>
>
> On Thu, May 30, 2013 at 4:15 PM, Jorge Marques wrote:
>
>> Hi guys,
>>
>> I have a problem with a Macro, I have two sheets, I want to compare the
>> Items ID of the 2 sheets and if the item doesn't exist in sheet "Raw data"
>> but exists in Sheet " inventory" then I want to copy it to the sheet "raw
>> data" in the first next blank row.
>>
>> My code so far is only this because already here it gives me an error
>>
>> Sub incluvazios()
>>
>> Dim i As Integer
>> Dim j As Integer
>>
>> If Sheets("Inventory").Cells(i, 3).Value <> Sheets("Raw Data").Cells(j,
>> 3).Value Then
>> Sheets("Inventory").Cells(i, 3).Select
>> 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 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 page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> 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 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/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog <http://www.excelvbamacros.com/>*
> Like Us on 
> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don&

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

[Jorge Marques]

Hi guys,

I have a problem with a Macro, I have two sheets, I want to compare the
Items ID of the 2 sheets and if the item doesn't exist in sheet "Raw data"
but exists in Sheet " inventory" then I want to copy it to the sheet "raw
data" in the first next blank row.

My code so far is only this because already here it gives me an error

Sub incluvazios()

Dim i As Integer
Dim j As Integer

If Sheets("Inventory").Cells(i, 3).Value <> Sheets("Raw Data").Cells(j,
3).Value Then
Sheets("Inventory").Cells(i, 3).Select
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 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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.




Inventory in place.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Jorge Marques]

confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> 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 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/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> 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 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/groups/opt_out.
>>
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>



-- 
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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

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 correct, going to test it now, thank you very much :)
>
> Jorge
>
> On 14 May 2013 16:55, Paul Schreiner  wrote:
>
>> If you're intent is to copy the data into separate sheets, then I'd use
>> the following macro:
>>
>> Option Explicit
>> Sub CopyData()
>> Dim nRows As Integer
>> Dim nCols As Integer
>> Dim R As Integer
>> Dim C As Integer
>> Dim Sht As String
>> Dim DataSht As String
>>
>> DataSht = "Sheet1"
>> Sheets(DataSht).Select
>> nRows = ActiveCell.SpecialCells(xlLastCell).Row
>> nCols = ActiveCell.SpecialCells(xlLastCell).Column
>> Application.ScreenUpdating = False
>> On Error Resume Next
>> For C = 2 To nCols
>> Sht = Sheets(DataSht).Cells(2, C).Value
>> Err.Clear
>> Sheets(Sht).Select
>> If (Err.Number = 0) Then
>> Sheets(Sht).Range("A1:Z56000").ClearContents
>> Else
>> Sheets.Add after:=Sheets(Sheets.Count)
>> ActiveSheet.Name = Sht
>> End If
>> For R = 2 To nRows
>> If (Sheets(DataSht).Cells(R, C).Value & "X" <> "X") Then _
>> Sheets(Sht).Cells(R - 1, "A").Value =
>> Sheets(DataSht).Cells(R, C).Value
>> Next R
>> Next C
>> Application.ScreenUpdating = True
>> Sheets(DataSht).Select
>> MsgBox "Finished"
>> End Sub
>>
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>>  --
>> *From:* Jorge Marques 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Tue, May 14, 2013 10:38:45 AM
>> *Subject:* $$Excel-Macros$$ Pivot data to different worksheets
>>
>> Hi guys, I've been struggling with this Macro, I want to copy each
>> column, And the way I did was to use macro in Report filter, but it's
>> unsustainable.
>>
>> Basically is a Pivot table and I want to extract each column to a
>> different sheet, the thing is the number of columns is always changing, 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 page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> 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 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/groups/opt_out.
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>&g

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

[Jorge Marques]

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 correct, going to test it now, thank you very much :)

Jorge

On 14 May 2013 16:55, Paul Schreiner  wrote:

> If you're intent is to copy the data into separate sheets, then I'd use
> the following macro:
>
> Option Explicit
> Sub CopyData()
> Dim nRows As Integer
> Dim nCols As Integer
> Dim R As Integer
> Dim C As Integer
> Dim Sht As String
> Dim DataSht As String
>
> DataSht = "Sheet1"
> Sheets(DataSht).Select
> nRows = ActiveCell.SpecialCells(xlLastCell).Row
> nCols = ActiveCell.SpecialCells(xlLastCell).Column
> Application.ScreenUpdating = False
> On Error Resume Next
> For C = 2 To nCols
> Sht = Sheets(DataSht).Cells(2, C).Value
> Err.Clear
> Sheets(Sht).Select
> If (Err.Number = 0) Then
> Sheets(Sht).Range("A1:Z56000").ClearContents
> Else
> Sheets.Add after:=Sheets(Sheets.Count)
> ActiveSheet.Name = Sht
> End If
> For R = 2 To nRows
> If (Sheets(DataSht).Cells(R, C).Value & "X" <> "X") Then _
> Sheets(Sht).Cells(R - 1, "A").Value = Sheets(DataSht).Cells(R,
> C).Value
> Next R
> Next C
> Application.ScreenUpdating = True
> Sheets(DataSht).Select
> MsgBox "Finished"
> End Sub
>
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Jorge Marques 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, May 14, 2013 10:38:45 AM
> *Subject:* $$Excel-Macros$$ Pivot data to different worksheets
>
> Hi guys, I've been struggling with this Macro, I want to copy each column,
> And the way I did was to use macro in Report filter, but it's
> unsustainable.
>
> Basically is a Pivot table and I want to extract each column to a
> different sheet, the thing is the number of columns is always changing, 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 page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't eve

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

[Jorge Marques]

Hi guys, I've been struggling with this Macro, I want to copy each column,
And the way I did was to use macro in Report filter, but it's unsustainable.

Basically is a Pivot table and I want to extract each column to a different
sheet, the thing is the number of columns is always changing, 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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.




colums to worksheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Jorge Marques]

Probably a type mistake, if you translate to coordinates, Hlookup is a
X-axis lookup and Vlookup is as a Y-axis lookup, you can also do lookups
with match and index.

On 16 February 2013 09:18, Kuldeep Singh  wrote:

>
> Okay Thanks.
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Sat, Feb 16, 2013 at 2:46 PM, David Grugeon wrote:
>
>> Perhaps it is an employment test.  Anyone who knew Excel would know there
>> is no Ylookup.  Someone who was not familiar with excel might invent a
>> meaning for it!
>>
>>  Regards
>> David Grugeon
>>
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> 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 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/groups/opt_out.
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> 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 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/groups/opt_out.
>
>
>



-- 
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 page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
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 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/groups/opt_out.

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

[Jorge Marques]

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 SQL and
applying the learnings I get from this group. Keep it up

On 4 August 2012 16:41, Ashish  wrote:

> Hi, this is Ashish from Delhi works as derivatives trader, passionate
> about travelling and cooking,  finding ways to build my trading model using
> arbitrage strategies on excel.
>
> regards,
> Ashish
>
> On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>>
>> Hey all new and current posters,
>>
>> Welcome to excel group,one of the largest online community of excel Fans!
>>
>> I hope you enjoy your time here & find this forum to be a friendly and
>> knowledgeable community. Please feel free to post a small introduction, a
>> friendly hello or tell us a bit about yourself. Why not tell us where are
>> you from, what you do, what your interests are, how old you are, which is
>> your favourite excel site or blog is or anything else that comes to mind!
>>
>> Thanks for your time
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

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

[Jorge Marques]

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 interesting files.
>
>
> On Fri, Oct 19, 2012 at 7:53 PM, Sam Mathai Chacko wrote:
>
>> This is very good Ashish. Thanks for sharing.
>>
>> Regards,
>> Sam
>>
>> On Fri, Oct 19, 2012 at 7:20 PM, ashish koul wrote:
>>
>>> Hi All,
>>>
>>> If you want to get latitude and longitude of any address   or you want
>>> to find the distance between two cities , etc using Google Map. Please find
>>> below links of macros which will automatically fetch or get data from
>>> Google  Maps using VBA
>>>
>>>
>>> Find Distance and Time between two cities using Google API In excel
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/09/24/find-distance-and-time-between-two-cities-using-google-api-in-excel/
>>>
>>>
>>> Display Google Map in Excel using VBA and Google API
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/09/24/display-google-map-in-excel-using-vba-and-google-api/
>>>
>>>
>>> Plot locations on Google map using VBA and Import updated map to Excel
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/09/26/plot-locations-on-google-map-using-vba-and-import-updated-map-to-excel/
>>>
>>>
>>> Plot Origin and destination city on Google Map and import Map to Excel
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/09/27/plot-origin-and-destination-city-on-google-map-and-import-map-to-excel/
>>>
>>> Google Translation Using VBA
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/09/29/google-translation-using-vba/
>>>
>>> Find Latitude and Longitude of any address using Google Map API and VBA
>>>
>>> http://excelvbaprogramming.wordpress.com/2012/10/18/find-latitude-and-longitude-of-any-address-using-google-map-api-and-vba/
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>>
>>> *Visit*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/*
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members a

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

[Jorge Marques]

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(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT("
> ",99)),99))
>
> On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:
>
>>
>> Hi Team,
>>
>> I am looking for a formula to separate Company's name and email address
>> from IDs.
>>
>> Please refer the snap shot below
>>
>>
>>
>>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
>> 
>>  Accord
>> Soft
>> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
>> 
>> ALIT
>> h...@alit.soft.net  Amadee myj...@amadee.de 
>> INTERNET
>>  Amadee
>> INTERNET
>> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
>> 
>> AMBER 
>> Networking
>> india_j...@ambernetworks.com  American Data
>> Solutions ads...@gafri.com 
>> Bangalore
>>  American
>> Data Solutions 
>> Bangalore
>> ads...@gafri.com  APCC - 
>> irecr...@apcc.com
>>  Aptech 
>> corporate...@aptech.co.in
>>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
>> 
>>  Aspect Dev j...@india.aspectdv.com Ecom 
>> Bangalore
>>  AUTODESK crv...@vsnl.com 
>> 
>>  Bharti Telesoft 
>> care...@bhartitelesoft.com
>>  BOSCALLEO h...@boscalleo.com 
>> Ecomm
>>  BPL Innovision - j...@bplinnovision.com 
>> 
>>  car...@sonata-software.com 
>> 
>>  Cerebra 
>> j...@cerebracomputers.com
>>  CGSmith - 
>> res...@cgs.cgsmith.soft.net
>>  CIRRUS LOGIC 
>> h...@cirrus.stpp.soft.net
>>  CIS hrtele...@cisindia.com 
>> 
>>  CISCO india_j...@cisco.com 
>> Networking
>>
>>
>> Regards,
>> Lucky
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums 

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

[Jorge Marques]

:), I guess it all depends on the structure of the formula :), never used
ISNA before, I use IFERROR for everything.

2012/7/31 Hilary Lomotey 

> insightful, thanks
>
>
> On Tue, Jul 31, 2012 at 12:01 PM, Paul Schreiner 
> wrote:
>
>> interesting...
>> I was just thinking that I use ISNA way too much and should think about
>> using ISERROR more to "keep it simple"!
>>
>>
>> *Paul*
>>
>> -
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>>  --
>> *From:* Jorge Marques 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Tue, July 31, 2012 7:57:43 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ Alternative to OR condition
>>
>> Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple.
>> thank you very much.
>>
>> 2012/7/31 NOORAIN ANSARI 
>>
>>> Dear Jorge,
>>>
>>> The #N/A error happens most often when a lookup function cannot find a
>>> result. You can manually remove the all of your #N/As or you can stop them
>>> in your original formula. A simple and effective way of trapping the #N/A
>>> errors and replacing them with whatever you would like is to use the ISNA()
>>> function.
>>>
>>> ISNA() is a simple function that checks to see if a cell contains N/A.
>>> If it does it returns TRUE, if not it returns FALSE. For example, cell A1
>>> has #N/A, in B1 you type ISNA(A1). The result would be TRUE. We can use
>>> this function in conjunction with other functions to test if a result will
>>> be NA before we see the result. For Example:
>>>
>>> =VLOOKUP(E4,$A$4:$B$6,2,FALSE)
>>>
>>> The function above looks in the table a4:b6 for whatever is in E4, if it
>>> finds it, it returns a result from column 2 of the table. If it does not
>>> find a result, it returns #N/A. We can stop the results from showing #N/A
>>> by using ISNA as below:
>>>
>>> =IF(ISNA(VLOOKUP(E4,$A$4:$B$6,2,FALSE)),“”
>>> ,VLOOKUP(E4,$A$4:$B$6,2,FALSE))
>>>
>>> The formula above shows the result in the highlighted red section rather
>>> than #N/A. In this case it is showing a NULL (“”).
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> <http://www.noorainansari.com/>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 wrote:
>>>
>>>> Noorain what does exactly "ISNA"? I used
>>>> +IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for
>>>> IFerror?
>>>>
>>>>
>>>> 2012/7/31 Hilary Lomotey 
>>>>
>>>>> Perfect, thanks Noorain, it works
>>>>>
>>>>>
>>>>>  On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI <
>>>>> noorain.ans...@gmail.com> wrote:
>>>>>
>>>>>> Hi Hilary,
>>>>>>
>>>>>> Please try it..
>>>>>>
>>>>>> *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)*
>>>>>> Hope it help to you.
>>>>>>
>>>>>> see the attached sheet.
>>>>>>
>>>>>>   On Tue, Jul 31, 2012 at 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 <
>>>>>>> leote.w...@gmail.com> wrote:
>>>>>>>
>>>>>>>> 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 
>>>>>>>>
>

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

[Jorge Marques]

Nice :), I use a lot IFERROR, I´ll do it with ISNA, keeping it simple.
thank you very much.

2012/7/31 NOORAIN ANSARI 

> Dear Jorge,
>
> The #N/A error happens most often when a lookup function cannot find a
> result. You can manually remove the all of your #N/As or you can stop them
> in your original formula. A simple and effective way of trapping the #N/A
> errors and replacing them with whatever you would like is to use the ISNA()
> function.
>
> ISNA() is a simple function that checks to see if a cell contains N/A. If
> it does it returns TRUE, if not it returns FALSE. For example, cell A1 has
> #N/A, in B1 you type ISNA(A1). The result would be TRUE. We can use this
> function in conjunction with other functions to test if a result will be NA
> before we see the result. For Example:
>
> =VLOOKUP(E4,$A$4:$B$6,2,FALSE)
>
> The function above looks in the table a4:b6 for whatever is in E4, if it
> finds it, it returns a result from column 2 of the table. If it does not
> find a result, it returns #N/A. We can stop the results from showing #N/A
> by using ISNA as below:
>
> =IF(ISNA(VLOOKUP(E4,$A$4:$B$6,2,FALSE)),“”,VLOOKUP(E4,$A$4:$B$6,2,FALSE))
>
> The formula above shows the result in the highlighted red section rather
> than #N/A. In this case it is showing a NULL (“”).
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> <http://www.noorainansari.com>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 wrote:
>
>> Noorain what does exactly "ISNA"? I used
>> +IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for
>> IFerror?
>>
>>
>> 2012/7/31 Hilary Lomotey 
>>
>>> Perfect, thanks Noorain, it works
>>>
>>>
>>> On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Hi Hilary,
>>>>
>>>> Please try it..
>>>>
>>>> *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)*
>>>> Hope it help to you.
>>>>
>>>> see the attached sheet.
>>>>
>>>> On Tue, Jul 31, 2012 at 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 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 formula that
>>>>>>> +IF(OR(C4=$A$4,C4=$A$5,C4=$A$6),D1,E1). But this can be painful if the 
>>>>>>> list
>>>>>>> is long, i tried using +IF(C4=$A$4:$A$17,D1,E1), but it only gets it 
>>>>>>> write
>>>>>>> for the first word, the rest comes out wrong, is there an alternative
>>>>>>> formula to this. thanks
>>>>>>>
>>>>>>> --
>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>>
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>
>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>>> in signatures are prohibited.
>>>>>>>
>>>>>>> NOTE : Don't ever po

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

[Jorge Marques]

Noorain what does exactly "ISNA"? I used
+IFERROR(IF(MATCH($C6;$A$4:$A$11;0);D1;"");E1) is it the same principle for
IFerror?

2012/7/31 Hilary Lomotey 

> Perfect, thanks Noorain, it works
>
>
> On Tue, Jul 31, 2012 at 10:24 AM, NOORAIN ANSARI  > wrote:
>
>> Hi Hilary,
>>
>> Please try it..
>>
>> *=+IF(ISNA(MATCH(C4,$A$4:$A$6,0)),E1,D1)*
>> Hope it help to you.
>>
>> see the attached sheet.
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> <http://www.noorainansari.com>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 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 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 formula that
>>>>> +IF(OR(C4=$A$4,C4=$A$5,C4=$A$6),D1,E1). But this can be painful if the 
>>>>> list
>>>>> is long, i tried using +IF(C4=$A$4:$A$17,D1,E1), but it only gets it write
>>>>> for the first word, the rest comes out wrong, is there an alternative
>>>>> formula to this. thanks
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> --
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> To unsubscribe, send a blank email to
>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>
>>>>>
>>>>>
>>>>
>>>>  --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>>
>>>>
&g

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

[Jorge Marques]

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 formula that
> +IF(OR(C4=$A$4,C4=$A$5,C4=$A$6),D1,E1). But this can be painful if the list
> is long, i tried using +IF(C4=$A$4:$A$17,D1,E1), but it only gets it write
> for the first word, the rest comes out wrong, is there an alternative
> formula to this. thanks
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Jorge Marques]

I´ll try that also, I ended up using one of Paul´s suggestion, it "cleaned"
the code by half :) which was just perfect, but too many options are always
good options. Thank you all a million :)


2012/7/27 Sam Mathai Chacko 

> Why not use this.
>
> Select Case Cells(2, j).Value
> Case "sexta-feira"
> Select Case Cells(i, 1).Value
> Case *512, 513, 516*
> MsgBox "Yay"
> Case Else
> MsgBox "Aw"
> End Select
> 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 only returns 1 Case or "OR", the issue is that I have a Shops in this
>> case they are code 513, 512, 516, and if it is "Sexta-feira" (Friday) that
>> should sum the values one day ahead. My idea of Case statement was just
>> trying to avoid several If statements, so I thought Case would be a
>> solution.
>>
>> I´ll try your suggestion and adapt to the rules. Meanwhile I attached the
>> file that I forgot, sorry for that. Thanks :)
>>
>>
>>
>>
>> 2012/7/27 Paul Schreiner 
>>
>>> The "Select Case" condition could be used to replace a "OR" condition.
>>> not really an "AND" condition.
>>> Kind-of.
>>> It's really more like replacing ElseIF.
>>>
>>> For instance, you could use:
>>> both of these examples yield the same result:
>>>
>>>  '
>>> TestVal = "three"
>>> '
>>> Select Case UCase(TestVal)
>>> Case "ONE"
>>> MsgBox "TestVal = ONE"
>>> Case "TWO"
>>> MsgBox "TestVal = TWO"
>>> Case "THREE"
>>> MsgBox "TestVal = THREE"
>>> Case "FOUR"
>>> MsgBox "TestVal = FOUR"
>>> Case Else
>>> MsgBox "TestVal is not a member of the expected list"
>>> End Select
>>> '
>>> If (UCase(TestVal) = "ONE") Then
>>> MsgBox "TestVal = ONE"
>>> ElseIf (UCase(TestVal) = "TWO") Then
>>> MsgBox "TestVal = TWO"
>>> ElseIf (UCase(TestVal) = "THREE") Then
>>> MsgBox "TestVal = THREE"
>>> ElseIf (UCase(TestVal) = "FOUR") Then
>>> MsgBox "TestVal = FOUR"
>>> Else
>>> MsgBox "TestVal is not a member of the expected list"
>>> End If
>>>
>>> '
>>>
>>> In your example, I think the problem is with the conditional "grouping"
>>> you need to use ( ) to group the things together, like;
>>> 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, 1).Value = 516)) _
>>> ) Then
>>> End If
>>>
>>> '
>>> Since the first part of each -And- condition is the same, you could use:
>>> If ((Cells(2, j).Value = "sexta-feira") And _
>>> ((Cells(i, 1).Value = 512) _
>>>   Or (Cells(i, 1).Value = 513) _
>>>   Or (Cells(i, 1).Value = 516) _
>>>)) Then
>>> End If
>>>
>>> '
>>>  If you absolutely INSIST that you need to use a "case" statement,
>>> then I suppose you could use:
>>>
>>> If (Cells(2, j).Value = "sexta-feira") Then
>>> Select Case (Cells(i, 1).Value)
>>> Case 512
>>>
>>> Cells(i, j + 1).Value = Cells(i, j + 1).Value + Cells(i,
>>> j).Value
>>> Case 513
>>>
>>>   

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

[Jorge Marques]

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, 1).Value = 516 Then
Cells(i, j + 1).Value = Cells(i, j + 1).Value + Cells(i, j).Value
End If
Next
Next
End Sub

Thank you in advance :).

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Jorge Marques]

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 to
> give you feedback on this very soon :)
>
>
> 2012/7/4 Asa Rossoff 
>
>> Hi Jorge,
>>
>> OK, here you go!
>>
>> ** **
>>
>> I created a new flat table with all the transporters and their data.
>>
>> I created pivot tables for an easy-to-read view for each transporter (AA,
>> BB, CC).
>>
>> In the Cost table, I used the SUMPRODUCT function to perform the complex
>> cost lookup.
>>
>> I wrote 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 Behalf Of *Jorge Marques
>> *Sent:* Tuesday, July 03, 2012 1:50 AM
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ What do you recommend?? If Formulas,
>> Tables with macros, vlookups?
>>
>> ** **
>>
>> Hi Asa thank you very much for your help, let me see if i can explain
>> better, I answered below the questions in yellow :)
>>
>> 2012/7/2 Asa Rossoff 
>>
>> Hi Jorge,
>>
>> I am happy to help you.
>>
>> *> the table in the example transporter AA the volumes are the columns
>> "1", "2 to 3", and "4 to 5", the column below is the weight, but there are
>> some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
>> i´m must charge 2 instead of one, because the rule weight overules the
>> other, whenever one rule is "bigger" than the other, we charge considering
>> the highest value.*
>>
>> No problem.  I think I understand all the values on the Transporter (e.g.
>> AA) tables now.  You didn't explicitly state so, but I understand now that
>> the value being lookup up on this table (in B4:D7) is the Cost.  I also
>> understand that the correct cost to select is the highest of the two costs,
>> for the given Volumes or Weight.
>>
>>  
>>
>> *1)**  *Question, though; In your original message you said:
>>
>> *>>> 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*
>>
>> Here you stated that the Distance (KM) is a criteria for cost.
>>
>> a.  Please tell me, on the Transporter AA table, where is the
>> Distance?  Or in any case, please explain how you want the distance to be
>> considered.  Perhaps the Cost is Cost per KM, and gets multipled as such in
>> the cost table…?
>>
>> I only put the distance in column B if my "Order of purchase" is in zone
>> 4, in zone 1,2,3 i leave that column blank, the zone column is the E 
>>
>> 2)  The ranges of values on your Transporter table are somewhat
>> unclear to me.
>>
>> a.  Volumes: 1, 2-3, 4-5.  If the Volumes number used for your
>> lookup is always a whole number with no fraction, this is clear, but..***
>> *
>>
>>   i. If
>> it might contain a fraction, such as 1.3 or 1.9, what should happen?
>> Should it be rounded up to 2 for the lookup in both cases?  Should 1.3 be
>> rounded down and 1.9 be rounded up?
>>
>> The volumes are whole number because we designate pallets as volumes. ***
>> *
>>
>>  ii. If
>> Volumes is > 5 or < 1 what should happen? (below the first range or above
>> the last range)
>>
>> if volume  is smaller than 1 then "error" if >5 goes to above the last
>> range. 
>>
>> b.  Weight: 1-5, 5-10, 10-100.  Here your ranges actually overlap at
>> the edges -- this is different from how you defined your ranges for Volumes.
>> 
>>
>>   i. Which
>> range should be used if the weight is exactly 5?  The first range or the
>> second?
>>
>>  Here you should use the first range, my mist

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

[Jorge Marques]

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-feira  04-06-2012 05-06-2012 06-06-2012 07-06-2012 08-06-2012
11-06-2012  500 0 0 0 1 0
0  501 492 25 369 116 247
369  502 1.083 4 351 41 1
351

I need 2 rules, they are:

one is, IF Cells(2, j).Value = "terça-feira" and Cells(i, 1).Value = 502
then

Cells(i, j + 1).value = Cells(i, j +1).Value + Cells( i, j) that would be
351+4 = 355

the other:

IF Cells(2, j).Value = "quinta- feira" and Cells(i, 1).Value = 502 then
(adds this value in the next segunda-feira, in this case 11-06-2012)

Cells(i, j + 4).value = Cells(i, j +4).Value + Cells( i, j).Value in this
case the value would be 41 + 351 = 392

the last one

IF Cells(2, j).Value = "sexta-feira" and Cells(i, 1).Value = 502 then (adds
this value in the next segunda-feira, in this case 11-06-2012)

Cells(i, j + 3).value = Cells(i, j +3).Value + Cells( i, j).Value in this
case the value would be 1 + 351 = 351 but then appying the 2 rule would
become 41 + 352 = 393

I am still a mess with two dimensions using i, j, can you help me?? Excel
attached.

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




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

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

[Jorge Marques]

I implemented this now

Private Sub corrermac()
Sheets("Datas").Select
If Range("B1").Value = Range("C1").Value Then
Call julho
ElseIf Range("B2").Value = Range("C2").Value Then
Call agosto
End Sub
Sub julho()
Sheets("Dias acidente").Select
Range("B2:B32").Select
Selection.ClearContents
Sheets("Dias acidente").Select
End Sub
Sub agosto()
Sheets("Dias acidente").Select
Range("B2:B32").Select
Selection.ClearContents
Sheets("Dias acidente").Select
End Sub

in order to delete the days 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 macro to everyday put a "Sim" in a scheduled time, and put
> the color green on the correspondent day and if "Não" puts red color, but I
> have a problem.
>
>
> The vlookup conditional formatting doesn´t work if I have numbers
> duplicated.
>
> How can i reset the colors when it starts a new month without having to
> delete the contents of cells B1 to B33 in order to start a again the
> calendar in sheet1? I could do a sort of if month(today()) = 7 then delete
> range(B1:B33) elseif month(today()) = 8 then range (B34:B63) delete, but
> this is coding too much for unnecessary lines, is there a way to do this
> and simplifying? Another think I thought is doing a vlookup of
> (monthtoday()).
>
> Thank you very much in advance
>
> My macro for this is:
>
> Sub acidentes()
>
> Dim RunTime2 As Date
>
> Sheets("Dias acidente").Select
>
> Cells(1, 7).Value = Cells(1, 7) + 1
>
> RunTime2 = Now + TimeValue("00:00:10")
>
> Application.OnTime RunTime2, "acidentes"
>
> Cells(1, 3).End(xlDown).Offset(1, 0).Select
> Selection.Value = "Sim"
>
> For i = 1 To 550
>
> If Cells(i, 3).Value = "Sim" Then
>
> Cells(i, 4).Value = "Sem acidente"
> Cells(i, 4).Interior.ColorIndex = 4
>
> ElseIf Cells(i, 3).Value = "Não" Then
>
> Cells(i, 4).Value = "Com Acidente"
> Cells(i, 4).Interior.ColorIndex = 3
> Cells(i, 3).Value = "CA"
> Cells(1, 7).Value = Cells(1, 7).Value - 1
>
> Cells(1, 8).Value = Cells(1, 7).Value
> Cells(1, 7).Value = 0
> End If
> Next
>
> If Range("H13").Value = "stop" Then
> Application.OnTime RunTime2, "acidentes", , False
> End If
> End Sub
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[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 to
give you feedback on this very soon :)

2012/7/4 Asa Rossoff 

> Hi Jorge,
>
> OK, here you go!
>
> ** **
>
> I created a new flat table with all the transporters and their data.
>
> I created pivot tables for an easy-to-read view for each transporter (AA,
> BB, CC).
>
> In the Cost table, I used the SUMPRODUCT function to perform the complex
> cost lookup.
>
> I wrote 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 Behalf Of *Jorge Marques
> *Sent:* Tuesday, July 03, 2012 1:50 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ What do you recommend?? If Formulas,
> Tables with macros, vlookups?
>
> ** **
>
> Hi Asa thank you very much for your help, let me see if i can explain
> better, I answered below the questions in yellow :)
>
> 2012/7/2 Asa Rossoff 
>
> Hi Jorge,
>
> I am happy to help you.
>
> *> the table in the example transporter AA the volumes are the columns
> "1", "2 to 3", and "4 to 5", the column below is the weight, but there are
> some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
> i´m must charge 2 instead of one, because the rule weight overules the
> other, whenever one rule is "bigger" than the other, we charge considering
> the highest value.*
>
> No problem.  I think I understand all the values on the Transporter (e.g.
> AA) tables now.  You didn't explicitly state so, but I understand now that
> the value being lookup up on this table (in B4:D7) is the Cost.  I also
> understand that the correct cost to select is the highest of the two costs,
> for the given Volumes or Weight.
>
>  
>
> *1)**  *Question, though; In your original message you said:
>
> *>>> 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*
>
> Here you stated that the Distance (KM) is a criteria for cost.
>
> a.  Please tell me, on the Transporter AA table, where is the
> Distance?  Or in any case, please explain how you want the distance to be
> considered.  Perhaps the Cost is Cost per KM, and gets multipled as such in
> the cost table…?
>
> I only put the distance in column B if my "Order of purchase" is in zone
> 4, in zone 1,2,3 i leave that column blank, the zone column is the E 
>
> 2)  The ranges of values on your Transporter table are somewhat
> unclear to me.
>
> a.  Volumes: 1, 2-3, 4-5.  If the Volumes number used for your lookup
> is always a whole number with no fraction, this is clear, but..
>
>   i. If
> it might contain a fraction, such as 1.3 or 1.9, what should happen?
> Should it be rounded up to 2 for the lookup in both cases?  Should 1.3 be
> rounded down and 1.9 be rounded up?
>
> The volumes are whole number because we designate pallets as volumes. 
>
>  ii. If
> Volumes is > 5 or < 1 what should happen? (below the first range or above
> the last range)
>
> if volume  is smaller than 1 then "error" if >5 goes to above the last
> range. 
>
> b.  Weight: 1-5, 5-10, 10-100.  Here your ranges actually overlap at
> the edges -- this is different from how you defined your ranges for Volumes.
> 
>
>   i. Which
> range should be used if the weight is exactly 5?  The first range or the
> second?
>
>  Here you should use the first range, my mistake sorry
>
>  ii. What
> about 5.1 (if your data might contain fractions)?  Would that be the first
> range or the second? should use first range until 5.99
>
>        iii. What
> about < 1 or > 100? (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.***
> *
>
&g

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

[Jorge Marques]

Hi Asa thank you very much for your help, let me see if i can explain
better, I answered below the questions in yellow :)

2012/7/2 Asa Rossoff 

> Hi Jorge,
>
> I am happy to help you.
>
> *> the table in the example transporter AA the volumes are the columns
> "1", "2 to 3", and "4 to 5", the column below is the weight, but there are
> some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
> i´m must charge 2 instead of one, because the rule weight overules the
> other, whenever one rule is "bigger" than the other, we charge considering
> the highest value.*
>
> No problem.  I think I understand all the values on the Transporter (e.g.
> AA) tables now.  You didn't explicitly state so, but I understand now that
> the value being lookup up on this table (in B4:D7) is the Cost.  I also
> understand that the correct cost to select is the highest of the two costs,
> for the given Volumes or Weight.
>
> ** **
>
> ***1)  ***Question, though; In your original message you said:**
>
> *>>> 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*
>
> Here you stated that the Distance (KM) is a criteria for cost.
>
> **a.  **Please tell me, on the Transporter AA table, where is the
> Distance?  Or in any case, please explain how you want the distance to be
> considered.  Perhaps the Cost is Cost per KM, and gets multipled as such in
> the cost table…?
>
I only put the distance in column B if my "Order of purchase" is in zone 4,
in zone 1,2,3 i leave that column blank, the zone column is the E

> 
>
> **2)  **The ranges of values on your Transporter table are somewhat
> unclear to me.
>
> **a.  **Volumes: 1, 2-3, 4-5.  If the Volumes number used for your
> lookup is always a whole number with no fraction, this is clear, but..
>
> **  i. **If
> it might contain a fraction, such as 1.3 or 1.9, what should happen?
> Should it be rounded up to 2 for the lookup in both cases?  Should 1.3 be
> rounded down and 1.9 be rounded up?
>
The volumes are whole number because we designate pallets as volumes.

> 
>
> ** ii. **If
> Volumes is > 5 or < 1 what should happen? (below the first range or above
> the last range)
>
if volume  is smaller than 1 then "error" if >5 goes to above the last
range.

> 
>
> **b.  **Weight: 1-5, 5-10, 10-100.  Here your ranges actually overlap
> at the edges -- this is different from how you defined your ranges for
> Volumes.
>
> **  i. **Which
> range should be used if the weight is exactly 5?  The first range or the
> second?
>
 Here you should use the first range, my mistake sorry

> 
>
> ** ii. **What
> about 5.1 (if your data might contain fractions)?  Would that be the first
> range or the second? should use first range until 5.99**
>
> **   iii. **What
> about < 1 or > 100? (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@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Jorge Marques
> *Sent:* Monday, July 02, 2012 2:34 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ What do you recommend?? If Formulas,
> Tables with macros, vlookups?
>
> ** **
>
> HI, the table in the example transporter AA the volumes are the columns
> "1", "2 to 3", and "4 to 5", the column below is the weight, but there are
> some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
> i´m must charge 2 instead of one, because the rule weight overules the
> other, whenever one rule is "bigger" than the other, we charge considering
> the highest value.
>
> ** **
>
> i´m trying to do this with a table concatenating all the values and then
> using lookups, let´s see if I can succeed.
>
> 2012/6/29 Asa Rossoff 
>
> Hi Jorge,
>
> Looks like this can be handled using lookup formulas.
>
>  
>
> One good way to perform 

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

[Jorge Marques]

HI, the table in the example transporter AA the volumes are the columns
"1", "2 to 3", and "4 to 5", the column below is the weight, but there are
some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1,
i´m must charge 2 instead of one, because the rule weight overules the
other, whenever one rule is "bigger" than the other, we charge considering
the highest value.

i´m trying to do this with a table concatenating all the values and then
using lookups, let´s see if I can succeed.

2012/6/29 Asa Rossoff 

> Hi Jorge,
>
> Looks like this can be handled using lookup formulas.
>
> ** **
>
> One good way to perform lookups is to have a number representing each of
> your criteria each alone in their own cell, preferably all in the same
> table for all transporters.  You can use pivot tables to generate the cross
> referenced charts you have now for easy human-reading for each shipper, and
> your Cost table can use lookup formulas to do its calculation.
>
> ** **
>
> I'm a bit confused about a few details, and don't have a lot of time right
> now, but will try to take another look in the coming days if you haven't a
> solution yet.
>
> ** **
>
> Some questions though:
>
> You refer to 6 items of data:  (1) Transporter (2) Zone (3) Volumes (4)
> Weight/KG (5) Distance/KM (6) Cost.
>
> ** **
>
> The charts for each Transporter seem to contain 4 items of data.  5
> including the name of the transporter.  I assume the row 2 of the
> transporter tables contain ranges for VOLUMES, row 3 ranges for WEIGHT/KG;
> Column 1 zontains ZONE.  The data points in cells B4:D7 then must contain
> either DISTANCE/KM or COST… But which?  And where is the other item?
>



> 
>
> ** **
>
> It's possible to perform a lookup that checks multiple criteria and finds
> the intersection on a table like this.  Perhaps--since the ranges for
> volumes and KG seem to be the same for all transporters, as do the number
> of zones--insert another column either before or after the zone column for
> the Shipper name/ID, and include all transporters' data in the one table
> while maintaining a similar format.  You can then use a lookup strategy
> that might go like this:  use MATCH functions for each criteria, and logic
> to determine the right combination of criteria, then use the index function
> to retrieve the selected column, and another index function to retrieve the
> selected row.  Place a space between those two functions (all in the 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 Behalf Of *Jorge Marques
> *Sent:* Friday, June 29, 2012 1:54 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$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. if zone 4 and under those 3 limits we have to multiply
> the value in the table with the extra km in column D.
>
> ** **
>
> Until now i only had 2 transport company´s so I used if formulas to
> calculate the costs, but now I have 3 more, a total of 5, and I think if i
> use if formulas it will be heavy on the code and generate errors.
>
> ** **
>
> What do you recommend?
>
> ** **
>
> Thank you very much in advance.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, s

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

[Jorge Marques]

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. if zone 4 and under those 3 limits we have to multiply
the value in the table with the extra km in column D.

Until now i only had 2 transport company´s so I used if formulas to
calculate the costs, but now I have 3 more, a total of 5, and I think if i
use if formulas it will be heavy on the code and generate errors.

What do you recommend?

Thank you very much in advance.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

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

[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 = Today() and only put Red if
"Sim" and reset the counter? this way i don´t have to put everyday "Não" in
order to give green

2012/5/2 Rajan_Verma 

> Did you attached Wrong file ? 
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* 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 Macro that i use for color changing if the cell is
> "Sim" red color and if the cell is "Não" green color, but i have the
> following  problems:
>
> ** **
>
> 1. How can i stop the macro when it finds the first empty cell, as it is
> defined to 65536 it only stops there, can i do like an 
>
> ** **
>
> Range("A1").select
>
> Range(Selection, Selection.End(xldown)).Select
>
> ** **
>
> 2. This excel is embebeded is a powerpoint, i need it at 00:00 to run the
> macro (to this i´m doing a exe to put in windows scheduler, the computer is
> always on, what do you think? or as the excel is embedded in ppt i do a
> applicationTime trigger?)
>
> ** **
>
> 3. In another slide of the powerpoint i have another sheet of the excel
> where it counts the day until "Não" then if it finds a "Não" i returns to 0
> and starts counting again
>
> ** **
>
> Can you help me thank you very much
>
> ** **
>
> the current  code is:
>
> ** **
>
> Sub colorcell()
> On Error Resume Next
> Dim current As String
>
> For i = 1 To 65536
>
> celulas = "A" & i
>
> Range(celulas).Select
>
> If Range(celulas).Text = "Não" Then
> With Selection.Interior
> .ColorIndex = 3
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> End With
> End If
>
> If Range(celulas).Text = "Sim" Then
> With Selection.Interior
> .ColorIndex = 4
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> End With
> End If
> Next i
> End Sub
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Jorge Marques]

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 = Today() and only put Red if
> "Sim" and reset the counter? this way i don´t have to put everyday "Não" in
> order to give green
>
>
> 2012/5/2 Rajan_Verma 
>
>> Did you attached Wrong file ? 
>>
>> ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* 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 Macro that i use for color changing if the cell is
>> "Sim" red color and if the cell is "Não" green color, but i have the
>> following  problems:
>>
>> ** **
>>
>> 1. How can i stop the macro when it finds the first empty cell, as it is
>> defined to 65536 it only stops there, can i do like an 
>>
>> ** **
>>
>> Range("A1").select
>>
>> Range(Selection, Selection.End(xldown)).Select
>>
>> ** **
>>
>> 2. This excel is embebeded is a powerpoint, i need it at 00:00 to run the
>> macro (to this i´m doing a exe to put in windows scheduler, the computer is
>> always on, what do you think? or as the excel is embedded in ppt i do a
>> applicationTime trigger?)
>>
>> ** **
>>
>> 3. In another slide of the powerpoint i have another sheet of the excel
>> where it counts the day until "Não" then if it finds a "Não" i returns to 0
>> and starts counting again
>>
>> ** **
>>
>> Can you help me thank you very much
>>
>> ** **
>>
>> the current  code is:
>>
>> ** **
>>
>> Sub colorcell()
>> On Error Resume Next
>> Dim current As String
>>
>> For i = 1 To 65536
>>
>> celulas = "A" & i
>>
>> Range(celulas).Select
>>
>> If Range(celulas).Text = "Não" Then
>> With Selection.Interior
>> .ColorIndex = 3
>> .Pattern = xlSolid
>> .PatternColorIndex = xlAutomatic
>> End With
>> End If
>>
>> If Range(celulas).Text = "Sim" Then
>> With Selection.Interior
>> .ColorIndex = 4
>> .Pattern = xlSolid
>> .PatternColorIndex = xlAutomatic
>> End With
>> End If
>> Next i
>> End Sub
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
&

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

[Jorge Marques]

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 build code by myself, but know, I can read and understand what it means,
so i can build macros but taking pieces from other macros and adapt to what
i pretend, and when i have doubts this forum is 100% perfect. i hope
someday i can be the one responding to solutions and not asking for them
:), wish you the best in this Excel world.

2012/3/28 Darwin Chan 

> Hi all,
>
> I found this thread which is really useful, however, I couldnt find the
> Tools-Reference-Microsoft Outlook 12.0 Object Library as mentioned by
> Noorain MS Excel 2000 version
> How could I get access to the Library?
>
> 2012/3/20 NOORAIN ANSARI 
>
>> Dear Talal,
>>
>> It's really simple but it takes some time.
>> Spend 2-3 hours a day, every day, in these forums reading posts and
>> trying the solutions provided. Experiment!
>>
>> Try to Create simple macro by help of record macro,Google,Books.
>>
>> Hope your Excel-VBA will surely improve.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.com/*
>>
>> On Wed, Mar 14, 2012 at 12:39 PM, Muhammad Talal Akbar <
>> sh.talal.ak...@gmail.com> wrote:
>>
>>> Hi
>>> Mr. Ansari
>>>
>>> how are you? My dear i need your help
>>>
>>> can u guide me; how can i improve my skills in excel and VBA
>>>
>>>
>>> regards,
>>>
>>>
>>> On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Please add Outlook library before run the code

 Tools-Reference-Microsoft Outlook 12.0 Object Library.

 On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel wrote:

> i'm using the following code to send email how do i add something to
> the body?
>
>
> does anyone know if its possible to add a message to the email?
>
>   ThisWorkbook.Sheets(1).Copy
>
> With ActiveWorkbook
>
>  .SendMail Recipients:="emailaddr...@df.com", _
>
>   Subject:="Try Me")
>
>  .Close SaveChanges:=False
>
> End With
>
>
> *End Sub*
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>





  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : 

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

[Jorge Marques]

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
>
>  *From:* Jorge Marques 
> *Sent:* Wednesday, February 29, 2012 5:11 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
> counting
>
>  Sorry my friends for writting again in the post, it just that i
> understood this code, the only thing i don´t get is if the control cell is
> Z and not A, how can i change it, because, i have a another report that is
> exactly like the initial post but now the control is not A- Order but cell
> Z - Shop, 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
>>
>>  *From:* Jorge Marques 
>> *Sent:* Wednesday, February 22, 2012 10:00 AM
>>  *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
>> counting
>>
>>
>> Hi, Aamir Shahzad was option was good, but it suited me for doing another
>> thing in another report, but i needed in a macro format in order to delete
>> the data whenever i pull a report, dguillett1 was exactly as i wanted :).
>> thank you very much both of you.
>>
>> 2012/2/20 dguillett1 
>>
>>>   I didn’t do columns F & G so use this
>>> Sub ConsolidateTotalsSAS()
>>> Dim i As Long
>>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
>>> If Cells(i + 1, 1) = Cells(i, 1) Then
>>> Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
>>> Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
>>> Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
>>> Rows(i + 1).Delete
>>> End If
>>> Next i
>>> End Sub
>>>
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@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.
>>>
>>> Aamir Shahzad
>>>
>>> On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques wrote:
>>>
>>>> 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 system has changed, the report is generated by a sql, so i
>>>> loose the formulas everytime i generate a report and i can´t gather the
>>>> column B,C,D.
>>>> 5. is there any way i can do it, by macro, running it after i push the
>>>> report from SQL? Thank you very much.
>>>>
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to 

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

[Jorge Marques]

Oh ok never saw it that way, I ended up doing this way

=IF(AND(F8<126;G8<16;H8<2);14,5;IF(AND(F8<376;G8<16;H8<4);16,5;IF(AND(F8<626;G8<16;H8<6);18,13;IF(AND(F8<1001;G8<16;H8<16);24,9;0
with 3 rules, do you think it´s viable this way, or should i "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
>> 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 titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> .
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Formula not working

[Jorge Marques]

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 titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

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

[Jorge Marques]

Yes that´s what i thought, just wasn´t sure about the Cells(Rows.Count, 1).
well thank you very much once again :).

2012/2/29 ChilExcel 

> Don Guillett
>
> Great contribution, thanks Don Guillett
>
> Chilexcel
> 2012/2/29 Sam Mathai Chacko 
>
>> Just a guess without 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 my friends for writting again in the post, it just that i
>>> understood this code, the only thing i don´t get is if the control cell is
>>> Z and not A, how can i change it, because, i have a another report that is
>>> exactly like the initial post but now the control is not A- Order but cell
>>> Z - Shop, 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
>>>>
>>>>  *From:* Jorge Marques 
>>>> *Sent:* Wednesday, February 22, 2012 10:00 AM
>>>>  *To:* excel-macros@googlegroups.com
>>>> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing
>>>> and counting
>>>>
>>>>
>>>> Hi, Aamir Shahzad was option was good, but it suited me for doing
>>>> another thing in another report, but i needed in a macro format in order to
>>>> delete the data whenever i pull a report, dguillett1 was exactly as i
>>>> wanted :). thank you very much both of you.
>>>>
>>>> 2012/2/20 dguillett1 
>>>>
>>>>>   I didn’t do columns F & G so use this
>>>>> Sub ConsolidateTotalsSAS()
>>>>> Dim i As Long
>>>>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
>>>>> If Cells(i + 1, 1) = Cells(i, 1) Then
>>>>> Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
>>>>> Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
>>>>> Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
>>>>> Rows(i + 1).Delete
>>>>> End If
>>>>> Next i
>>>>> End Sub
>>>>>
>>>>>
>>>>> Don Guillett
>>>>> SalesAid Software
>>>>> dguille...@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.
>>>>>
>>>>> Aamir Shahzad
>>>>>
>>>>> On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques 
>>>>> wrote:
>>>>>
>>>>>> 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 system has changed, the report is generated by a sql, so
>>>>>> i loose the formulas everytime i generate a report and i can´t gather the
>>>>>> column B,C,D.
>>>>>> 5. is there any way i can do it, by macro, running it after i push
>>>>>> the report from SQL? Thank you very much.
>>>>>>
>>>>>>
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the t

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

[Jorge Marques]

Sorry my friends for writting again in the post, it just that i understood
this code, the only thing i don´t get is if the control cell is Z and not
A, how can i change it, because, i have a another report that is exactly
like the initial post but now the control is not A- Order but cell Z -
Shop, 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
>
>  *From:* Jorge Marques 
> *Sent:* Wednesday, February 22, 2012 10:00 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and
> counting
>
>
> Hi, Aamir Shahzad was option was good, but it suited me for doing another
> thing in another report, but i needed in a macro format in order to delete
> the data whenever i pull a report, dguillett1 was exactly as i wanted :).
> thank you very much both of you.
>
> 2012/2/20 dguillett1 
>
>>   I didn’t do columns F & G so use this
>> Sub ConsolidateTotalsSAS()
>> Dim i As Long
>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
>> If Cells(i + 1, 1) = Cells(i, 1) Then
>> Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
>> Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
>> Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
>> Rows(i + 1).Delete
>> End If
>> Next i
>> End Sub
>>
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@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.
>>
>> Aamir Shahzad
>>
>> On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques wrote:
>>
>>> 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 system has changed, the report is generated by a sql, so i
>>> loose the formulas everytime i generate a report and i can´t gather the
>>> column B,C,D.
>>> 5. is there any way i can do it, by macro, running it after i push the
>>> report from SQL? Thank you very much.
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don

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

[Jorge Marques]

Hi, Aamir Shahzad was option was good, but it suited me for doing another
thing in another report, but i needed in a macro format in order to delete
the data whenever i pull a report, dguillett1 was exactly as i wanted :).
thank you very much both of you.

2012/2/20 dguillett1 

>   I didn’t do columns F & G so use this
> Sub ConsolidateTotalsSAS()
> Dim i As Long
> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
> If Cells(i + 1, 1) = Cells(i, 1) Then
> Cells(i, "e") = Val(Cells(i + 1, "e")) + Val(Cells(i, "e"))
> Cells(i, "f") = Val(Cells(i + 1, "f")) + Val(Cells(i, "f"))
> Cells(i, "g") = Val(Cells(i + 1, "g")) + Val(Cells(i, "g"))
> Rows(i + 1).Delete
> End If
> Next i
> End Sub
>
>
> Don Guillett
> SalesAid Software
> dguille...@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.
>
> Aamir Shahzad
>
> On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques wrote:
>
>> 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 system has changed, the report is generated by a sql, so i
>> loose the formulas everytime i generate a report and i can´t gather the
>> column B,C,D.
>> 5. is there any way i can do it, by macro, running it after i push the
>> report from SQL? Thank you very much.
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post

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

[Jorge Marques]

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 system has changed, the report is generated by a sql, so i
loose the formulas everytime i generate a report and i can´t gather the
column B,C,D.
5. is there any way i can do it, by macro, running it after i push the
report from SQL? Thank you very much.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


data aglomeration.xls
Description: MS-Excel spreadsheet

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

[Jorge Marques]

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 to sum, not counting weekdays, i tried to do a formula withs sums and
counts but i´m not getting there, is there anyway with a macro or a
formula? thank you very much

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$

[Jorge Marques]

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, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[Jorge Marques]

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/*
> *http://noorain-ansari.blogspot.com/*
>
>   On Fri, Oct 21, 2011 at 11:13 AM,  wrote:
>
>> Dear Dilip,
>>
>> It wud have been gr8 if u also explain the codes in brief..when to use
>> which type code.
>>
>> Thanks and regards
>> CA Sandeep Kr Chhajer.
>>
>> Sent on my BlackBerry® from Vodafone
>>
>> -Original Message-
>> From: Dilip Pandey 
>> Sender: excel-macros@googlegroups.com
>> Date: Fri, 21 Oct 2011 11:09:04
>> To: 
>> Reply-To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ How to learn vba
>>
>> Hi,
>>
>> Below are the explanation of looping codes:-
>>
>> Looping codes
>> 
>>
>> Do While/ Until "conditon"
>> 
>> 
>> Exit Do
>> 
>> 
>> Loop
>>
>> `
>>
>>
>> Do
>> -
>> -
>> Exit Do
>> -
>> -
>> Loop While / Until "condition"
>>
>> ''
>>
>>
>> While "condition"
>> 
>> 
>> 
>> Wend
>>
>> 
>>
>> If "condition" Then
>> 
>> 
>> 
>> Else
>> 
>> 
>> 
>> End if
>>
>> ``
>>
>> Case "condition"
>> 
>> 
>> 
>> End Case
>>
>> ``
>>
>> For "condition"
>> 
>> 
>> 
>> Next
>>
>> ``
>>
>> For Each "condition"
>> 
>> 
>> 
>> Next
>>
>> `
>>
>> With "selection"
>> 
>> 
>> 
>> End with
>>
>> =
>>
>>
>> Using "FOR" loop for each sheet in workbook
>> ==
>> For i = 1 To Sheets.Count
>> Sheets(i).Select
>> 'your code here
>> Next
>>
>>
>> Regards,
>> DILIPandey
>>
>>
>> On 10/20/11, Mr excel  wrote:
>> > Thanks all,for the replies.i had been working with the VBA macro
>> > recorder.Its really very funny & intersting to learn like this.But there
>> are
>> > some situation where i need to learn the programming techniques like Do
>> > Loops,While Loops etc which cannot be learnt from macro recording.Please
>> > suggest me some ideas or techniques for learning...Thanks in advance to
>> all
>> > those who had helped me...
>> >
>> > --
>> >
>> --
>> > 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
>> >
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>>   MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>> --
>>
>> --
>> 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 

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

[Jorge Marques]

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, most of
my macros are based in his codes.but i have some books in pdf if you wish!





2011/9/26 syed aliya raza hashim 

> Hi,
> I want to learn VBA Excel so what is the path that should i follow ,does
> any book will help or what means i despretely learn VBA ,so please help me
> how to learn
>
>
> --
> syed aliya
>
> --
>
> --
> 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 on inputbox

[Jorge Marques]

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 define the inputbox with that
dim and then define a msg box to confirm but only have an example for
printing.


Private Sub updatemonth()
Sheets("Brand").Range("C1").End(xlDown).Offset(1, 0).Select
Do
ActiveCell.Value = "Month i want"
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Offset(0, 4).Value = "Total"
End Sub

thank you  a 1000 times in advance.

-- 
--
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 required on Importing Data

[Jorge Marques]

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 certain
cells, or by a certain condition.

2011/8/3 Venkat CV 

> Hi Kaushik,
>
> We can Copy Paste Else Link the Cells as Required data by using data
> linking...workbook 1 to Workbook 2
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA wrote:
>
>> Hi All,
>> How to import only selected data from another workbook?
>> Please help.
>>
>> Regards,
>> Kaushik
>>
>> --
>> Sent from Gmail for mobile | mobile.google.com
>>
>> Kaushik Savla
>>
>> --
>>
>> --
>> 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$$ Please explain about loop

[Jorge Marques]

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
>
> --
>
> --
> 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 Macro doesn´t work anymore, keeps giving same error

[Jorge Marques]

Doing that, it doesn´t return the error anymore, but the macro still doesn´t
copy the information :s, is it any complication with excel 2010?

2011/7/22 Rajan_Verma 

>  *Set Wb=ActiveWorkbook*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.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 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 AbrirFile
> Call left
>
> wbmes.Close
>
> End Sub
>
> Private Sub AbrirFile()
>
> Dim Filter, Caption As String
> Dim SelectedFile As Variant
>
> Set wb = ThisWorkbook
>
>
> Filter = "Ficheiro XLS (*.xls),(*.xls)"
> Caption = "Escolha o ficheiro a importar..."
>
> SelectedFile = Application.GetOpenFilename(Filter, , Caption)
>
> If SelectedFile = False Then Exit Sub
>
> Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
>
> End Sub
>
>
> Private Sub left()
>
> Dim a As Double
>
> wbmes.Activate
> wbmes.Sheets("Total_Refrige").Select
> wbmes.Sheets("Total_Refrige").Range(Range("D2"),
> Range("D2").End(xlDown)).Copy
> wb.Activate
>
> If wb.Sheets("Pivot").Range("G2").Value <> "" Then
> wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
> Else
> wb.Sheets("Pivot").Range("G2").Select
> End If
>
> a = ActiveCell.Row
>
> wb.Sheets("Total Refrige").Paste 
>
> Application.CutCopyMode = False
>
> i = a
>
> While wb.Sheets("Pivot").Range("G" & i).Value <> ""
> i = i + 1
>
> Wend
>
> End Sub
>
>  
>
> Do you have any idea how to solve this?1000 thanks
>
> --
>
> --
> 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$$ Help Macro doesn´t work anymore, keeps giving same error

[Jorge Marques]

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:
>
>> 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 AbrirFile
>> Call left
>> wbmes.Close
>> End Sub
>> Private Sub AbrirFile()
>> Dim Filter, Caption As String
>> Dim SelectedFile As Variant
>> Set wb = ThisWorkbook
>>
>> Filter = "Ficheiro XLS (*.xls),(*.xls)"
>> Caption = "Escolha o ficheiro a importar..."
>> SelectedFile = Application.GetOpenFilename(Filter, , Caption)
>> If SelectedFile = False Then Exit Sub
>> Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
>> End Sub
>>
>> Private Sub left()
>> Dim a As Double
>> wbmes.Activate
>> wbmes.Sheets("Total_Refrige").Select
>> wbmes.Sheets("Total_Refrige").Range(Range("D2"),
>> Range("D2").End(xlDown)).Copy
>> wb.Activate
>> If wb.Sheets("Pivot").Range("G2").Value <> "" Then
>> wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
>> Else
>> wb.Sheets("Pivot").Range("G2").Select
>> End If
>> a = ActiveCell.Row
>> wb.Sheets("Total Refrige").Paste
>> Application.CutCopyMode = False
>> i = a
>> While wb.Sheets("Pivot").Range("G" & i).Value <> ""
>> i = i + 1
>>
>> Wend
>> End Sub
>>
>> Do you have any idea how to solve this?1000 thanks
>>
>> --
>>
>> --
>> 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

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

[Jorge Marques]

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 AbrirFile
Call left
wbmes.Close
End Sub
Private Sub AbrirFile()
Dim Filter, Caption As String
Dim SelectedFile As Variant
Set wb = ThisWorkbook

Filter = "Ficheiro XLS (*.xls),(*.xls)"
Caption = "Escolha o ficheiro a importar..."
SelectedFile = Application.GetOpenFilename(Filter, , Caption)
If SelectedFile = False Then Exit Sub
Set wbmes = Workbooks.Open(SelectedFile, 1, 1)
End Sub

Private Sub left()
Dim a As Double
wbmes.Activate
wbmes.Sheets("Total_Refrige").Select
wbmes.Sheets("Total_Refrige").Range(Range("D2"),
Range("D2").End(xlDown)).Copy
wb.Activate
If wb.Sheets("Pivot").Range("G2").Value <> "" Then
wb.Sheets("Pivot").Range("G1").End(xlDown).Offset(1, 0).Select
Else
wb.Sheets("Pivot").Range("G2").Select
End If
a = ActiveCell.Row
wb.Sheets("Total Refrige").Paste
Application.CutCopyMode = False
i = a
While wb.Sheets("Pivot").Range("G" & i).Value <> ""
i = i + 1

Wend
End Sub

Do you have any idea how to solve this?1000 thanks

-- 
--
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 My "Do Loop" statement doesn´t work

[Jorge Marques]

Ah that was fast and PERFECT :), i suppose, cell(i,2), the 2 is for column
B, 3 C 4 D and so on(this is a huge implement in my learning), many many
many thanks Ashish, perfect as always :).

2011/7/14 ashish koul 

> try this
>
> Sub fill2010real()
> Dim i As Long
> i = 1
> 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
>> 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
>>
>> I can´t seem to go around this code :(
>>
>> 1001 thanks to all of you!excel-lent as always :)
>>
>>
>>  --
>>
>> --
>> 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 <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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

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

[Jorge Marques]

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

I can´t seem to go around this code :(

1001 thanks to all of you!excel-lent as always :)

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


2010 Real & false.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ HELP urgent

[Jorge Marques]

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.66 2008 -11 1989 17.01 2005 15.02 2001 -20 1990 21.06 2008 17.01
Is this what you what?

I´m new at this, but i made this code, maybe not very programming accurate,
but the best i did :S

"Sub Colorize()
ActiveSheet.Cells.Interior.ColorIndex = xlNone
For Each Cell In ActiveSheet.UsedRange
If Cell.Value < 0 Then
Cell.Offset(0, -1).Interior.ColorIndex = 38
End If
Next
For Each Cell In ActiveSheet.UsedRange
If Cell.Value < 0 Then
Cell.Offset(0, 0).Interior.ColorIndex = 38
End If
Next
End Sub"

2011/7/13 Rajan_Verma 

>  *Please attach a sample file with more explaination..*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Puneet Jain
> *Sent:* Wednesday, July 13, 2011 12:45 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ HELP urgent
>
> ** **
>
>  
>
> Guys
>
>  
>
> Need Help. 
>
>  
>
> In the series of cash flows, if at anytime the negative falue appears. a
> cell should indicate that negative value along-with the corresponding year
> in which that negative value appears.
>
> 
>
> *Cash Available*
>
>  
>
> 0.00
>
> 6.71
>
> 23.75
>
> 21.06
>
> 17.01
>
> 20.00
>
> 29.66
>
> 21.06
>
> 17.01
>
> 15.02
>
> 24.67
>
> 21.06
>
> 17.01
>
>
> Regards
>
>  
>
> Puneet 
>
> 9899068873
>
> --
>
> --
> 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$$ Help what the hell is wrong with my pivot table?

[Jorge Marques]

Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on the list formulas appears
#NAME.

2011/7/4 ashish koul 

> have you changed name of a name range used 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 time i open the 2 workbooks and make refresh, my
>> calculated fields disappear leaving "#NAME" in the cells, and i have to do
>> the formulas all over again.
>>
>> Anyone knows what is going on?1000 thanks
>>
>> --
>>
>> --
>> 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 <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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

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

[Jorge Marques]

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
the formulas all over again.

Anyone knows what is going on?1000 thanks

-- 
--
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 Formating a dynamic table just some cells

[Jorge Marques]

good,
i tried this way, but i don´t like the results because it´s hard to define
the last row to format

Sub tabela()
'
' tabela Macro
'
'
Range("A7").Select
Range(Selection, Selection.End(xlToRight)).Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlDouble
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThick
End With
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlcontinous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
Range("A7").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown).End(xlDown)).Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlcontinous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With

Range("A7").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown).End(xlDown).End(xlDown)).Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.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 at 3:58 PM, Jorge Marques 
> wrote:
> >
> > 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 keeps changing, i tried to do it with range select and xldown and
> right but it stops on the first non empty cell and doesn´t continue!1000
> thanks
> >
> > Sub copycash()
> > Dim ws As Worksheet
> > Sheets("Pivot Cash").Select
> > Sheets("Pivot Cash").UsedRange.Copy
> > Windows("Comparsheet.xlsx").Activate
> > For Each ws In 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
> > End With
> > Cells.Select
> > Selection.NumberFormat = "#,##0_ ;[Red]-#,##0 "
> > Range("A1").Select
> > Selection.Font.Size = 14
> > Selection.Font.Bold = True
> > Selection.Borders(xlDiagonalDown).LineStyle = xlNone
> > Selection.Borders(xlDiagonalUp).LineStyle = xlNone
> > With Selection.Borders(xlEdgeLeft)
> > .LineStyle = xlContinuous
> > .ColorIndex = 0
> > .TintAndShade = 0
> > .Weight = xlMedium
> > End With
> > With Selection.Borders(xlEdgeTop)
> > .LineStyle = xlContinuous
> > .ColorIndex = 0
> > .TintAndShade = 0
> > .Weight = xlMedium
> > End With
> > With Selection.Borders(xlEdgeBottom)
> > .LineStyle = xlContinuous
> > .ColorIndex = 0
> > .TintAndShade = 0
> > .Weight = xlMedium
> > End With
> > With Selection.Borders(xlEdgeRight)
> > .LineStyle = xlContinuous
> > .ColorIndex = 0
> > .TintAndShade = 0
> > .Weight = xlMedium
> > End With
> > Selection.Borders(xlInsideVertical).LineStyle = xlNone
> > Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
> > Range("A1").Select
> > Cells.EntireColumn.AutoFit
> > Application.CutCopyMode = False
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tr

Re: $$Excel-Macros$$ PDF File

[Jorge Marques]

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 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 Formating a dynamic table just some cells

[Jorge Marques]

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 keeps
changing, i tried to do it with range select and xldown and right but it
stops on the first non empty cell and doesn´t continue!1000 thanks

Sub copycash()
Dim ws As Worksheet
Sheets("Pivot Cash").Select
Sheets("Pivot Cash").UsedRange.Copy
Windows("Comparsheet.xlsx").Activate
For Each ws In 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
End With
Cells.Select
Selection.NumberFormat = "#,##0_ ;[Red]-#,##0 "
Range("A1").Select
Selection.Font.Size = 14
Selection.Font.Bold = True
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Range("A1").Select
Cells.EntireColumn.AutoFit
Application.CutCopyMode = False

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


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

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

[Jorge Marques]

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 Properties button in excel.. I am
> using Excel 2010…
>
>
>
> Please help me.. my all files preview shows internal data and not the
> default excel picture….
>
>
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kiran Kancharla
> *Sent:* Friday, June 03, 2011 10:00 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Excel File icon changed.. wanted to
> retrive
>
>
>
> Hi Anil,
>
> Follow the below steps.
>
> Open the file click the below following steps
>
>
> File > Properties -> Summary -> and Uncheck the "Save Preview
> Picture"
>
> Regards,
> Kiran
>
>
> On Fri, Jun 3, 2011 at 3:18 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
> Hi members,
>
>
>
> My excel file icon got changed and shows the internal data instead of
> standard excel image
>
>
>
>
>
>
>
> I wanted the standard excel image as my file view and not the internal data
> image… please help
>
>
>
> Thanks & Regards,
>
>
>
> Anil Bhange
>
> IP - 512320
>
>
>
> --
>
> --
> 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
>
>
>
>
> --
>
> Thanks & Regards,
>
> Kiran
>
> 9920456606
>
>
>
> --
>
> --
> 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$$ Help on macro to next empty worksheet to another workbook

[Jorge Marques]

It worked perfectly:), 1000 thanks Mahesh

2011/6/1 Mahesh parab 

> Hi
>
> Try :
>
> Sub Test()
> Dim ws As Worksheet
> Sheets("Brands").Select
> Sheets("Brands").UsedRange.Copy
> Windows("Comparsheet.xls").Activate
> For Each ws In 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
> End With
> Application.CutCopyMode = False
> End Sub
>
>
> On Wed, Jun 1, 2011 at 3:37 PM, Jorge Marques wrote:
>
>> 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
>> '
>>
>> Application.ScreenUpdating = False
>> Sheets("Brands").Select
>> Cells.Select
>> Selection.copy
>> Windows("Comparsheet.xlsx").Activate
>> Sheets("Sheet1").Select  --> I think i
>> have to change this but i don´t know how!
>> Cells.Select
>> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
>> SkipBlanks _
>> :=False, Transpose:=False
>> Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
>> SkipBlanks:=False, Transpose:=False
>> Windows("Brand.xlsx").Activate
>> Range("A1").Select
>> Application.ScreenUpdating = True
>>
>> End Sub
>>
>> --
>>
>> --
>> 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

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

[Jorge Marques]

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
'

Application.ScreenUpdating = False
Sheets("Brands").Select
Cells.Select
Selection.copy
Windows("Comparsheet.xlsx").Activate
Sheets("Sheet1").Select  --> I think i have
to change this but i don´t know how!
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Windows("Brand.xlsx").Activate
Range("A1").Select
Application.ScreenUpdating = True

End Sub

-- 
--
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$$ fixing Format of pivot table noit working

[Jorge Marques]

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 macro on activesheet but i don´´t know how to assign
the macro to the pivot, i have to change the name of the pivot in the
macro!thank you very much in advance

-- 
--
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$$ Fwd: Help on my solution, can´t seem to dynamic the pivot table with month macro

[Jorge Marques]

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 when i put info it puts the new data, when i do fill
> again the dynamic stops at row 128 when it should stop in 155, and if i run
> it again it gives the error as you can see from cells, As you can see i have
> a lot of if formulas and vlookups, if anyone has any sugestion to lighten
> the excel i appreciate, i annex the excels in order to feel free to use if
> gives any use! :), the source file is source monthly and destination the
> report.
>
> Fil the excel a little to test, a 1000 thanks :)
>
> --
>
> --
> 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$$ Ashish Koul : Most Helpful Member - March 2011

[Jorge Marques]

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, NOORAIN ANSARI 
> wrote:
>
>> Congrats Ashish..Keep it up
>>
>>  On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
>>
>>> Hello Everyone,
>>>
>>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>>> March'11
>>> He has posted 48 posts in March 2011 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum and
>>> achieved this recognition from last four months.This is really awesome.
>>>
>>> ASHISH, Many Many thanks for the incredible support to group.
>>>
>>> This is a record achievement by anyone since we launched the recognition.
>>> Let see who will break Ashish's record. :)
>>>
>>> *I have published the same on discussexcel.com homepage.*
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
>
> Warm Regards,
> Aindril De
> Unified Learning Pvt Ltd.
> Ph: 9811300157
>
>   --
>
> --
> 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$$ copy macro error

[Jorge Marques]

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("a65356").End(xlUp).Row,
> 1).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues
> End With
>
>
> End Sub
>
>
>   On Wed, Apr 6, 2011 at 10:50 AM, Dave Bonallack <
> davebonall...@hotmail.com> wrote:
>
>> Hi Jorge,
>> Your workbook didn't contain any macros.
>> Regards - Dave
>>
>> --
>> Date: Tue, 5 Apr 2011 23:40:56 +0100
>> Subject: $$Excel-Macros$$ copy macro error
>> From: leote.w...@gmail.com
>> To: excel-macros@googlegroups.com
>>
>>
>> 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
>> destino, but it only copys last cell of A :S!can someone see what´s wrong
>> with my code?1000 thanks!
>>
>>  Sub Datacopy()
>>
>> Worksheets("teste").Cells(Rows.Count, "A").End(xlUp).Copy
>>
>> With Worksheets("destino")
>>   .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
>> Paste:=xlPasteValues
>> End With
>>
>> End Sub
>>
>> --
>>
>> --
>> 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
>

-- 
--
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$$ copy macro error

[Jorge Marques]

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 destino,
but it only copys last cell of A :S!can someone see what´s wrong with my
code?1000 thanks!

Sub Datacopy()

Worksheets("teste").Cells(Rows.Count, "A").End(xlUp).Copy

With Worksheets("destino")
  .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
Paste:=xlPasteValues
End With

End Sub

-- 
--
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.xlsm
Description: Binary data

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

[Jorge Marques]

Both ways worked perfectly, but in =MID(B2,2,SEARCH(" ",B2)-2) i had to put
=MID(B2,1,SEARCH(" ",B2)-1) in order to give me full word.

Thank you both, very much for your help. :), excel-lent as always!

2011/3/24 Ms-Exl-Learner . 

> Try this…
>
>
> =IF(ISNUMBER(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, 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
>>
>> --
>>
>> --
>> 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$$ Help on a simple question

[Jorge Marques]

Yes but isn´t that available only to office2010? i use office2007 at work i
think it´s retro compatible but only in view form right?

Anyway, i have to do a different way now, they decided they what 3 separate
files, a database for each report, and my problems now are different, i´m
dealing with problems like, not overwriting the data when i put a new month
into to pivot, put the month in a certain cell( I use =year(today()) for
year, but doing it with month, gives me a stupid error, don´t know why),

I have to ask help again, but only when i have my database defined!my ideia
now is merging files selecting the file directly(like whem i close a month,
i open database, choose month to update and it merges only certain cells to
certain cells of the pivot starting from the first blank cell of the pivot
ir order not to overwrite files!)

i tried it  with recording macro, and changing 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.com] *On Behalf Of *Jorge Marques
> *Sent:* Thursday, March 10, 2011 5:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Help on a simple question
>
>
>
> I have a doubt dear friends, i have 3 reports i receive each month, so
> every month i have to to an overall report of the 3 like a database, but the
> format of the data isn´t equal and doesn´t allow to do a pivot table,  my
> idea was to create 3 pivotreports (by putting in pivot format and linking
> them to the original) each with the 12 months and in the final workbook i
> can see all information, my difficulty is how when i receive the monthly
> report i send the data to the pivot table created for that report to the
> respective month, each pivot table has 10.000 lines, if i put each monthly
> report 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://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

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

[Jorge Marques]

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

-- 
--
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 on a simple question

[Jorge Marques]

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, 2011 at 6:32 PM, Jorge Marques wrote:
>
>> I have a doubt dear friends, i have 3 reports i receive each month, so
>> every month i have to to an overall report of the 3 like a database, but the
>> format of the data isn´t equal and doesn´t allow to do a pivot table,  my
>> idea was to create 3 pivotreports (by putting in pivot format and linking
>> them to the original) each with the 12 months and in the final workbook i
>> can see all information, my difficulty is how when i receive the monthly
>> report i send the data to the pivot table created for that report to the
>> respective month, each pivot table has 10.000 lines, if i put each monthly
>> report 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://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 <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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

$$Excel-Macros$$ Help on pivot table

[Jorge Marques]

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
carefull not to mix the values.thank you very much in advance

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


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

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

[Jorge Marques]

I have a doubt dear friends, i have 3 reports i receive each month, so every
month i have to to an overall report of the 3 like a database, but the
format of the data isn´t equal and doesn´t allow to do a pivot table,  my
idea was to create 3 pivotreports (by putting in pivot format and linking
them to the original) each with the 12 months and in the final workbook i
can see all information, my difficulty is how when i receive the monthly
report i send the data to the pivot table created for that report to the
respective month, each pivot table has 10.000 lines, if i put each monthly
report 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://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$$ Re: very urgent

[Jorge Marques]

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
>excel pivot table macro
>
> Hope this helps.  If I'm not understanding what you need, give me more
> info.
>
> Jim
>
>
> On Mar 7, 6:06 am, vijayajith VA  wrote:
> > Hello all
> >
> > I need some pivot table examples both excel and macros.
> >
> > can you mail me with excel sheets..
> >
> > please very urgent
> >
> > Thankyou
>
> --
>
> --
> 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


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

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

[Jorge Marques]

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 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..
> AS, BT, BU, CA,CB, CH, CI, CO,CP,CV,CW,DX,DY,EE,EF
>
> workbook2 -
> same conditions as workbook1
>
> workbook3
>
> same range of cells, but sheet 1,sheet2,sheet3, sheet4
>
> is there a way to merge this 3 workbooks in one with this profile
>
> workbook1 sheet2 goes to sheet 1 of final workbook
>
> workbook2 sheet 2 goes to sheet 2 of final workbook
>
> workbook sheet1,2,3,4 goes respectively to 3,4,5,6 of merged workbook
>
> i put attached the workbook than was previously kindly developed by experts
> in this forum.
>
> Thank you very much for everyone
>
>
>
> --
>
> --
> 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 on merging certain sheets to final workbook

[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 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..
AS, BT, BU, CA,CB, CH, CI, CO,CP,CV,CW,DX,DY,EE,EF

workbook2 -
same conditions as workbook1

workbook3

same range of cells, but sheet 1,sheet2,sheet3, sheet4

is there a way to merge this 3 workbooks in one with this profile

workbook1 sheet2 goes to sheet 1 of final workbook

workbook2 sheet 2 goes to sheet 2 of final workbook

workbook sheet1,2,3,4 goes respectively to 3,4,5,6 of merged workbook

i put attached the workbook than was previously kindly developed by experts
in this forum.

Thank you very much for everyone

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


merge_from_different_workbooks_for_all_sheets.xlsm
Description: Binary data

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

[Jorge Marques]

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,TRUE,FALSE)
>
>
> I only modified Paul's formula. So, Thanks Paul.
>
>
>
>
>  --
>  Excel VBA Interview 
> Questions
>   Collection of Excel VBA 
> Macros
>   
> VLOOKUP
>   
> OFFSET
>   ARRAY 
> formulas
>
> --
> Excel 2003 Style Menu in Excel 
> 2007
> Custom Number 
> Format
>
> SUMIFS
>   CONTACT a 
> TRAINER
>
> 
> --
>
>
>
>
>
> Thanks & Regards
> --
>  Ashish Jain
> (Microsoft Certified Application Specialist)
> (Microsoft Certified Professional)
> http://www.excelitems.com
> http://www.openexcel.com
>
> Facebook  
> Twitter
>  LinkedIn   
> LiveJournal
>Digg    
> Delicious
>Subscribe by 
> Email
> --
>
>   --
>
> --
> 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 needed - Extract data by customer name

[Jorge Marques]

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 the sheet1, which contains multiple data entries for the
> same customer.
>
> I am trying to extract each customer data in separate sheet (Extract_Data)
> and at the same time calculating the average price & sum of the total
> quantity shipped to the particular customer.
>
> When I enter any new data in the sheet1, Extract_Data sheet should update
> automatically. If there is a new customer entry than also the extract data
> sheet should get update automatically with the new customer data.
>
> I have attached the 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
>

-- 
--
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$$ Fwd: Help on formula

[Jorge Marques]

Ahh perfect it condenses the 4 conditions to at least 2, it´s still a little
confusing for me to put formula into formulas and organize them. 1001 thanks
Paul, Excellent as usual :)

2011/3/3 Paul Schreiner 

> I would use:
> =IF(IF(P3>T3,1,0)+IF(Q3>U3,1,0)+IF(R3>V3,1,0)+IF(S3>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 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 have lower values comparing to the
> same quarters of 2009 the formula gives true else false like if Q1 2009 > Q1
> 2010 and so on,
>
> or(and(P3>T3, Q3>U3), and(Q3>U3, R3>V3...) and so on, is it really
> necessary to do all the possible combinations in this formula?thank you very
> much in advance
>
> I put in attach the excel file. 1000 thnks
>
> --
>
> --
> 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

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

[Jorge Marques]

 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 have lower values comparing to the same
quarters of 2009 the formula gives true else false like if Q1 2009 > Q1 2010
and so on,

or(and(P3>T3, Q3>U3), and(Q3>U3, R3>V3...) and so on, is it really necessary
to do all the possible combinations in this formula?thank you very much in
advance

I put in attach the excel file. 1000 thnks

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


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

$$Excel-Macros$$ Help on formula

[Jorge Marques]

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 have lower values comparing to the same
quarters of 2009 the formula gives true else false like if Q1 2009 > Q1 2010
and so on,

or(and(P3>T3, Q3>U3), and(Q3>U3, R3>V3...) and so on, is it really necessary
to do all the possible combinations in this formula?thank you very much in
advance

I put in attach the excel file

-- 
--
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$$ Group Survey : Your feedback is important.

[Jorge Marques]

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 feel about the group, So that I
> can take any action or initiative on the basis of your feedback.
> This is an anonymous survey , so feel free to share your views and the
> activities you would like to see in this group. Your valuable feedback is
> highly appreciated.
>
> To participate in survey, Please follow the below link
> http://www.surveymonkey.com/s/L8BTDNQ
>
> Thanks again and Keep Posting. :)
>
> 18 days left for the launch of discussexcel.com...Stay tuned...
>
> Best regards,
> Ayush Jain
> Group Manager
>
> P.S. I send this feedback email every month. If you have already
> participated , You may ignore this email.  If you want to give feedback or
> suggestion again, You are most welcome.
>
> --
>
> --
> 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$$ Macro issue passing values from Cell to columns

[Jorge Marques]

Yes exactly like you demonstrated :), sorry for my poor explanation, i can
do it if i separate first to columns, but can it be done all at the same
time?

2011/2/14 Paul Schreiner 

>  I'm still not sure what you're trying to do.
> Your original data looked something like:
> A;11;21;31;1
> B;12;22;32;2
> C;13;23;33;3
> D;14;24;34;4
> E;15;25;35;5
> F;16;26;36;6
> G;17;27;37;7
> H;18;28;38;8
> I;19;29;39;9
>
> You split it into separate columns, using ";" as a delimeter..
>
> Now you're saying that you want to move
> the "19" from the last line in column "B" to column "C" of the first line?
> Then the "18" from Column "B" in the second to last line, to the second
> line of column "C"?
>
> I'm sure I can do that with a loop...
> but is that what you mean?
> What do you want to the do with the value already in column "C"?
>
> Paul
>
>  --
> *From:* Jorge Marques 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sun, February 13, 2011 10:54:40 AM
>
> *Subject:* Re: $$Excel-Macros$$ Macro issue passing values from Cell to
> columns
>
> I have names from cell B1 to cell B1000, but sometimes i need to pass the
> B1000 to C1 B999 to C2 and so on, i don´t know if this is a stupid question
> lol, because i can do it by putting a filter in it in 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
>>
>>  --
>> *From:* Jorge Marques 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Sat, February 12, 2011 9:47:21 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ Macro issue passing values from Cell to
>> columns
>>
>> Oh ok Paul, i did it that way, because i recorded it first, then defined
>> the Range("A" & i), but it´s good now, millions thanks, the activecell i did
>> remember to leave just the range, still taking baby steps in this :)
>>
>> I forgot to mention, after this  i have to switch the cells, the Last A
>> goes to the first B, like inverting the order, is this possible?thanks
>>
>> 2011/2/12 Dave Bonallack 
>>
>>> Hi Paul,
>>> I'm really interested in the part of the macro that I have highlighted
>>> below (in case the highlighting doesn't travel well, I've marked each line
>>> with a *)
>>> I've not seen the 'Split' function before. I looked it up in the Help,
>>> but still couldn't make sense of it. If you have time, could you please
>>> explain that part?
>>> Regards - Dave.
>>>
>>> --
>>> Date: Fri, 11 Feb 2011 06:15:45 -0800
>>> From: schreiner_p...@att.net
>>> Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to
>>> columns
>>>
>>> To: excel-macros@googlegroups.com
>>>
>>>  Curious...
>>> Actually, the Activecell object is not necessary.
>>>
>>> I changed it to:
>>>
>>> If Range("A"&i) = "" then exit sub else
>>>
>>> and it worked just fine.
>>>
>>> BTW:
>>> I changed the loop to:
>>>
>>> Application.ScreenUpdating = False
>>> For R = 1 To 1000
>>> If (Range("A" & R).Value = "") Then Exit Sub
>>> **StrArray = 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 "flashing" that goes on with TextToColumns.
>>>
>>> Paul
>>>
>>>  --
>>> *From:* Jorge Marques 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Thu, February 10, 2011 6:46:37 AM
>>> *Subject:* $$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!i

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

[Jorge Marques]

I have names from cell B1 to cell B1000, but sometimes i need to pass the
B1000 to C1 B999 to C2 and so on, i don´t know if this is a stupid question
lol, because i can do it by putting a filter in it in 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
>
>  ------
> *From:* Jorge Marques 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sat, February 12, 2011 9:47:21 AM
>
> *Subject:* Re: $$Excel-Macros$$ Macro issue passing values from Cell to
> columns
>
> Oh ok Paul, i did it that way, because i recorded it first, then defined
> the Range("A" & i), but it´s good now, millions thanks, the activecell i did
> remember to leave just the range, still taking baby steps in this :)
>
> I forgot to mention, after this  i have to switch the cells, the Last A
> goes to the first B, like inverting the order, is this possible?thanks
>
> 2011/2/12 Dave Bonallack 
>
>> Hi Paul,
>> I'm really interested in the part of the macro that I have highlighted
>> below (in case the highlighting doesn't travel well, I've marked each line
>> with a *)
>> I've not seen the 'Split' function before. I looked it up in the Help, but
>> still couldn't make sense of it. If you have time, could you please explain
>> that part?
>> Regards - Dave.
>>
>> --
>> Date: Fri, 11 Feb 2011 06:15:45 -0800
>> From: schreiner_p...@att.net
>> Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to
>> columns
>>
>> To: excel-macros@googlegroups.com
>>
>>  Curious...
>> Actually, the Activecell object is not necessary.
>>
>> I changed it to:
>>
>> If Range("A"&i) = "" then exit sub else
>>
>> and it worked just fine.
>>
>> BTW:
>> I changed the loop to:
>>
>> Application.ScreenUpdating = False
>> For R = 1 To 1000
>> If (Range("A" & R).Value = "") Then Exit Sub
>> **StrArray = 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 "flashing" that goes on with TextToColumns.
>>
>> Paul
>>
>>  --
>> *From:* Jorge Marques 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Thu, February 10, 2011 6:46:37 AM
>> *Subject:* $$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!i
>> think the issue is on the "if" statement, but if i take it out, it does the
>> macro well but indicates error in the end!
>>
>> Sub Macro2()
>> '
>> ' Macro2 Macro
>> '
>> ' Keyboard Shortcut: Ctrl+p
>> '
>> Dim i As Double
>> i = 1
>>
>> While ActiveSheet.Select
>> If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
>> Range("A" & i).Select
>> Selection.TextToColumns Destination:=Range("A" & i),
>> DataType:=xlDelimited, _
>> TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
>> Tab:=True, _
>> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
>> OtherChar _
>> :=";", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
>> TrailingMinusNumbers:=True
>> i = i + 1
>> Wend
>> End Sub
>>
>>
>> Thank you very much for your help
>>
>> --
>>
>> --
>> 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://exceld

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

[Jorge Marques]

Oh ok Paul, i did it that way, because i recorded it first, then defined the
Range("A" & i), but it´s good now, millions thanks, the activecell i did
remember to leave just the range, still taking baby steps in this :)

I forgot to mention, after this  i have to switch the cells, the Last A goes
to the first B, like inverting the order, is this possible?thanks

2011/2/12 Dave Bonallack 

>  Hi Paul,
> I'm really interested in the part of the macro that I have highlighted
> below (in case the highlighting doesn't travel well, I've marked each line
> with a *)
> I've not seen the 'Split' function before. I looked it up in the Help, but
> still couldn't make sense of it. If you have time, could you please explain
> that part?
> Regards - Dave.
>
> --
> Date: Fri, 11 Feb 2011 06:15:45 -0800
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to
> columns
>
> To: excel-macros@googlegroups.com
>
>  Curious...
> Actually, the Activecell object is not necessary.
>
> I changed it to:
>
> If Range("A"&i) = "" then exit sub else
>
> and it worked just fine.
>
> BTW:
> I changed the loop to:
>
> Application.ScreenUpdating = False
> For R = 1 To 1000
> If (Range("A" & R).Value = "") Then Exit Sub
> **StrArray = 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 "flashing" that goes on with TextToColumns.
>
> Paul
>
>  --
> *From:* Jorge Marques 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, February 10, 2011 6:46:37 AM
> *Subject:* $$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!i
> think the issue is on the "if" statement, but if i take it out, it does the
> macro well but indicates error in the end!
>
> Sub Macro2()
> '
> ' Macro2 Macro
> '
> ' Keyboard Shortcut: Ctrl+p
> '
> Dim i As Double
> i = 1
>
> While ActiveSheet.Select
> If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
> Range("A" & i).Select
> Selection.TextToColumns Destination:=Range("A" & i),
> DataType:=xlDelimited, _
> TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
> Tab:=True, _
> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
> OtherChar _
> :=";", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
> TrailingMinusNumbers:=True
> i = i + 1
> Wend
> End Sub
>
>
> Thank you very much for your help
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><>

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

[Jorge Marques]

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!i
think the issue is on the "if" statement, but if i take it out, it does the
macro well but indicates error in the end!

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+p
'
Dim i As Double
i = 1

While ActiveSheet.Select
If ActiveCell.Range("A" & i) = "" Then Exit Sub Else
Range("A" & i).Select
Selection.TextToColumns Destination:=Range("A" & i),
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar
_
:=";", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
TrailingMinusNumbers:=True
i = i + 1
Wend
End Sub


Thank you very much for your help

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


macropass values to columns.xlsm
Description: Binary data

$$Excel-Macros$$ Counting words or letters

[Jorge Marques]

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

[Jorge Marques]

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
>
> --- On *Wed, 1/19/11, Kal xcel * wrote:
>
>
> From: Kal xcel 
> Subject: $$Excel-Macros$$ Sales Dashboard
> To: excel-macros@googlegroups.com
> Cc: "NOORAIN ANSARI" , "Dilip Pandey" <
> dilipan...@gmail.com>, "koul.ashish" , "ayush jain"
> , "anandydr" ,
> davebonall...@hotmail.com, "C.G.Kumar" 
> Date: Wednesday, January 19, 2011, 1:43 PM
>
>
>  Dear All,
>
>
> I am sharing two types of outlook of a Sales Dashboard which I am preparing
> for my company. I need your honest comment that looks wise which one is
> better.
>
>
>
> Thanks in advance
>
> Kalyan
> --
>
> --
> 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$$ Macro with condition

[Jorge Marques]

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:
>
>> 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
>> copy the value of B16 to the cell E2
>>
>> i annexed a excel example
>>
>> Thank you very much in advance :)
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Macro with condition

[Jorge Marques]

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
copy the value of B16 to the cell E2

i annexed a excel example

Thank you very much in advance :)

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

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

[Jorge Marques]

It worked perfectly, a thousand thank you for your help :)

2010/11/29 ashish koul 

> try this
>
> Sub Macro1()
> Dim z As Long
>
>Sheets("Folha1").Activate
>  If Sheets("Folha1").FilterMode Then
> Sheets("Folha1").ShowAllData
>   End If
>
>Sheets("Folha1").Range("a65356").Select
> Selection.End(xlUp).Select
>z = ActiveCell.Row
>
> Sheets("Folha1").Range("$A$6:$J" & z).AutoFilter Field:=10,
> Criteria1:="true"
> Selection.Copy
> Sheets("Folha2").Select
> Range("a1").Select
>   Sheets("Folha1").AutoFilter.Range.Copy Sheets("Folha2").Range("A1")
>
>
> If Sheets("Folha1").FilterMode Then
> Sheets("Folha1").ShowAllData
>   End If
>
> End Sub
>
>
> On Mon, Nov 29, 2010 at 12:59 AM, Jorge Marques wrote:
>
>> 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
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

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

[Jorge Marques]

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

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

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

[Jorge Marques]

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
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts