Hi Guys,
I am currently working on a project which is i am using in my job...I need some help on how to make this work...which basically copy rename then paste in a next row (a data on a cell which is a filename that i updated everyday.)
here are further more of an example og which i am making....
on a worksheet named Daily reports monitoring
as you can see theres a weekly date above of each filename e.g."VE-Daily-Review-27-Apr11.pdf" it is a report i make everyday..so everyday i add it on my excel to track the reports i make..
i need help to have a macro that would automate it as i clicked.
1. first copy the filename from lastrow of B D and F
2. rename each filename to a suitable filename using a input box ask a user for a new filename for each rows e.g. VE-Daily-Review-27-Apr11.pdf ask user for new filename for VE-Daily-Review-28-Apr11.pdf
3. Paste it to the next available row for ech row....
4. and if possible automatically make a hyperlink to my drive d:
Thank you guys for any help...really appreciated..
Bookmarks