finished

  1. W

    Building a fantasy football board

    I am building a fantasy football board. The board is finished and working, but the next step into it would be having the players fall off the list on the individual positions sheets once selected. i am having trouble with it and any help would be appreciated.
  2. U

    How do I automatically count the finished goods of raw Materials?

    I have raw materials. I want to be able to get the finished goods total from the raw material reference. the raw material is in another tab. I am desperate. Any help is appreciated.
  3. U

    Countif

    I have raw materials that go into several finished goods. I will like a formula where I can input several Raw Materials and I get the count of the finished goods. I think a count if formular will work, but I am not sure.
  4. T

    Detect webpage refreshed before proceeding

    How can I ensure the extraction of data from a webpage has finished before proceeding to the next sub?
  5. T

    Scope and lifetime of variables

    My understanding of a variable's lifetime is that if it is declared at the module level, it retains its vaue, even after the sub has finished running. So in my following code, after first running Test1 to the end, if I run Test2, the messagebox shows the value of 10, as expected. Dim a As...
  6. J

    Dealing with macros that include refreshing web query?

    Hi, I have a workbook that contains many refreshable web queries which I refresh using a command button. But how can I "pause" the VBA until queries have finished? As they take up to 2 minutes to complete and I want to manipulate the data afterwards Appreciate any help
  7. M

    Trying To Count A Specific # of Columns

    Hi everyone, I'm new to this site, so I apologize if this has been solved in the past, and I also apologize as I am an amateur with Excel, but I am trying to count a specific # of columns in a spreadsheet. The concept of the spreadsheet is to display the number of occurrences of a specific...
  8. A

    Convert the rows to Columns

    <colgroup><col><col><col><col><col></colgroup><tbody> Posting Date Document G/L Acct/BP Name Inventory UoM Qty FG00017 500 Litre Water Tank White 02.08.18 SI 2109 Finished Goods Pcs 14 02.08.18 SI 2109 Finished Goods Pcs 13 02.08.18 SI 2111 Finished Goods Pcs 11 02.08.18 SI 2111...
  9. T

    Lookup help

    Hi All, I have data as follows Bib # Name Finish position 1 Bob Road 3 2 Bill White 4 3 Simone Crawley 1 4 Peter Parker 1 In another sheet I have a column (Say A4:A104) for bib # I would like to pull The bib numbers across so that in A4 is Bib number 3, A5 is bib #4 (because they finished...
  10. J

    Code to return name of macro that's just been run

    Say I have a macro called: Sub CheckDescriptionColumn() What I'd like to do is to add some code at the end of the macro to display a message box advising that the macro has finished running, but I need the message box to return the name of the macro, so something along the lines of "The macro...
  11. H

    Time Help

    Hi everyone, I have a very simple spreadsheet that looks like this: <tbody> Date Started Time Started Date Finished Time Finished Hours 23/04/18 06:00 25/04/18 06:00 48 24/04/18 07:00 25/05/18 09:00 746 25/04/18 08:00 -1037168 </tbody> The hours cell contains a formula that...
  12. B

    Macro to show percentage completion in status bar

    I have to import several files and I would like to show the percentage completed in the status bar. I can see the hour glass of doom but I don't know how long I have to wait until I'm finished. Is it possible to do this in Excel? Thank you for your help, Michael

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top