157 Visitor Messages

  1. View Conversation
    Hi,

    You were a great help previously and was hoping you would be able to nail this problem I have on the head. I did give it a go myself, from details you had previously helped me with, but my lack of knowledge of what you did regarding a 'dynamic named range' has stumped me!

    I have put my query up on the forum here:
    http://www.excelforum.com/excel-gene...65#post2700665

    Any help would be very much appreciated.
    Cheers
    Glenn
  2. View Conversation
    Thank you for the rep!
  3. View Conversation
    Hi JB,

    Could you please see if you could assist me:

    http://www.excelforum.com/excel-gene...ste-macro.html

    Thank you
  4. View Conversation
    Hi, I hope this doesn't breach protocols, it is not my intent however I have found this site very useful, you and others have my utmost respect so I apologise if I have made a mistake here. Please tell me if I have, and I won't do it again.

    I’ve just seen your response and outcome at:

    My query is located at:


    The ultimate outcome is located in the file uploaded with the original query - GOIT907 sheet shaded in Green – the real data (changed with fake names etc.) is in the last two uploaded responses. The only issue I have is getting the data to align, that is where a recognised client has undertaken a unit, the result, name, and unit appear on the same line.

    I thank you in anticipation, Regards Chris.
  5. View Conversation
    Hi JBeaucaire,

    You helped me with my Pipeline Project spreadsheet a week or two ago. You worked out a way to copy data from the main sheet to a new row on another sheet.
    This is awesome and runs perfect, but I'm having trouble sorting the data that's been copied across. I've found a VBA code that places an invisible rectangle at the top of the column that you can click on to sort the data in the column, but I couldn't seem to get it working, so figuring a sort option may not be available because the data had been moved across I tried a regular sort and that did nothing either.
    It's an important part of the sheet that data can be sorted at the user's preference. Is there a way I can modify what you gave me to allow for this?
    Thanks heaps.
  6. View Conversation
    My dad used to make the "P is silent..." joke all of the time when I was a lad, and now it's earned me my third bright green pip.

    Who'd have thought that remembering your dad's rubbish jokes was more valuable round here than if I actually, say, knew anything about Excel

    Thanks for the rep.
  7. View Conversation
    Hello, Would you be able to help me with my post?

    http://www.excelforum.com/excel-work...ml#post2594133

    I'm having trouble trying to find like numbers and match up all dupes.

    Thank you,
    Sonia
  8. View Conversation
    Hi,

    I found a brilliant post you left a few years ago via Google to add a prefix to numbers entered, the code you suggested was:
    ______________________________________________________

    Option Explicit

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cell As Range
    Application.EnableEvents = False

    For Each cell In Target
    If Not Intersect(cell, Range("A:A")) Is Nothing Then _
    If IsNumeric(cell) Then cell = "XX" & cell.Value
    Next cell

    Application.EnableEvents = True
    End Sub
    ______________________________________________________

    Could you tell me how the code could be amended to ensure the XX disappears when the number is deleted?

    Many thanks,

    Adele
  9. View Conversation
    Dear Mr. Beaucaire,
    I just posted on Excel Forum for the first time but have become a quick fan of yours in my search of macros. I am hopeful that I will be so lucky as to have you take a look at my request. I have worked on this for three days straight now and am unable to find a macro that will work for me. http://www.excelforum.com/excel-prog...ete-macro.html
  10. View Conversation
    Hi
    Can you please help me out with the below post
    http://www.excelforum.com/excel-gene...ml#post2576487
Showing Visitor Messages 1 to 10 of 157
Page 1 of 16 12311 ... LastLast
Page 1 of 16 12311 ... LastLast
About JBeaucaire

Basic Information


Date of Birth
July 16, 1963 (48)
About JBeaucaire
Location:
Bakersfield, CA
Interests:
Rockets, Reading, Writing, Movies
Occupation:
Computer Trainer
My Microsoft Office Version:
2010

Signature


_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros

If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]

“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)

Contact


This Page
http://www.excelforum.com/members/jbeaucaire.html
Instant Messaging

Send an Instant Message to JBeaucaire Using...

Statistics


Total Posts
Total Posts
18,176
Posts Per Day
12.80
Last Post
Extracting data from a parts list? Today 08:37 PM
Visitor Messages
Total Messages
157
Most Recent Message
02-06-2012 11:44 AM
General Information
Last Activity
Today 08:38 PM
Join Date
03-21-2008

41 Friends

  1. AnanthakrishnanK AnanthakrishnanK is offline

    Registered User

    AnanthakrishnanK
  2. anuj_sethi1043 anuj_sethi1043 is offline

    Registered User

    anuj_sethi1043
  3. anwitha anwitha is offline

    Registered User

    anwitha
  4. Birnen Birnen is offline

    Registered User

    Birnen
  5. chacha chacha is offline

    Registered User

    chacha
  6. Charlie_Howell Charlie_Howell is offline

    Valued Forum Contributor

    Charlie_Howell
  7. Chuvawow.com Chuvawow.com is offline

    Registered User

    • Send a message via MSN to Chuvawow.com
    • Send a message via AIM to Chuvawow.com
    • Send a message via Yahoo to Chuvawow.com
    Chuvawow.com
  8. dagindi dagindi is offline

    Valued Forum Contributor

    dagindi
  9. darkbearpooh1 darkbearpooh1 is offline

    Registered User

    darkbearpooh1
  10. draco102000 draco102000 is offline

    Registered User

    draco102000
Showing Friends 1 to 10 of 41
Page 1 of 5 123 ... LastLast

Search Engine Friendly URLs by vBSEO 3.2.0