Search:

Type: Posts; User: 5h1v; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    http://s000.tinyupload.com/index.php?file_id=69455162262787379040

    added a sheet to see the contact details. would also like it if the emails would hide columns A,B and U-BH if possible.

    Thanks...
  2. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    Sure I can do that I was just going from a listing from my head but I will enter a reference on a separate sheet apologises.
  3. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    That works but I need the name in the supplier column to relate to the suppliers email address, I don't want every supplier to receive every email
  4. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    Anymore help would be greatly appreciated.
  5. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    Sure I will try;

    Do you want to send mail by outlook? - Yes
    Do you want to generate a file with the filtered information and send the file? - Yes
    What name will the file have? - "DD/MM/YY...
  6. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    That works, but how does it send an email to each supplier who will have a different email address?
  7. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    I have put some fake values in and uploaded it here;
    http://s000.tinyupload.com/index.php?file_id=42230483278500529027

    Thanks again for the help
  8. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    I have and the email is generated but the attached file is blank
  9. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    Thanks, sorry if I was not clear.

    I have uploaded a demo of what the file looks like here;

    http://s000.tinyupload.com/index.php?file_id=02581266865533953545


    To which email? - This will...
  10. Replies
    19
    Views
    529

    Re: Filter cells and emial filter result

    Thanks for he reply.

    Yes send by Outlook
    Yes please
    The name of the email and the file would be todays date and the supplier name
    The body of the email, would just be "Hi XXX, Please see...
  11. Replies
    19
    Views
    529

    Filter cells and emial filter result

    Hey,

    I am hoping you could help me, I want to filter a worksheet on the name of a supplier(column C) and on todays date (Column T) and then email them columns C:T from that filtered information...
  12. Pivot table Weighted average not the sum of its parts - why?

    I have a pivot table that is working out weighted average, now my issue is that the Grand total does tie back to the line by line version, any idea why?

    The Grand total is saying 78.56% but if I...
  13. Replies
    12
    Views
    276

    Re: Excel saving a file witout quotations

    Just tried this and it works perfectly, thank you so much this will save me so much time removing the excess characters.
  14. Replies
    12
    Views
    276

    Re: Excel saving a file witout quotations

    Thanks

    That makes sense, how would I write it to a text file instead of saving it?
  15. Replies
    12
    Views
    276

    Re: Excel saving a file witout quotations

    <tbody>

    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
    HDR,JV1909110SP,Y,Y

    </tbody>
    <strike></strike>
  16. Replies
    12
    Views
    276

    Re: Excel saving a file witout quotations

    The site is blocked by my provider so I guess I cant do that, thanks for the help anyway.
  17. Replies
    12
    Views
    276

    Re: Excel saving a file witout quotations

    Thanks for the help.

    How do I post my worksheet?

    I am opening the output with notepad 2 if that makes any difference.
  18. Replies
    12
    Views
    276

    Excel saving a file witout quotations

    Hey,

    I am trying to make some VBA that saves one row of data from a spreadsheet and saves it as a PRN file which I can do but it adds quotation marks to the start and end of every row, how do I go...
  19. Replies
    0
    Views
    78

    Excel Save as CSV and remove quotations

    Hey,

    I have two issues, I have written this to save my workbook as excel then save a sheet as csv using the cells in one sheet as the name of the files, I run it and select my destination but the...
  20. Replies
    6
    Views
    257

    Re: Excel save sheet as VBA but remove commas

    Thanks for the responses.

    I get that the the file will be formatted as
    a,b,c,d
    a,b,,

    the additional commas in the frst lines are what causes an issue when I upload it into the accounting...
  21. Replies
    6
    Views
    257

    Re: Excel save sheet as VBA but remove commas

    Sorry I just reread my question and I forgot add that I save the worksheet as a csv file and that is what is causing these additional commas as the row sizes are differnt on the 1st, 2nd and last 3...
  22. Replies
    6
    Views
    257

    Excel save sheet as VBA but remove commas

    Hi,

    I use Excel to create journals that I then upload the problem with this is that it creates additional commas on some lines that I then have to manually remove, is there any VBA I can use that...
  23. Replies
    1
    Views
    251

    Printing Pages based on cell contents Query

    Hi,

    I have a worksheet that is set up to 8 print areas I think I have made a macro that should only print each page if the first cell in it has contents but I cant seem to get it to work, would...
  24. Replies
    1
    Views
    134

    Re: Filters Based on multiple Cells

    I tried this on an advanced filter but I'm not having much luck;

    Sub 1 C Sub 2 C Sub 3 C Sub 4 C
    >1 <0 <0 <0
  25. Replies
    1
    Views
    134

    Filters Based on multiple Cells

    Hi,

    I have 4 rows of data that all contain numbers, each of which can be positive or negative, I am looking for a way to filter the results so it shows me any row in which not all cells are...
Results 1 to 25 of 46
Page 1 of 2 1 2