• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need data automatically on sheet2 (result)

chiranjiv poojari
Can you help me after that because it will be easy for you as well as for me .
If above Your sentence is a question ... what would mean term 'easy'?

This time, You didn't give any comments about ... errors ... hmm? How possible? That means - everything has worked for a long time - yes!

You can modify, what You would like ... Yourself.
for me ... if there are FOUR (4) different almost like 'Tata Communications Limited' then there are FOUR different terms.
Ps. 'Data All' -sheet has ... ten (10) different terms which starts with 'Tata Communications'.
Ps2. eg Tata <> TaTa and so on ...
 
Sir ,
This time, You didn't give any comments about ... errors ... hmm? How possible? That means - everything has worked for a long time - yes!

Thank you for your efforts and dedication for my file .
Excatly how i want the file it wasnt like that .
80% of your shared file was correct .
but 20% i think there was little bit confusion in sheet 2
i will rectify it and share you with the new attachment

Once again thank you so much .:)
 
chiranjiv poojari
So You couldn't verify which 20% were not as You think?
There were values in 11 cells - that means ... You think that 2-3 of those were something else.
If even that is challenge for You then
how would You manage it, if there would be more values?
If ... some new attachment has different layout ... then good luck.
 
Sir,
Humble request ...
Please share the VBA password for this attachment
Im working on it
 

Attachments

  • macro file vendor 2 new.xlsb
    43.1 KB · Views: 2
Last edited:
chiranjiv poojari
Still no answers
and
that Your the newest file has error,
which will always give incorrect results = I won't do anything with it (... except deletion) !
You should focus for answers.
It could be possible for You.
 
Sir,
No its a old file
Im not telling you to work on that file .
I just needed a password what you had set for that file .
So that it help me for creating a new file and also enhance my knowledge.
 
chiranjiv poojari
Seems that You cannot or won't give answers as well as You skip all hints, which would help You ...

> I checked one more time Your data ... there were ... many things, which would be better as You should know and take care. <
> You could see some of those from this Result-sheet <
 

Attachments

  • new excel (2).xlsb
    48.6 KB · Views: 1
Last edited:
Hello,

I had made changes in sheet2: Result
i had clubbed a vendor name as below :
i had attach a word file for your reference named vendor

Solution : I want the data should be clubbed under one such as .
Total number count of invoices as per sheet 1 with clubbed invoice base , invoice tax, invoice total.
But amount should be split as per USD and INR .

Thanks in advance .
 

Attachments

  • new excel (2) resolution.xlsx
    58.2 KB · Views: 1
  • VENDOR.docx
    17.2 KB · Views: 1
chiranjiv poojari
Seems that You really cannot or won't give answers.
I've asked few times what needs to change ... if the best is that 20% from 11 should be something else
... and You cannot name which then ... that means, You don't know!
Seems that You didn't check my the newest version.
Word-doc ... I won't use that file with Excel-file = as Your given data is as it is - it will give that kind of results.
As many has used term, I should try too ... Do needed.
I cannot change anything!
 
chiranjiv poojari
...
should give answers.
Do You know that sentences which end with ? ... are questions
... and those are waiting for answers which would help You?

If You can ONLY use terms like NEED and WANT ... then You'll continue needing and wanting ... alone.
Next ... You should reread ( or read the 1st time) previous 33 replies and give answers for missed questions.
Answers should have some connections with my the latest file.
 
Hello Sir ,

Did You give new information with previous file?

I had made changes in sheet2 Result .
I had collated a vendor for which i require only 1 output in sheet2
Collated vendor are as below :

1)Tata Communications Limited :
a) Tata Communications Internet Services Limited
b) Tata Communications International Pte. Ltd.
c) Tata Communications Ltd
d) Tata Communications
e) Tata Communications Limited,
f) Tata Communications Limited

2) Tata Teleservices Limited :
a) Tata Teleservices (Maharashtra) Limited
b) Tata Tele Business Services
c) TATA TELESERVICES LTD
d) TATA TELESERVICES (MAHARASHTRA) LTD
e) TATA TELESERVICES LIMITED
f) Tata Teleservices (Maharashtra)
g) Tata Teleservices
f) Tata Teleservices (Maharashtra) GST Number:

3) STT Global Data Centres India Private Limited :
a) STT Global Data Centers India Private Limited
b) STT Global Data Centres India Private Limited

4) Bharti Airtel Limited :
a) Bharti Airtel Ltd

5) AT&T Global Network Services LLC:
a) AT and T Global Network Services India Private Limited
b) AT&T
c) AT&T Corp
d) AT&T Global Network Services, L.L.C.

6) Vodafone Idea Limited :
a) Vodafone Mobile Services Limited
b) Vodafone Mobile Services Limited
c) Vodafone idea ltd.

7) BSNL :
a)Bharat Sanchar Nigam Limited


8) Reliance Communications Infrastructure Limited :
a) Reliance Communications Limited

9) Amazon Internet Services Private Ltd:
a) Amazon Internet Services Private Ltd,
b) Amazon Internet Services Pvt Ltd
c) Amazon Internet Services Private Limited

10) Mahanagar Telephone Nigam Limited:
a) MTNL

11) Bharti Airtel Ltd :
a) Bharti Airtel Ltd.

Did You give a sample results?
I had attached sample result file for your reference.

I had your earlier shared file as per by new changes .

Im attaching both the file .

Please make necessary changes .
 

Attachments

  • macro file vendor 2 new.xlsb
    42.9 KB · Views: 0
  • sample result.xlsx
    58.8 KB · Views: 1
chiranjiv poojari
1) Answers should have some connections with my the latest file. - You skipped again - the latest file!
2) You also skipped those my needed answers too.
3) Your ... so called list ... maybe You have not even try to think something before write ... or is there more than one person - who writes something?
4) Your sample results ... yes - I see ... You didn't even remember, what did You just try to write.
5) Your Please make necessary changes ... I've offered already many times many necessary changes!
>> You should focus <<
I attached one more time my the latest file.
 

Attachments

  • new excel (2).xlsb
    42.8 KB · Views: 1
Thanks Sir ,

Sorry i skipped this file ..
i had checked your file .
all the columns are working correct except no of invoices cell .

Because i think their are similar name for 1 vendor its creating a problem .

For eg : Tata Communications Ltd has only 1 invoice with base amount 1300000 but its showing 2 invoices in no of invoices cell .
the correct result should be 1 invoices in no of invoices cell

As i have clubbed a vendor to get a appropriate count of no of invoices .
Above chat you can see my all vendor which i had clubbed below is only 1 eg for your reference

1)Tata Communications Limited :
a) Tata Communications Internet Services Limited
b) Tata Communications International Pte. Ltd.
c) Tata Communications Ltd
d) Tata Communications
e) Tata Communications Limited,
f) Tata Communications Limited

Pending with processing with finance should be 4 invoices in no of invoices cell.

you can also see my sample result for your reference .

Thanks for your effort and dedication for my file.
 
chiranjiv poojari
Still same same writings ...
Please do not start to thinking ... and there are no problems.
As many times, clear answers to questions have missed ... after those ... many things would already been solved.

I added 'grp'-sheet with instructions and samples - follow those and ... get something.
 

Attachments

  • new excel (3).xlsb
    47 KB · Views: 2
Hi Sir ,
Gm.

I have done with the file.
It really worked ......:)

i had got the data as i had accepted .

i had attached the file .
 

Attachments

  • Macro file daily report.xlsm
    69.8 KB · Views: 1
chiranjiv poojari
As long as there are only few groups ... those could do as with this.
... there are still few ... which could do better.
It would much useful to use fixed Vendor -terms.

You'll also need that (2) -version to verify those calculations.
 

Attachments

  • new excel (3).xlsb
    51.3 KB · Views: 4
Please sir it will be greatfull if you will share with me .
because it is a part of my college project because i have to explain to my colleagues too
 
chiranjiv poojari
As no answers from many questions ...
You should do something for Your college project
--- or ---
do I get some diploma or something from Your school?
How could You explain something from my code?
You would start to make more and more questions
... if those colleagues would make any questions from You ... hmm?
... ... means endless loop.
 
Back
Top