Hi,
i have a document that i need to get data from different sheets but i dont want the receiving sheet to state "0" when the original data does not have filled text in it. i hope im not confusing anyone. is there a workaround to this? many thanks in advance.
Pang
ive attached a sample file.
Getting Data from another Sheet.xlsxGetting Data from another Sheet.xlsx
maybe this?
=IF('Main Document'!B65="","",'Main Document'!B65)
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
3. Click on the star if you think someone helped you
Regards
Ford
Try this:
=REPT('Main Document'!B2,1)
hey guys,
both formula's worked great.
thanks.
You're Welcome!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks