JBeaucaire
Forum Guru

Thanks for the reputation. Appreciate it.

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

Thank you for the rep!

Hi JB,

Could you please see if you could assist me:

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

Thank you

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.

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.

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.

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

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

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