Search:

Type: Posts; User: jeremiah_j2k

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    1,505

    Thanks a lot admin. I noticed that it only the...

    Thanks a lot admin. I noticed that it only the data on the second table is being copied on succeeding clicks and no dup checking if data for the day has already has already been exported. Could be...
  2. Replies
    4
    Views
    1,505

    Can anyone help on this pls? Thanks

    Can anyone help on this pls? Thanks
  3. Replies
    4
    Views
    1,505

    Append Table data to another table

    Hello Team,


    I'm having some challenges on how to copy the data from my 2 tables on PivotDaily sheet to tables on DataSummary sheet. PivotDaily tables can have as much data as possible and I need...
  4. Thanks admin for immediate response. its working...

    Thanks admin for immediate response. its working fine now. I appreciate your help :)
  5. Need to modify VBA code to import data from other workbook

    Hello guys,

    Need a little help to modify the below codes. Currently it copies data from the the source workbook if its column label matches what we have in...
  6. VBA Macro to open a file and extract data

    Hello Admin,

    Can I re-open this thread pls.. or should i create a new one? I'm re-visiting this thread for a similar project and now having challenges on how to revise the code to capture the...
  7. Thanks Admin and snb for your feedback. I...

    Thanks Admin and snb for your feedback. I appreciate you help :)

    here's the snippet of my code:


    Dim strFileSelected As String

    Application.ScreenUpdating = False

    With...
  8. Thanks for your feedback.. :) is it possible to...

    Thanks for your feedback.. :) is it possible to capture the "Last Save Time" of the file selected from the FilePicker and put its value in a cell?
  9. Capture the "Last Modifed" date from FilePicker

    Hello All,

    Has anyone tried to capture the last date modified of the file selected from FilePicker? I'm trying to figure out how to insert the its value to a cell but getting an error using the...
  10. Replies
    0
    Views
    809

    Need Help to Restructure the table

    Hello Guys,

    I would like to ask your advise on how can we restructure the table from the attached spreadsheet. Can this be done using v/hlookup command or a macro? Below is the format that i need...
  11. Thanks so much for the code Admin Excel Fox. Its...

    Thanks so much for the code Admin Excel Fox. Its working perfectly as needed. Thank you :) :) :)
  12. VBA Macro To Open A File And Extract Data From Specific Columns

    Hello All,

    I'm trying to make my workbook more flexible and trying not to depend on a fixed file path that's why i'm trying to use a combination of msoFileDialogFilePicker and lookup function but...
  13. Thanks for the code admin... its working...

    Thanks for the code admin... its working perfectly as needed and i really appreciate it.. thanks :)
  14. I have uploaded the wrong file in post #1 but...

    I have uploaded the wrong file in post #1 but already changed it with the correct one.
  15. Hello Admin, Sorry for the confusion because I...

    Hello Admin,

    Sorry for the confusion because I guess I did not explain the problem clearly. From the attached file in post #1, the button and code will run in the "Main" tab. B2 is a dropdown list...
  16. Rename tab on cell value from another worksheet

    Hi All,

    I need a help to make my code work. I'm trying to rename worksheet one at a time but i'm having problem in using cell reference. see my code below and thanks in advanced for your help

    ...
  17. Hello Admin... Thanks so much for the help......

    Hello Admin... Thanks so much for the help... Your code works as awesomely cool.. thank you thank you thank you!! :)
  18. Thanks Admin... file has been attached

    Thanks Admin... file has been attached
  19. Hello alansidman, Thanks for the advise. Below...

    Hello alansidman,

    Thanks for the advise. Below are the files that might help you determine a suitable solution. Thanks in advanced :)


    Excel File:
    BLver10-Test


    File snippet:
  20. Hello LalitPandey87, I will upload the file...

    Hello LalitPandey87,

    I will upload the file shortly... thanks :)
  21. Import row data from multiple worksheets to generate a report using vba

    Hi All,

    I would like to ask assistance in exporting data from several worksheets to create a summary report on a daily basis. Data are from xlsm files and they have a common name (Part of...
  22. Replies
    8
    Views
    2,082

    we can put a dropdown list to a cell reference...

    we can put a dropdown list to a cell reference and declare its position in the VBA code... for example


    With OutMail
    .To = Range("I5")
  23. Replies
    8
    Views
    2,082

    Hello snb, sorry for the confusion. I used the...

    Hello snb,

    sorry for the confusion. I used the code that you have provided and it worked perfectly as needed. However, I need to send out the worksheet that contains the data from the rows that...
  24. Replies
    8
    Views
    2,082

    Hello snb, Thanks for your immediate response....

    Hello snb,

    Thanks for your immediate response. Can you help me modify my code? As of now, it can split the data from rows into multiple worksheet but is it possible for that new worksheet to be...
  25. Replies
    8
    Views
    2,082

    Hello Admin... thanks for the suggested forum...

    Hello Admin... thanks for the suggested forum topic... I already have a vba code to send out worksheet via email on my tracker.. but thank you for the reply :)
Results 1 to 25 of 26
Page 1 of 2 1 2