I tried it but it still does the same thing. What happens is when it does not find a file, it wont move any files after that. I did not get the message box either.
Ok so I have this code, and it works great AS long as the file is available. What is happening is when I select go, it looks in column A for the file name, then goes to the folder where the file is(Column B), and moves it to a new folder(Column C).
The problem is that if the file is not found...
So after re reading I see better, when we return fruit, it should return anything in the fruit column. So the column is labeled fruit and in that column is apples, bananas, peaches. It would return this if the user selects fruit, but if the user selects meat, it would return pork, steak...
Can I execute a formula inside a formula.
My colleague is want to to do this:
If he selects fruit, he wants his hlookup to return for the selected hlookup for fruit, but if he selects meat, he wants his hlookup to return the selected hlookup for meat.
Example...
Upon open I want the dashboard to update. I am not a guru so just trying to put something together. I imagine cell links would be the easiest for my knowledge level.
I am kinda making a dashboard. In my folder I have 5 other excel files. My question is can my dashboard pull from those files as changes are made? It could update on open, which is fine.
Ok I thank you for your patience and help. I did get it to work. I have more than one sheet in the workbook, so I had to define the ranges for just the specific sheet. Once I did that everything worked fine. Again thank you.
Why does your range have an Offset for some of the ranges? I tried to copy them over to define the range, if I could figure out how to send you the book I would, but it has "confidential" info in it.
I can not figure out what I am doing wrong. I copied the code into my VB editor for the worksheet. I am using Sheet 2 in my book. I have my C1 D1 E1 as the cells for the commands, but I am getting nothing. The book you attached is doing exactly what I was wanting. I also have the Macro added in...
I have Excel 2010. In row 6 I have either an S or P in column F thru EH
You are correct in what I need my action to be. If I select "S" I want only the columns that have a "S" in row six to be visible, much like a filter would work. And the same if a "P" is selected, would only show the...
In row 6 I have several columns, some that contain an S and others contain a P. I want to have an active cell that when I click on P ( say A1), only the columns that contain a P in row 6 will be visible. Is this possible?
I am not sure how to post an example from my skydrive but let me try the embed link,
https://skydrive.live.com/view.aspx?resid=63F95EA410E059A9!130&cid=63f95ea410e059a9&authkey=APS0V9azIHK4nIY
Let me know if this works...
I may not be explaining this right. In column A is a list of server names, they are all different and unique..These are extracted by a script from the another sheet. The actual server file would be "I_move_TED.mefs" which is the mef file that belongs to the server TED.The script unfortunately...