Merge Highlighted Cells to create file name for Scanned File

[rizmomin]

Hello:

I am trying to make all my filing paperless.
Hence i scan all the documents, invoices, bills, correspondence, etc for all my businesses.
I need to name the scanned files accordingly and hence i need the following:



I have a situation where i like to build a file name as follows..( i need to use this for renaming scanned files).

Column A would have Dates of current month and Today's date would need to be higlighted as default.
Column B would have Customer
Column C would have Category


Depending on what I scanned, i would highlight the date, Customer and Category.
(OR If possible you could help me create dropdown list to select Date, Customer and Category)

Running a macro need to create :

Date_CustomerName_Category in Field D2
Please refer to attached sheet for referance.


Would need Clear Button to unhighlight cells for next run.
Next File name would need to be in D3 and thenD4,D5, etc..


Thank you in advance for your help and please let me know if you have any questions.


RM

[davesexcel]

This example will automate your data validation so you can continue to add items to the list. When you click the button the lists update.

You can hide Columns A:C if you don't want to see them by selecting Columns A:C then hit Ctrl & 0(zero) select the entire sheet and hit Ctrl & shift & 0 to unhide.

There are two Modules that have code to make this work, Module1 and the worksheet1 module.
Right click on the sheet tab and select View Code, or hit Alt & F11 either way you will get to the VBA Editor and will be able to see the modules.

[rizmomin]

Hi Dave:

Thank you so much ...this will work great for me.
However i would like to have date format in the name as yyyy-mm-dd eg: 2010-11-30-AA_BB. Also once this File name is created i wanted to manually rename the scanned file to this as new name of the file. To do that i would need to scroll my cursor along the created file name and copy and paste to rename. Is there an easy way to select the content of cell (Complete File Name).....

PLEASE let me know if you have any questions in understanding my requirement.

Once again thank you so much for all your past help also..
Life becomes very easy when we have people like you on this forum....so helpful

RM

[rizmomin]

Hi David:

I think i found a way to select the content of the file name by doing F2 and then Shift+Home..
This will highlight the content and i can do copy an paste.

Howerver, i still need the created file name in following format : yyyy-mm-dd_Customer_Category.
Please help accomplish this.

Thank U

RM

[davesexcel]

In the worksheet module, replace with this

Please Login or Register  to view this content.

[rizmomin]

Hi Dave:

Super this will work great...

Thank U so much for your expertize...

RM