How to insert unique Text on Summary Sheet

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

Hi Good Morning

Please refer my attachment.

I want to insert Column C text unique on summary sheet.Namely-Summary F & O and Summary cash from their yellow tab colour sheet.

But unable to any idea.

For an example-Refer sheet summary-F&O,in this sheet column B unique text is taken from Sheet ICICI Direct-F&O.And the same taken in next combination of sheets-Summary Cah and ICICI Direct-Cash.
You do not have the required permissions to view the files attached to this post.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 78783
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to insert unique Text on Summary Sheet

Post by HansV »

Does the attached version do what you want?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

It is not working when I insert a new code.

See the attachment.
You do not have the required permissions to view the files attached to this post.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 78783
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to insert unique Text on Summary Sheet

Post by HansV »

Where exactly is the problem?
Best wishes,
Hans

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

the problem is appearing any other text on column C on the sheets i.e. ICICI Direct-F&O and ICICI Direct-Cash.

For an example,I am inserting a new company name.ie.TVSMOT on sheet ICICI Direct-cash ,but the formula is not working on sheet Summary-Cah.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 78783
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to insert unique Text on Summary Sheet

Post by HansV »

Which version of Excel do you use? TVSMOD has been added to the Summary-Cash sheet on my PC with Microsoft 365:

S2515.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

HansV sir,I have 2019 version of excel.I have sent my revised file which I am facing problem .
Regards

Pradeep Kumar Gupta
INDIA

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

The same problem exist again.

Refer my new attachment
You do not have the required permissions to view the files attached to this post.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 78783
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to insert unique Text on Summary Sheet

Post by HansV »

The functions that I used require Microsoft 365 or Office 2021.
In the attached version, I have created formulas that should work in all versions.
If you edit them, confirm them with Ctrl+Shift+Enter.

Pradeep.xlsb
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
PRADEEPB270
3StarLounger
Posts: 354
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Re: How to insert unique Text on Summary Sheet

Post by PRADEEPB270 »

Thanks Hansv,it is now ok and awesome formula that I know.

You are great SIR in this world.
Regards

Pradeep Kumar Gupta
INDIA