-
Solved: macro to add FileName and currentdate to an existing worksheet
Hello
I need to add some code to a macro so that each time it is run it will add the FileName (in Cell A2) and CurrentDate (in cell B2) into an already set up spreadsheet called "Files". Headings (already set up) will be in A1 and B1
Everytime the macro is run there will be new files in the folder (probably between 50-100), so data in "Files" should not be overwriten data but instead add name and current date to the next un-used row down and so on.
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules