Hi Friends,
I need one more favour. I though to post it separate but was sure would be able to get solution from someone of you. Attached is another workbook in which I need some help.
Sheet "Acrobat to Excel" column b have tag nos and column c have amount. By any formula/way I want to get tag no and following amount in same row. For example 7487981- and $3 in cells D3 and E3.
Now I copy column b and c and paste it in different sheet and then sort tags as all are in sequence and go to constants for amount and then copy and paste it. It works allright but seems that there is an additional step which I wish to avoid.
Attached herewith is the sheet. Pl let me know if do you have any questions.
Thank you in advance.
Regards,
Navin
From Australia, Perth
1I need one more favour. I though to post it separate but was sure would be able to get solution from someone of you. Attached is another workbook in which I need some help.
Sheet "Acrobat to Excel" column b have tag nos and column c have amount. By any formula/way I want to get tag no and following amount in same row. For example 7487981- and $3 in cells D3 and E3.
Now I copy column b and c and paste it in different sheet and then sort tags as all are in sequence and go to constants for amount and then copy and paste it. It works allright but seems that there is an additional step which I wish to avoid.
Attached herewith is the sheet. Pl let me know if do you have any questions.
Thank you in advance.
Regards,
Navin
From Australia, Perth
Pl chk if this is what u want. It is not working in ur case because, the criteria that u r looking (eg. d233) is not an exact match in column c
From India, Mumbai
From India, Mumbai
hi nickkan., i think i tried some best solution for your excel problem. please check it out and reply me... if it is correct solution.
From India, Coimbatore
From India, Coimbatore
Instead of dept you can get no of employee by using cell reference of code only. why you have to creat one more column Dept. other option i am looking in to that once i find i will reply
From India, Bangalore
From India, Bangalore
When you use a cell refernce and use like * option then it should be used along with &, that`s how excel works.
If you are not using cell referecne then you can use like * option without &
Hope this clarify your doubt.
Cheers
From United Kingdom, Hounslow
If you are not using cell referecne then you can use like * option without &
Hope this clarify your doubt.
Cheers
From United Kingdom, Hounslow
When I opened this file, it shows me binary digits like character. I really can not read this file, so really can not help by the time file cotains proper information. Cheers!
From United Kingdom, Hounslow
From United Kingdom, Hounslow
Dear, Check the attached file. Hope that your problem has been solved. Any clarification, please revert back. Best Regards, Alam
From Oman, Muscat
From Oman, Muscat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip