I need a vba to do the following. If you have any ideas, please reply.
There is a sheet (1) which has a table. Column f will have customer names. What I want to accomplish:
1. The shipment date column will be equal to the range “Ship Date”
2. Date Processed column will have today’s date
3. FileName column will have this file’s name in the column
These three values will be the same for the three columns till the last line.