#urgent

I wrote this VBA code to fill in missing data up to current date. The problem is that is fills it in above my current data, not below which messes up everything. How can I fix this? This is table. VBA Code

Hi, Can I consolidate all codes to do step by step after one button is used? Currently I have to use 4 buttons and it does not always work properly First button upload the CSV file from other source to "Source data" : Sub Load_Survey_Data1() Dim ws As Worksheet Dim filestring As String '...

Hi All, I am trying to create a code that will automatically move the data after I start making changes from sheet "Mitch" and column "O" to another sheet that is named "Mitch Archive" in the same column "O". It would leave me with new data in sheet "Mitch" and previous data would be in "Mitch...

Hi, I really need help urgently. I have been struggling from 4 days and I am not able to solve it. I have to find equal distribution of cost in cell H4:T4, in each range. However the cost should auto calculate itself if we change the start date and end date of the project according to no. of...

I have this code but the problem is I don't understand what they mean by 'duplicate declaration in current scope and how to fix it Sheets("tran1").Select Rows("2:2").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Dim dentry As Long Range("tran1!a2").Value =...