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?
Last edited by Robert1116; 03-12-2010 at 09:33 PM.
Hello Robert1116,
Welcome to the Forum!
Are you looking for a VBA macro or a formula solution to this problem? I am asking because this is a programming forum.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Formula, should i delete this?
Hello Robert116,
No need to delete the thread.
Hello Robert116,
You should be able to use the Concatenate worksheet function. The example here shows how to place the values of cells A1 and B1 into another cell on another sheet.
=CONCATENATE(Sheet1!A1,Sheet1!B1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks