Search:

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

Search: Search took 0.00 seconds.

  1. Re: Links failing to update when power query is refreshed

    Hi SpillerBD, thanks for your response. Can you elaborate on how I can do that please?
  2. Links failing to update when power query is refreshed

    Hello Mr. Excel Friends,

    I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do...
  3. Re: Preventing copying duplicates from one workbook to another

    Hi Fluff, can you please provide me with a sample code on how I can do that? I tried but I'm unable to get mine to work and I'm not sure what to google.
  4. Re: Preventing copying duplicates from one workbook to another

    Ok! I think I understand what you mean, I'll give it a try. Thanks!
  5. Re: Preventing copying duplicates from one workbook to another

    Hi Fluff, the data will not be changed in the original workbook after being copied. I don't think I understand your second question though.
  6. Preventing copying duplicates from one workbook to another

    Hello Mr. Excel Friends,

    I am copying rows of data from various workbooks into one workbook. The data in the workbooks will be cleared out weekly, but will be collected daily. Therefore I will...
  7. Re: Index-Match that pulls all values from an excel

    Hi M,

    Thank you for your response! I think I was unclear in my question though, because what I need is to copy the WHOLE row into another log book, as in another separate workbook. The items that...
  8. Re: How can I change an equation to reference another workbook?

    Thanks Shane, I actually had to use Power Query for what I wanted in the end.
  9. Index-Match that pulls all values from an excel

    Hello Mr. Excel Friends,

    I have an excel sheet that keeps track of the status of some items, broken into OK or NOK status. I need a log of all NOK parts in another sheet, I have tried an index...
  10. How can I change an equation to reference another workbook?

    I have this equation in my document that references a sheet in the same workbook

    =OFFSET(INDIRECT("feature[#headers]"),MATCH(I7,INDIRECT("feature[op '#]"),0),1,COUNTIF(INDIRECT("feature[op...
  11. Re: Command button that generates sequential numbers in column A

    That worked great, thank you!
  12. Re: Command button that generates sequential numbers in column A

    https://imgur.com/a/Ev6CUeihttps://imgur.com/a/Ev6CUeihttps://imgur.com/a/Ev6CUeiHere is a link to an image: https://imgur.com/a/Ev6CUei

    I'm sorry I couldn't upload it for some reason.
  13. Re: Command button that generates sequential numbers in column A

    Hi N1lesh, Thank you for your response. I tried putting number 1 in the cell above but the button is not generating the numbers :(
  14. Command button that generates sequential numbers in column A

    Hello Friends,

    As the title says, I want to create a command button that when clicked, will generate a sequential number starting from 1. This is what I have coded for it


    Private Sub...
  15. Re: Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    Solved! It turns out the issue was in the tables I was referencing, there was some mismatch in the data and that resulted in my errors. Thank you for all your help though!
  16. Re: Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    I searched all, no links. I did go into name manager (the link you sent me had that reccomendation) and deleted some links to another document. I closed the file and opened it again, but I still get...
  17. Re: Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    I searched both documents and it found no links in either :(
  18. Re: Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    Thank you for your response Joe4! I don't think I will be dealing with anything larger than 10,000 rows. Also I just realised something new, the code that used to work no longer does, and I don't...
  19. Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    I have 2 VBA codes that are almost identical to each other, the only difference is that one of them has a prompt for message box with input to fill in column B. Basically code 2 is identical to code...
Results 1 to 19 of 19