increment

Hi guys I have the below code, but I am getting a mismatch error on line 11. Any ideas? I'm a newbie to all this so it's got me stumped! Sub GetLatestFiles() Dim strDir As String, fs As Object, startFolder As String, subfolder As Object, increment As Integer, latest As Integer, latestFolder...

Hi, I've searched around for this but can't come to a solid answer.. know it's probably very simple. I need a code that when the cell in S4 changes to "27" then +1 in S3. Never mind, figured it out lol Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("S4")) Is...

Hello, I have a spreadsheet where I would like to increment the year by 1 every January. The user inputs the 3 month JAN (or any other month) in cell A7. The current year is captured in cell B1. Then there is a concatenate function that will copy the dates all the way down column B. The...

Hi, firstly thank you for any help. I am building a tracker that I need help with a formula I want a cell to increase by one for every 5 increment in another cell.

Dear all, I've just registered on the website and I'm sure I can get some help on the below issue (I'm not an expert in VBA).. Briefly, I'm doing a macro that computes a total quantity (in column I, for each row) based on 2 parameters (column A and column G). I'm using a SUMIFS function...

I'm creating another data file (KML for import into google earth) from data in a table. Pretty basic stuff. I can't get this loop running because it keeps incrementing by exactly one line. The code works fine except in the scenario where I use excel's filter function to shorten the list...

I have a total amount in field C2 that changes as I enter daily amounts in each row under it, C3:C*. Currently, every time I enter a daily amount, say for field C3 or C4, etc., I have to go back to C2 and change the formula so it will sum from C3:C4, followed by the next day, C3:C5, thereby...

Good Afternoon, Is it possible to do the below by using the fill function from a formula on Sheet 1 C8.... I.e. Sheet 1 C8 = Sheet 2 E3 Sheet 1 C9 = Sheet 2 E3 Sheet 1 C10 = Sheet 2 E3 Sheet 1 C11 = Sheet 2 E3 Sheet 1 C12 = Sheet 2 E3 Sheet 1 C13 = Sheet 2 E4 Sheet 1 C14 = Sheet 2 E4 Sheet 1...

Hi, I'm trying to put together a salary model and need help with a formula which takes into account annual pay rises when calculating each person's monthly costs. For example, worker 1 starts on a basic pay of £1500 per month but on the 1st August each year receives a 3% pay rise and on 1st...

Hi, I've tried searching on this issue but can't find exactly what I'm looking for, so was wondering if anyone would be able to help me. Currently I have a file containing 2 sheets. Sheet 1 contains a list of staff numbers of employees and their managers: <tbody> Employee Manager 123 456...

How can I move further in writing this code so that it skips if a blank row is found and then increment the cell in Sheet2 from G53 to G54 and then paste it in column A after the blank row is found and so on for G53:G60. I could do it manually too but I am just trying to give this a shot...

I am trying to write a macro which, when I push a button, I want to: 1) Copy all contents on the active sheet (lets call the sheet "Employee Hours") 2) Create a new sheet which has the name naming convention, but increments with each time the button is pressed (i.e. "Employee Hours 2"). 3)...

I'm working on an inventory spreadsheet where the item's names are listed in column A, their ID number in column B, and the current number in inventory in column C. I have macro buttons for incrementing and decrementing the values in column C, but they only work when the cell in column C is...

Hi, I have been trying to create a formula where cell letter for example A1 increases next time to D1. For example; A1 on MAIN sheet is january-2015, and A7 on REFERENCE SHEET is also January -2015. However next time on MAIN Sheet February - 2015 is in D1, and REFERENCE Sheet its in B7...

Hello all! I posted a thread recently about consolidation and have gotten it close to where I want it, but am still having trouble with regard to one aspect. I am trying to fix up the part about the NextEmptyColumn. I would like for every new "FilesInPath" that the copied cells be added two...

<tbody> I need to collect the values from a column for every 11th row, but I don't want to write out the cell reference in every cell because I have a lot of data that will be continually updated (E.g =A2, =A13, =A24). Is there a way I can use indirect and row+11 so this can auto update...

I have a main worksheet (Test) that I copy each day and I would l would like it to automatically be renamed Test 1, Test 2 and so on when I make a copy. I am really new to VBA and could use some help. Thanks in advance.

Hello everyone, first post in the community, I hope I will do this correctly :) I have been trying to develop a macro that gives prices and quantities of material based on a user input (the first month [1 for January etc] and the amount of months required using the principle of a rolling 12...

I am creating a spreadsheet that references another spreadsheet of mine and I am trying to find out how to reference every 16th cell in a column to every row in another column. I have a form on one sheet where users can enter all of their information and I want to create a separate overview...

Hello all, Just new to the site but have been lurking posts for a long time now, really helpful stuff. Here's my problem (I want it in a formula/macro): I want to increment a value in a certain column B for example untill infinity or untill the value of column A changes. And then the value...