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...
1. i have a mother data workbook with the field which has the unique key ids.
2. A child data workbook is born as soon as new data entered in the mother workbook with a name same as the unique key in master data workbook.
3. i want to extract data from each of the child data workbooks into the...
Theer is a column if the open workbook which gives the list of workbooks which are to be referred and a range of values to be pased against the specific workbook name
Dear Kanti,
you are right the column A gives the name of the history work book corresponding to the row.
Please have a look at the macro above, where i have tried to use the Do-loop while but no result can be seen. The difference in this macro and the macro at the initial is that in the...
An excel sheet has list of issues as a line item in “DATA.xls”. In the column (1) has the unique ID for each issue (line) with a history workbook hypelinked to it.
Each history workbook is identical in all respect except the information in it. The history workbook will be updated by respective...