Command to copy a line of entries to an archive

[YMUNSHI]

Hi everyone,

Thanks for reading this post.

I'm relatively new to VBA and am still learning.

I wanted to ask if I could please be given some help with a spreadsheet problem.

Basically, I have two spreadsheets called 'Recording' and 'Archive'. They are personally designed spreadsheets I use at work to monitor my productivity and work efficiency, as well as accurately reporting my times.

'Recording' is the spreadsheet I use to plan my entire days schedule and I use it to input figures and times. Generally, 'Recording' is a macro-enabled template spreadsheet in reality - each day, the spreadsheet is opened as a template at the moment because once everything is done in this sheet, it is being saved as single notepad files (although they open in an instant, they're becoming very cumbersome to manage and analyse especially with like 300 days worth of data stored in the folder). 'Archive' is the spreadsheet I need to use to store all the data. Because the 'Recording' sheet is a template, I'd be happy to make this a Macro-enabled spreadsheet only if there would be a problem.

In 'Recording', there is a tab ('Compiler') that compiles data from another workbook within the spreadsheet (this has not been shown to simplify the problem because the entire transfer operation needs to be done from the 'Compiler' tab). In this particular tab, part of row 6 needs to be transferred to 'Archive'.

There are 3 buttons in the 'Recorder' workbook. For 'ARCHIVE DATA', basically, the commands need to assume the following:

1. Copy entries D6:AJ6 in workbook 'Compiler' of 'Recording' spreadsheet;
2. Locate the date in 'Archive' that corresponds with the date in Line 6;
3. Paste Line 6 in the corresponding line of 'Archive' as values;
4. Insert 10 new dates from cell A121:A130 that succeeds the date in line 120 of the archive;
5. Replicate the border formatting into cells A121:A131.


In a separate command, I wanted to ask if the following VBA code could be provided for the button 'RECEIVE FLEXI'.

1. Copy data from the worksheet 'Archive' from column H which contains the most recent entry;
2. Paste as time in 'Recorder' workbook of the worksheet 'Recording' into cell C4.

For the above command, it needs to strictly take the flexi time entry from the most recent entry (not from the previous day otherwise the cell could return a blank time if I was on holiday or on a weekend).


Finally, the last button in the 'Recorder' workbook of 'Recording' says 'SAVE AS NOTEPAD'. This is a Plan B in case something happens with the above code. As the box quotes, the command needs to:

1. Save the workbook 'Recorder' as a Notepad file, with the current date as the filename in the format ddmmyyyy, in file path xxxxxx.


Any way I could ask for help here??!!

My apologies I forgot to mention I am using Microsoft Excel 2010.

Thanks again for viewing and thanks in advance for any help you could offer. Appreciate it greatly.

- Yousuf.