<div>
Hi Dhruv,<br />
<br />
What about unfinished? Do you want to keep archive for unfinished as well?
</div>


Hi Dhruv,

What about unfinished? Do you want to keep archive for unfinished as well?

<div>
my unfinished one will remain in original file so that i can review it during work and finished ones will move to a new file.<br />
<br />
it is important that new file should not have any date in the file name and thus i should be able to append new finished lines in the same file<br />
<br />
Finally i should have only 2 files left. File 1 will have unfinished and finished line with a macro button. When i run the macro all finished line should move to a new file
</div>


my unfinished one will remain in original file so that i can review it during work and finished ones will move to a new file.

it is important that new file should not have any date in the file name and thus i should be able to append new finished lines in the same file

Finally i should have only 2 files left. File 1 will have unfinished and finished line with a macro button. When i run the macro all finished line should move to a new file

<div>
Can I add Date in last column in your Database File? Instead of having date in file name?
</div>


Can I add Date in last column in your Database File? Instead of having date in file name?

<div>
No i will not need the date at all, this will be just archive every week into one file
</div>


No i will not need the date at all, this will be just archive every week into one file

Database.xlsx

Copy-Sheet-To-New-WB_V3.xlsm

<div>
Thanks so much, this is working 100% as per my expectation.<br />
Where are you based?
</div>


Thanks so much, this is working 100% as per my expectation.
Where are you based?

<div>
You're welcome and I'm glad I was able to help. I am based Namibia (Southern African Country).
</div>


You're welcome and I'm glad I was able to help. I am based Namibia (Southern African Country).

<div>
I must say you are an expert in Excel VBA
</div>


I must say you are an expert in Excel VBA

<div>
Thank you dear. I am just a Newbie in Excel VBA.
</div>


Thank you dear. I am just a Newbie in Excel VBA.

<div>
<div class="content wysiwyg-content">
I am after managing my database where i am looking for moving my finished rows to another file just like creating an archive.
</div>
</div>


I am after managing my database where i am looking for moving my finished rows to another file just like creating an archive.

Excel database management

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.