Posts by samuels90

Re: Inserting text in Mid String

Thanx to "ByTheCringe2" & Richie for your assistance.

Richie, I have purchased a tutorial. I had used the =concatenate feature, but thought a more straight forward function would do the trick.

Is there any function or methodology to insert text in mid string?

ex. I would like to insert a string after the dashes below.
0506-40365503970
0506-40365752746
0506-40365994154

Re: Looping Macro with Multiple Criteria

Thank you for the advise!

Re: Looping Macro with Multiple Criteria

Thank you for your response "Norie". Do you have any suggestion? I am thinking that the more coding I see the more efficient I could become at coding.

I would like to write a macro that would accomplish the following:

Check (b2..b65k) <> 6710 or 6720
ActiveCell "6400"

Loop

In words. I would like to check for each type account numbers in the cell to the right, if neither occur, then in the activecell write 6400.

I want to say "Thank You" in advance for any help I receive, and I would like to members to know its is very much appreciated.

Attached is a copy of what my Pivot Table looks like. I would like to insert Sub-totals within the Pivot table to sum all the '05 & '06 activities separately.

Thank you.

Re: Compile error: Sub or function not defined

Thank you.

Will you please give me an example here (my code is below), and an explanation for it.

Sub ODSPractice()
'
' ODSPractice Macro
' Keyboard Shortcut: Ctrl+S
'
Worksheet("Sheet1").Activate
Column("BA:BA").Select
Selection.Copy
Worksheet("Sheet3").Activate
Range("A1").Select
ActiveSheet.Paste
Worksheet("Sheet1").Activate
Column("B:J").Select
Selection.Copy
Worksheet("Sheet3").Activate
Range("B1").Select
ActiveSheet.Paste
Worksheet("Sheet1").Activate
Column("R:R").Select
Selection.Copy
Worksheet("Sheet3").Activate
Range("K1").Select
ActiveSheet.Paste


End Sub

Can someone explain the concept of defining the "Sub" to me.

Thank you.

I recorded a function and got the message box "Invalid Outside Procedure" when I tried to run the macro. I don't understand what it means or how to prevent it.

Thank you.

Re: Inserting Field in Pivot Table

Attached is an example, I hope I did the attachment correctly.

I have a pivot table that picks up the month an invoice was generated.

Since I have several invoices for a few months in 2005, I would like to sum all the 2005 invoices into one column. I have the impression that I can insert a field within a Pivot table to sum all the amounts related to 2005.

Thank you for your responses.

Please tell me what is wrong with the following code.

ActiveCell.Offset(2, -15).Range("A:A").Select

I am trying to go 15 columns left and 2 rows down.

Thank you.

Re: Macro to identify duplicates

I am sorry but I did not see the change.

I would have applied the formula you suggest, but I find my self doing this process so often, I'd rather have a macro to call. In addition, I am trying to learn to write macros.

Thank you.

Re: Macro to identify duplicates

Thank you.

What would I change in the macro to have the "1" be placed parallel to the second occurence of the duplicate? For instance if A2=A3 place the number 1 in B3.

I am trying to write a macro to check for duplicate numbers. My logic is as follow:

If(A2-A3=0) Then 
B3=1

I want to write the macro as follow:

Select Check>0
Do While Check <885
If(A2-A3=0) Then
B3=1
End If
Loop

I would appreciate some help with writing the (A2-A3) and B3 arguments, and to point out any other dumb mistake I made.

Thank you.

Can someone remind me of the reason why a Vlookup would not return the desired result in the cell. I am quite sure my syntax is correct.

Thank you.

I want to construct the syntax to find K1 if C1=Cat & D1=Dog. Similar to Vlookup except for double criteria.

Thank you.

Re: V-lookup

Here is my attachment.

I am not getting the desired return because my "anchor" value in my target sheet, does not seem to be the same in my source sheet. How do I get them to be the same?

I don't know how to attach the file.

For example:

Wynne/HT Company #
002 1
004 1
005 1
008 1
010 1

Loc Co#
002 1
002 1
002 1
002 1
002 1
002 1
002 1
004 #N/A
004 #N/A

I was able to get the info. returned below, because I copied all the 002 above to the list below. I am not getting anything for 004 because I don't think they are the same thing, even though they appear to be to my eyes.