Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Data Extraction multiple Sheets & Multiple Cells

    Sorted - again thank you :)
  2. Re: Data Extraction multiple Sheets & Multiple Cells

    Sorry, I have one more questions, the blocks of data are different lengths so and it is not bringing back all the data, could you tell me why this is, I must have not changed everything that I...
  3. Re: Data Extraction multiple Sheets & Multiple Cells

    That works perfectly - thank you so much.

    I have just tried to add in the next block and that is working perfectly as well.

    You have no idea how much time you have saved me.
  4. Re: Data Extraction multiple Sheets & Multiple Cells

    Thats great I can replicate it for each block, they would drop into rows instead of columns so A1:01, A2:O2, A3:03 etc etc

    Ill try replicating the rest now
  5. Re: Data Extraction multiple Sheets & Multiple Cells

    That works perfectly,

    2 questions I have larger ranges I want this to apply to which are below;


    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
    ...
  6. Re: Data Extraction multiple Sheets & Multiple Cells

    So I am trying to pull each set of ranges into one column so

    I want this: G3,a6,A8,c8,d8,g8,m8,n8,o8,p8,q8,r8,s8,t8,u8 to populate the values into A1:A15 then the next set of ranges to populate...
  7. Re: Data Extraction multiple Sheets & Multiple Cells

    Thanks,

    Replacing the 0s with o's at least got my data to generate.

    I have got it so that it now pulls data from files, I would like each sheet to populate on the next row so in this instance i...
  8. Re: Data Extraction multiple Sheets & Multiple Cells

    I want the row to be those cells how can I change it so that it copies those cells to the relevant cell in a row.
  9. Re: Data Extraction multiple Sheets & Multiple Cells

    No that is the entire thing, how would I go about fixing that?
  10. Re: Data Extraction multiple Sheets & Multiple Cells

    Its failing to run, the error message is:

    run time error 1004

    application defined or object defined error
  11. Data Extraction multiple Sheets & Multiple Cells

    Hey,

    I have tried to make a macro that I can select a folder and then export all the data from multiple sheets that are identical in layout to one sheet I have come up with this but I cant seem to...
  12. Replies
    19
    Views
    607

    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...
  13. Replies
    19
    Views
    607

    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.
  14. Replies
    19
    Views
    607

    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
  15. Replies
    19
    Views
    607

    Re: Filter cells and emial filter result

    Anymore help would be greatly appreciated.
  16. Replies
    19
    Views
    607

    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...
  17. Replies
    19
    Views
    607

    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?
  18. Replies
    19
    Views
    607

    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
  19. Replies
    19
    Views
    607

    Re: Filter cells and emial filter result

    I have and the email is generated but the attached file is blank
  20. Replies
    19
    Views
    607

    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...
  21. Replies
    19
    Views
    607

    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...
  22. Replies
    19
    Views
    607

    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...
  23. 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...
  24. Replies
    12
    Views
    305

    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.
  25. Replies
    12
    Views
    305

    Re: Excel saving a file witout quotations

    Thanks

    That makes sense, how would I write it to a text file instead of saving it?
Results 1 to 25 of 57
Page 1 of 3 1 2 3