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.
How to insert unique Text on Summary Sheet
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
How to insert unique Text on Summary Sheet
You do not have the required permissions to view the files attached to this post.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78573
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to insert unique Text on Summary Sheet
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
Hans
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to insert unique Text on Summary Sheet
It is not working when I insert a new code.
See the attachment.
See the attachment.
You do not have the required permissions to view the files attached to this post.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78573
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to insert unique Text on Summary Sheet
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.
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
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78573
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to insert unique Text on Summary Sheet
Which version of Excel do you use? TVSMOD has been added to the Summary-Cash sheet on my PC with Microsoft 365:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to insert unique Text on Summary Sheet
HansV sir,I have 2019 version of excel.I have sent my revised file which I am facing problem .
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to insert unique Text on Summary Sheet
The same problem exist again.
Refer my new attachment
Refer my new attachment
You do not have the required permissions to view the files attached to this post.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78573
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to insert unique Text on Summary Sheet
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.
In the attached version, I have created formulas that should work in all versions.
If you edit them, confirm them with Ctrl+Shift+Enter.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to insert unique Text on Summary Sheet
Thanks Hansv,it is now ok and awesome formula that I know.
You are great SIR in this world.
You are great SIR in this world.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA