Search:

Type: Posts; User: fowzan; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: VBA to automatically Hyperlink cell text with similar file name

    i dont know if i am allowed tp post link to other forums, but maybe someone who is looking for a similar macro can benefit. i got the solution on an another forum....
  2. Re: VBA to automatically Hyperlink cell text with similar file name

    anyone?
  3. VBA to automatically Hyperlink cell text with similar file name

    hi,
    i currently have an excel sheet where i am entering the issued certificates for the jobs done.
    Some examples for the certificate names are
    JAN18/161/C1-C10
    FEB18/185/C1
    FEB18/190/C1 &...
  4. Re: VBA to Auto Hyperlink a .pdf file from a folder based on cell value

    can someone help me with the code
  5. Re: VBA to Auto Hyperlink a .pdf file from a folder based on cell value

    i have a very similar requirement. i tried this and it almost works for me aswell.
    but i have a few issues
    1. my file names contain "." instead of "/" as widows doesnt allow / to be in a file name....
  6. Re: Macro from Excel 2013 fails to work in 2016?

    anyone?
  7. Macro from Excel 2013 fails to work in 2016?

    Hi,
    I have been using a macro to save an image on my company's invoice. I have been using this from past 4 months without any issues. But recently we upgraded from Office 2013 to office 2016 and now...
  8. Re: compare 4 different columns from 2 tables and extract data

    well what you said should be the ideal case. but somethings wrong with my file. I will try copy pasting the data into a new file and try over there.
    Unfortunately i cannot create an additional units...
  9. Re: compare 4 different columns from 2 tables and extract data

    THIS IS GREAAAAATTTTT. worked flawless.
    At start i could not get it to work but then i found out that the issue was with the cell formatting. Some cells were formatted as text and some were numbers....
  10. Re: compare 4 different columns from 2 tables and extract data

    anyone?
  11. compare 4 different columns from 2 tables and extract data

    hi,
    i have got 2 tables.
    I want to compare 4 columns from both these tables and retrieve data from table2 into table1, if the criteria matches.
    Now the problem is that the values to be compared...
  12. Replies
    2
    Views
    297

    Re: copy data from one workbook to another

    thanks @portews.
    i managed to get it done with this code


    Sub openfile()
    Set wbOpen = Workbooks.Open _
    ("F:\Docs\Invoices\" & Range("b7"))
    End Sub

    Sub opennewinvoice()
  13. Replies
    2
    Views
    297

    copy data from one workbook to another

    HI,
    i have been using excel to create invoices. unfortunately i had to change the format of the invoice and add some more details to it.
    the problem i am facing now is i have to change all the old...
  14. Re: how to use autofill from inventory workbook on invoice workbook

    last bump
  15. Re: how to use autofill from inventory workbook on invoice workbook

    bump
  16. Re: how to use autofill from inventory workbook on invoice workbook

    anyone?
  17. how to use autofill from inventory workbook on invoice workbook

    hi,
    i have 2 different workbooks. 1 for inventory and other for creating invoices.
    i want to create an autofill/dropdown in the invoice workbook.

    Invoice Format

    <tbody>
    #
    Product
    Packing
  18. Re: how to create a cell that appends the current date time when ever the row is edited

    just perfect. works like a charm
    Thank You So much for the help
  19. Re: how to create a cell that appends the current date time when ever the row is edited

    ok this is almost upto the point. but can you please add the new dates at the beginning of the cell value instead of at the end of the cell value
  20. Re: how to create a cell that appends the current date time when ever the row is edited

    this does the job. the only problem is that if value is edited more than once, the date is added to the next cell, and so on.
    can it be added to the same cell, without deleting the old value....
  21. Re: how to create a cell that appends the current date time when ever the row is edited

    column X
  22. Re: how to create a cell that appends the current date time when ever the row is edited

    columns B, F, H
  23. Re: how to create a cell that appends the current date time when ever the row is edited

    the prices would always be changed manually
  24. how to create a cell that appends the current date time when ever the row is edited

    i have an inventory list. the prices keep updating. as of now there is no track to when a row (be it the cost price, sell price, vendor, packing, etc) was edited. i would like to create a new column...
  25. Re: what would be the best way to cut/paste duplicate rows to the next sheet

    works absolutely flawless. this probably saved me a complete week of manual work.
    THANK YOU SO MUCH.
    just so that i can reuse the code in other cases could you just correct me if i am wrong
    ...
Results 1 to 25 of 59
Page 1 of 3 1 2 3