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.
Bookmarks