Posts by JJeffery99

    Hi all,

    I have attached the document for you to review and I'm struggling to work out how I would go about removing all companies names which don't appear at least 4 times in column A on the attached. So as an example 1313 Global would remain on the list but Altered States FX Limited in row 1288 would be removed as it only appears once, same goes for the next two companies after that.

    Once i have removed all companies that don't appear at least 4 times, I will then remove duplicates which i can do so i have a lsit of companies who have appeared at least 4 times in the list.

    Any advice would be appreciated.

    Hi Roy,

    Thanks for assisting i appreciate the help, it still says mismatch on that line as an error code. Is it a problem with the code as a whole or?

    Kind regards

    ' Define PDF filename
    PdfFile = Application.InputBox("Please provide a name for the PDF")
    If PdfFile = False or PdfFile = "" Then
    MsgBox "No name provided"
    Exit Sub
    End If

    Hi all,

    I have the attached code currently to send my activesheet as a pdf in an email. Please can someone advise a fix for me to choose a custom filename instead of it being the document name?



    End Sub

    Hi Roy,

    I thought i provided the information required i do apologize. It would need to do both, so if i type in 500 it would add, if i typed in -500 it would subtract as it would be trying to add a negative?

    You would be typing in J8:40, and it would be adding/subtracing from the cell to the left. (i8:400)

    Please let me know if you are on the same wave length!

    Thanks for your help, if i wanted to make this the case for section J8:400, so when you type in any cell in J8:400, it will add/subtract to the one beside it. So typing in J8 would add/subtract from I8, typing in J50 would add/subtract from I50 and so on

    Hi all,

    Hope everyone is keeping well!

    Im not sure if a code or formula is required. What im looking to do is when i have a value in cell a1, if i type a value into cell a2, it will automatically add that value to cell a1. It will then clear the cell a2 ready for the next time a value is typed in it.

    Any help would be appreciated!

    Hi mumps,

    I got this working after editing what you put slightly, i have attached the code to show you what i changed :)

    Thank you very much for your help as id have had no clue!

    Good morning all,

    Below i have a code for transferring data upon saving the document. I was wondering how i would make this work if the other workbook was not open but closed, does anyone know how this works or any place i can learn how to do this? Any help or advice would be greatly appreciated.

    I have another question, if i wanted to get this data to be sent across to another document which is not open, please can you advise how i may do that? As currently both documents need to be open but im trying to see if there is a way of getting the data sent across to a document which is not open.

    Any help or advice would be greatly appreciated.

    Hi all,

    Currently i have the below code which transfers data when the document is saved to another excel document. I would like to enhance this further by only transferring data if certain cells arent blank.

    So the above is the current where code is at now, but what i need it to do is if cell Ci51 is not blank on sheet "Standard Quote Details", then i need when saving the data from sheet "datafeed" a2 to i2 is transferred across, if Ci69 isnt blank then a3 to i3 is transferred across, if ci87 is not blank then a4 to i4 is transferred over. If all of them arent blank they all transfer, if one is blank and the other two arent then only two transfer over etc. As currently all 3 of them transfer over regardless and i have to manually delete out the ones i dont need.