Recent content by Gulshan Hinduja

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 am trying to generate a 2D barcode in excel. But everything on net is chargeable. I am not willing to pay :((

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 want that the extract of a spreadsheet to appear in the slide show

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...

How do i secure the macros on excel sheets which have been made available to other users?

Dear Kanti. gkp.hinduja@gmail.com please loop and forward file as suggested.

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...

Dear kchiba, i am getting a complete error - syntex error at ConRange = SheetNam &; "'!" &; CellAdd ConNam = DirNam &; "[ &; FilNam & ]" Range(TarCell).Formula = "='" &; ConNam & ConRange

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...

Looking for a counter which counts the number of times the sheet has been opened. Preferably a formuala / UDF

I am striving for a functional UDF PULL code and a procedure to use it.

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...

Sub UpdateDATA2() Do Sheets(1).Activate Range("A65536").End(xlUp).Select If Cells(ActiveCell.Row + 1, 1) > 0 Then Application.Workbooks.Open ("C:Issue folder" & "" & Sheets(1).Cells(ActiveCell.Row + 1, 1).Value & ".xls") Range("AA2:AZ2").Select Selection.Copy ActiveWorkbook.Close...