I am looking for an IF STATEMENT that can look across multiple cells and if it finds anything greater than 0 to show that ID number.
Attachement
Sheet "data" look at A4 thru L4 and if it sees anything greater than 0 to pull ID from M4 and put ID on sheet "Value"
Last edited by VBA Noob; 10-31-2007 at 04:27 PM.
Put this formula under OppID in the Values sheet for any row you want to analyze
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
The formula works for items that have something in column A. However, it puts a 0 if there is nothing in column A, even though there is something in column B or C, etc. So, I need just a little more assistance. Thank you so much for your help.
Sorry about that. Ok different approach. Try this
Please Login or Register to view this content.
Yeah
Awesome! You are the best. Works great. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks