vba date

Hi, I'm currently trying to write a macro which collates data each day into a masterdata file. I have managed to get the initial copy and paste from one file to the other. What im currently struggling with is adding todays date in a different column so i know from which date the data was...

Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...

I wish it was as easy as pasting creative formulas from Excel to VBA, but alas it is not, which is why i am here... I have this formula working in a cell, but would like it to work in VBA: =EOMONTH(EDATE(DATE(YEAR(AA3),FLOOR(MONTH(AA3)-1,3)+1,1),3),-1) The purpose of it is to get a date and...

I have an excel workbook with worksheets named in the date format "mmm-yy". my last worksheet on the right is named "Nov-16" I have a macro to copy the last sheet and add a month to the date. Eg. the new sheet will be named Dec-16. For some reason it named Dec-17, clicking the marco once more...

Hi, I have no idea about VBA and I would be extremely thankful to anyone who could help me out with this, something I hv been breaking my head over. Example: 1) Cell G2 has: 25-Jan-2012 2) M2 has: 9500 N2 has: 2000 O2 has:01-July-2010 3) M3: 11500 N3: 2000 O3: 01-July-2011 4) M4...

Hi! I am a mostly-self-taught VBA novice. I am trying to create a VBA formula that will go through my previously sorted data and count only the visible cells with a date within two years of the current date. So far, here is where I am stuck: Sub CountIF() ' ' CountIF Macro ' With...

Hi All, I have some code that filters a range of data based on a unique number and the last 7 days. What I would like to do is be able to change the 7 days and put it as a variable so that it can be changed to whatever the user specifys. I am not sure on the syntax but basically i want the code...