Hi all,

I am currently trying my best to do a looping function.

In Orders workbook

= If cell B contains New Member then it copies and paste certain cells into the database worksheet
=If Cell B contains Existing Member then it copies and paste some other cells into the database worksheet.

Though I am still trying to figure out the above as I have just started using VBA a week ago. I am stuck with the below. wondering if this is possible.

Copy only the date in Column A from one workbook to another workbook in column C

Orders Workbook
Column A
4/7/2014 10:26:00 AM

Database Workbook
Column C
4/7/2014


Any help would be good. Thank you.