Search results

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...

I know how to do this, but I have an issue. I have A1= A1 on sheet 2. But instead of returning the value, it returns the formula. Thoughts?

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...

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.

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?

Ok So I have list in excel, column A.The list corresponds to file names in a folder on my desktop, I want the VBA to find the names in column A in my folder and move those files to another folder. Example is in A1 the file name is "ZAC". On my desktop is a folder called Cousins. The file ZAC...

So I thought I was getting a grasp on this formula stuff, or maybe just not enough coffe, but I have a formula that I want to equal a cell value, but if the cell value = #N/A then it needs to return a G. This is what I have and cant figure out why it wont work. =D2 IF(D2="#N/A","G", " ") So...

I am trying to concatenate cells that are in a row , lets say A1-A6. Each cell has letters that correspond to a task, so I am trying to concatenate them into one cell, A8, then I want to remove duplicates in that cell. So if it is "A,B,S,A,C,B" I want the end result to be "A,B,S,C". I have...

Lets use A1,B1,C1,D1. C1 is the sum of A1 and B1. I want to be able to retain the SUM in D1 even after I clear the other cells. What I am doing is tracking time, and at the end of the week they turn their time in, clear the sheet and start a new week. I want a way to carry the total time over...

I have this code which works great, I just want to go one step farther. This code allows users to clear contents on a protected sheet. I want to keep that function but apply it to a specified range of cells. C6 thru T130 are the cells that I want to apply this too. This includes Column C...

In A1 I have combo box with my list in it. I want it go to a certain cell when that cell is referenced. Example: My combo box says A6, and when I select this from the combo box, I want it to go to cell A6. I have tried hyperlinks but I cannot get them to work in the combo box. I do not...

Ok first let me start off I DID NOT write this code. I like the way the code works but I need it to be tweaked a little bit. In column A I have a time (6:30) In column B the stop watch will run In column C is another clock and I am not sure what it is This is how this works now, I click...

Hey, so I have a formula "=+'All Records-Department Specif'!H2".... which works fine to return data from the All Records-Department Specif sheet and place it into my second sheet. My question is how do I get only the first number of the H2 cell? I have tried every combination I can think...

Ok so I have accounts in Column A. For those accounts I have due dates, which I have conditional formatting set up to change cell color. My question is there an easy way to send myself an email 45 days prior to the due date. I am using lotus notes and it is ok if notes has to be open as I...

I am done with my book, but when I clear the data from the cells, I lose the formulas also. Is there a way to hide or lock the formulas in certain cells so they wont be lost.

First off let me say thank you to those who help out on here. You help us noobs learn something everyday. I have asked 4 questions, got many replies and I appreciate all the help. Tonight I was able to write my first formula without needing to ask for help. I was able to look at what I have done...

I guess I am not thinking like excel, but I am trying to learn this formula writing. I want H3 to show either 3 or 10 depending upon the answer in F3. If they put N in F3 I want H3 to return 10, if the put Y in H3 I want it to return 3. I tried it with an if statement =if(F3=Y,3),(F3=N,10)...

I want to return 3 days from today! I have =today()+3..... but I need to use the workdays int. and I can not figure out where to put it. This is simple I am sure but I am mush right now. thanks

Ok I have been trying to get this using the "or" statement but I may be way off. I have three sheets, the first sheet, in cell C3 I want to show total number of items in column A of second sheet. I also want C3 to return total number of items in column A on the third sheet if there are no items...

OK, working on a Excel workbook, in one cell I have todays date(E1). In another cell it will have either "NP" or "P"(J1). Depending on the response put in J1 I need a return in J2. What I need is that if "J1= NP" then "J2" = "E1+10" or if "J1= P" then "J2" = "E1+3" I do not want "E1" to...