I have 1000 files/documents saved with last and first names, I need to move these files/documents to their respective folders that also have last name first name. I would like the script to read the last name and move it to the folder with the same last name, some sort of script or batch file...
Check out this cool code I had help with. Works great if you have a list of names and addresses used for Data Validation and you need to have additional customer info. Take a look
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next ' Ignore VBA Error If Trying To...
what is the best method to automate the copying of rows to another worksheet, macro, or formula.
I have a worksheet with rows of client data, I need to copy all the same client data to another worksheet i.e. with column headings
client id
name
location
hours
I may have client id 1004 listed...
Can anyone advise me - I am creating an interactive excel spreadsheet for a client who is not computer literate. It is for project management. I wish there was an MDE for excel, but we all know there isn't. Can all of you advise the best way to make this spreadsheet appear a a standalone...
I have a columns of customer id numbers, names, addresses, state zip, how can I get my client to pick the id number and it returns the data of the name address etcc in the next cell, i used vlookup but it only returns the data in one column, are there many ways to do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.