Hi,
Is there any Excel Formula or MACRO Code that will pick up a part of a Paragraph from a different CELL/ SHEET?
Example:
This is the sentence I want to appear in CELL B1.
"This is to certify that according to the records of this office, VOLGA DNEPR AIRLINES has no account pertaining to billed charges with the CIVIL AVIATION AUTHORITY as of to date."
The word "VOLGA DNEPR AIRLINES" comes from CELL A1.
Thanks in advance.
Use this in B1:
="This is to certify that according to the records of this office, "&A1&" has no account pertaining to billed charges with the CIVIL AVIATION AUTHORITY as of to date."
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank You for your reply, Sorry but I was not very Clear for my Question. I Wish to Attach the file for more details but I can't.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Re: Excel Formula or MACRO Code that will pick up a part of a Paragraph from a different C
Hello, Thank you again for your reply..
I Have two Sheet on a Workbook, one for "SUMMARY" and other is for "CERTIFICATE FORM", the result that I want is,
data from "Certificate FORM" comes from "SUMMARY" sheet (which is Font that is BOLD and RED in Color ),
my "Primary Key" will be the Certificate NO.
Please see attached File.
Thank in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks