I have been managing many things through MS Excel and now i want to hire some people who are good at excel.
Is there any certification or accredation of professionals in excel which are recognised at national / international level so that i can specify it in my RFQ.
Regards
i have a string of text (alpha-numeric). How do i split the string into pre-defined array of cells (to be predefined by a separacter).
But how to do it :)
i am maintaining a data base which is enlisted in an excel sheet. Each row of the excel sheet represents a document which is placed in another document. A column in the data sheet has hyperlinks linked to each of the documents(where PDF is awailable, otherwise it only indicates the id of the...
Hi kchiba
the macro seems to work with fixed references.
what the system desires is that the macro should lookp through a column in the mother workbook for the file name (variable file names) of the daughter workbooks, copy contents of a range of cells and paste it against the file address...