Excel vba; Find date based on date in active cell

In Progress

Attach last year's records to the end of this month. (Excel 2010 vba)

This operation needs to be done every month.

Records are held in an Excel 2010 worksheet.

The first column of the records is the date and is in the UK format, e.g., 30/01/2013 (displaying as 30-Jan-2013).

I want to use the date of the last record (which typically is the end of the month, say April 2013) and, based on that, copy the records from the following month of last year (May 2012), attach them to the bottom of the record set (following on from April 2013) then update the year number in the date (so May 2012 becomes May 2013).

I'm looking for the vba Subroutine which will do this.

Skills: Microsoft, Visual Basic, Windows Desktop

See more: vba find date, vba find date cell, find date based date active cell, excel find date, excel vba find date, find date excel vba, excel 2013 vba find date, vba set active cell based date, excel 2010 vba find records month, excel 2010 vba find month, date vba, m format in excel, find set, find in set, find in vba, excel vba and, excel 2013 vba, end vba, vba e, excel/vba, excel to vba, Excel and VBA, excel 2013, vba excel copy, vba update excel

About the Employer:
( 2 reviews ) Barrhead, United Kingdom

Project ID: #4213450

33 freelancers are bidding on average £51 for this job

slavisatosic

Hello, I am offering you to make this VBA code by tomorrow. Please see private message for details.

£50 GBP in 1 day
(60 Reviews)
5.7
bharanisrihari

Hello, Excel VBA expert ready to start. Please check PM for details. Thanks!

£50 GBP in 2 days
(27 Reviews)
5.6
ZeusMan

Looking forward to working with you...

£45 GBP in 2 days
(27 Reviews)
4.9
cheapexcell

Ready to start

£40 GBP in 1 day
(48 Reviews)
4.8
gshiels

Hi John. I have 20 years Excel experience and strong VBA skills. Please check my feedback.

£60 GBP in 1 day
(3 Reviews)
4.6
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

£44 GBP in 1 day
(9 Reviews)
4.1
pierreho

Dear JohnWhyte1, it is an easy task. Please just provide your file. ;-)

£60 GBP in 1 day
(6 Reviews)
4.0
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to More

£50 GBP in 1 day
(10 Reviews)
4.0
MDavidCrompton

Hi John, Your example was not attached. I have worked on conversion, manipulation and analysis of Excel for 20 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. Example in PM. I am UK based, More

£40 GBP in 2 days
(11 Reviews)
3.9
rfreelancer2008

Hi there - I am ready to start this asap, and am very much interested to work on this project with you. I am passionate to work on VBA projects and would like to get a chance to work on this one. More in pmb... More

£30 GBP in 2 days
(10 Reviews)
3.9
techism

Hi, I have been doing VBA projects since years. This is simple routine and can be done in couple of hours. Thanks.

£36 GBP in 1 day
(13 Reviews)
3.8
microk

Expert Here.. Please check PM..

£35 GBP in 2 days
(7 Reviews)
3.5
mabozaidvw

Hi, I can do it

£20 GBP in 1 day
(9 Reviews)
2.8
JoeGreen1982

Hi, UK Based Excel / VBA designer here, with over 10 years of experience in delivering projects such as this. I have your macro ready for you - please see your inbox for further details. Many thanks, Joe

£30 GBP in 0 days
(2 Reviews)
2.8
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

£25 GBP in 1 day
(3 Reviews)
2.3
bubu77

Hi, Ms Access expert having 8+ yrs of IT experience. Lets start work on this. Please see your PM for more details.

£50 GBP in 2 days
(1 Review)
2.0
Gooroo

*Let me help, Sir!* Highly experienced - JUST fresh HERE. Please check my credentials. Thanks!

£20 GBP in 0 days
(1 Review)
2.0
sthakral

Hello, I understand your requirements very clearly and happy to help. Please check PMB for more details. Best, Sandeep

£40 GBP in 2 days
(1 Review)
1.9
vedranvivoda

Hello! I can help you out, check pm for reference

£35 GBP in 2 days
(1 Review)
1.6
mukulsinha25

Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and More

£40 GBP in 1 day
(1 Review)
1.0