Hello all,
I'm looking to some how transpose data and/or have it automatically fill in cells on Sheet1 (Departures) cells B-E when selecting a "Unit" from the drop down list in cell A. I have input all the data that would be used to fill the cells into a separate sheet.
Thanks in advance for any input.
Hello,
You can achieve this by using VLOOKUP
Here is your sample file with formula attached.
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
Thank you for that! Is there a way to remove all the 0's and only have the data fill-in cells B:E if there is actually data to pull from?
Yes you can, replace the formula in Cell B5 with the following one
And drag it right / down.
Please Login or Register to view this content.
Last edited by Lemice; 04-21-2013 at 01:19 PM.
Wondering if there is a formula to change G5:29's shade to black and font color to white if the word "TURN" is in the cell?
Yes you can, using Conditional Format (Format --> Conditional Format), and making use of the function ISNUMBER(SEARCH("Turn",G5,1)) assuming you are editing format on cell G5.
The Formula above will return TRUE or FALSE if the word "Turn" is found or not in a Cell. If you can provide a sample file, it will be wonderful.
Is it possible to tweak a setting so that the formula doesn't get cleared out accidentally or when pressing delete to clear data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks