I need to have the values from 2 different blocks one possibly text the other number or text to display in one block in a different tab. Either G4 or H4 or Both if both have values in them. Its a workbook with 2 different sheets, one being filled out by a person and the data going to the other tab with no user interaction. What is the function to make this happen?
Welcome to the Forum
I agreed with Somesoldiers (in the previous thread) - & was going to suggest a better title may be along the lines of "conditionally populating cells with values from another sheet". However, Paul closed the other thread & you beat me to it in this one!
If you're happy to investigate & learn by yourself - here are some functions which you can read up on in the Help files: Len, IsBlank, IsText, IsNumber, Or, & And.
btw, People will be able to help more effectively if you post a sample workbook with explanations & a "before & after". To do this, "Go Advanced" & then click the paperclip or "manage attachments".
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks