Hi,
Thank you all for all you replies so far. I need yet another resolution.
I need to input a formula in Cell A6 suggesting
if cell A1 contains "so & so text" then insert range A15 to B25.
I request you to please keep following until its resolved.
EDIT: Now I have attached the file Book1.xlsx with query. Kindly please have a look.
Thanks
Last edited by andyzz; 07-25-2014 at 06:19 AM.
what do you mean by "Insert Range A15 to B25"
Share your workbook and clearly show what you want to achieve with this formula.
Not sure what you mean by "insert range A15 to B25"??
Do you want the contents of every cell in that range to appear in A6?
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
Click 'cell A1', hold shift & then again click 'cell B25'. I'm referring to this selected range.
I need this range to be inserted starting from cell A6
Last edited by andyzz; 07-24-2014 at 08:53 PM.
Ok, and do what with it?
Sorry, not trying to be dumb, just trying to understand what you are trying to do
EDIT: Now I have attached the file Attachment 334804 with query. Kindly please have a look.
EDIT: Now I have attached the file Book1.xlsx with query. Kindly please have a look.
OK how about this, copied down and across...
=IF($G$1="specific text",D33,"")
I'm really sorry if i couldn't make it clear enough. your code is working perfectly fine but by 'specific text' i meant there
will be as much as 6 options & one will be appear in cell G1.
For eg G1 cell will have either of 'specific text 1' to 'specific text 6' & different tables are associated with all 6 options.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks