cycle

  1. Belair58

    Hopefully an easy Input Box data question...

    Hello, I have a macro that is pulling data from a sheet Cycle_14a_Output.txt. There will be multiple sheets used for this project, all name Cycle_XXa_Output.txt. I've added an input box to ask what the number of the file should be. How can I add the Input Data into the formula string? <Code>...
  2. F

    Looking to use buttons/macros to create a question box (text box) that can cycle through 5 questions using forward and back arrows.

    Would this be possible? I’m new to macros and have basically no VBA knowledge but wanted to make a text box or similar change the text inside by clicking the arrow right or left to cycle between around 5 questions. I hope this makes sense, I teach basic functional skills ICT and this would be a...
  3. I

    Subtraction of cells in alternating ranges

    Hello, I am looking for a solution preferably with formulas or in vba. Need something to be able to calculate the cycle times in column 8 below by subtracting the finish time from the start time for each cycle. The cycles vary in cell row ranges so I'm not sure how to go about this. Thought of...
  4. K

    Prorate price formula

    Hello, I am trying to create a spreadsheet that will calculate a prorated price based on an effective date. I had found this forum by searching the issue where someone proposed this formula: =A2*(DAY(EOMONTH(B2,0))-DAY(B2)+1)/DAY(EOMONTH(B2,0)) The problem is we use a billing cycle starting...
  5. M

    VBA to cycle through cells

    Hi I have 2 buttons one for cycle left and one for right. i would like to be able to cycle the selection forward and backward. I15, AN15, BP15, CU15, DY15, FD15, GH15, HM15, IR15, JV15, LA15, ME15. Thanks in advance.
  6. C

    Cycle multiple Excel functions in single macro

    I am trying to create two macros and would really appreciate some help on this, as not sure where to begin. 1. AutoSum Min on first execute then AutoSum Max on second execute (if the macro is executed in the same cell). Then beyond the second execute, the macro should cycle through these two...
  7. B

    Calculating an average cycle time

    Hey all, I am looking for some help on finding the average cycle time for my trucks on a load cycle. I have column "B" with the start time and date and Column "C" with the end time and date. Every now and then a driver may stop for the night in the middle of one of his loads so the cycle times...
  8. C

    Cycle through sheet tabs

    I have the following that cycles through sheet tabs but I need it to skip a tab if tab is named "Debt" and then continue to cycle through remaining sheets. If ActiveSheet.Name <> "Data" Then Do Until ActiveSheet.Name = "Data" How do I tell it to skip that tab but continue to reaching the...
  9. J

    Collect data from a row in multiple sheets

    I have monthly workbooks (October, November, etc.) with data, and in each month -there's cycle of work of seven days (call it sheets:1,2,3,4,5,6,7) -after each cycle it stops for two days (sheets:8 and 9) -and it starts again (sheets:10,11,12...16) I want to resume the data from some columns...
  10. J

    Collect data from multiple worksheets in one worksheet

    I have monthly workbooks (October, November, etc.) with data, and in each month -there's cycle of work of seven days (call it sheets:1,2,3,4,5,6,7) -after each cycle it stops for two days (sheets:8 and 9) -and it starts again (sheets:10,11,12...16) I want to resume the data from some columns...
  11. S

    Working Days

    I work in an oil field. First 15 days (without any break, without any weekend or holiday) are my working days. Just after every 15 days, I got a break of exactly 13 days. Then I again join my duty for next 15 days and this cycle goes on. Now I want to calculate total working days between ANY two...
  12. K

    Check cycle of character 1X2

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data cells C6:C78, highlighted every 7th row with black background-white fonts, my query is I need to check cycle for 3 characters 1X2 when it is completed.</SPAN></SPAN> For the example...</SPAN></SPAN> C6=X, C13=1, C20=2, so far cycle of...
  13. F

    VBA look through sheets and pull back min date

    Hi All I am looking for some help with a bit of VBA. What i am looking to do is loop through the last few sheets (all but first 2, e.g. if i have 5 sheets it will look at the last 3, 6 sheets look at last 4 etc) and look at the row of the active cell and pull back the min date. For example if...
  14. I

    VBA to cycle through dropdown list and export into pdf

    Hi all I have created a dashboard which updates based on a dropdown list. I need a macro which will cycle through all of the options in the dropdown list and also export a pdf copy of each updated dashboard. The current excel model takes a considerable time to recalculate after each dropdown...
  15. E

    Value interpolation trough multiple ranges

    Hi, I'm struggling with a problem here, with processing some data in excel - I'm out of ideas,please help. so, I have a large amount of data that looks like this: So to explain, i have a lot of cycles of measurements, (Cycle 1, Cycle2 in example picture), and each cycle gives a "y" values...
  16. C

    Array formula?

    Worksheet A (Base Volume Data) contains a list of project numbers with a quantity per week for each project. Worksheet B contains activity data for component parts in these projects; Column B contains project numbers; Column N contains cycle times for a specific operation. Obviously...
  17. P

    Working with dates and cycles

    Please can someone assist me with some formulas working with dates and yearly cycles. I need formulas for the cells highlighted in green below based on today's date. <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  18. V

    "Shake" the list after one iteration

    Hi all, I'm using an excel file which selects 5 names out of a pool of 50 names. The sheet is such that if 5 names are selected randomly, next time 5 names will be chosen from remaining 45 names. This goes on till 1 cycle is complete. However, in the next cycle which will be iteration 11, I...
  19. T

    Cycle Formatting

    Hi, I have set up a bunch of custom formatting macros and mapped them to different hotkey/short cuts. I was wondering if anyone knew a way of creating a new macro which would cycle through my different formatting types. ie: ctrl-shift-up would change the font to blue, if ctrl-shift-up was...
  20. C

    Embedded IF statement placements

    Hi all! I am writing a report that is calculating deferred/accrued revenue to be accounted for each month. To determine how many days are allowed for deferral I have a column that tells me how many days are in each period. There are 12 buckets as there are 12 billing periods. To look up to...

Some videos you may like

This Week's Hot Topics

Top