cycle

I have some basic VBA code to copy my defined table range (Copy_Data) from one sheet to another. The table updates values based off of Cell A1 on Store Data tab. I have a list of every store number I would need to manually go through and plug into A1 so it can recalculate the table and then copy...

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>...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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. Excel 2013/2016CDEFG1Today05 March 201823Start DateCycle in yearsCurrent start cycleCurrent end cycleExpiring in401 January...

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...

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...