Search results

Dear Ninjas ! I have a sheet with raw data ! I am trying to consolidate and get only unique entries. I have uploaded the sample file here - 48KB http://www.2shared.com/file/5E-46vnE/summary-sheet.html which also contains the desired output. Please help me with a code to achieve this. Thanks.

Hi Ninjas ! I am trying to modify VBA given at http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/ so as to include the sheet from which to copy. I have added an extra column at H in "Sheet:List" to include the Sheet Name lines marked '-------------- thus were...

Hi Ninjas ! I am trying to pass a named range to the below code, but it pops an error. I would like to replace "A1:P79" with a named range. GetData ThisWorkbook.Path & "asc.xlsm", "stock-out", _ "A1:P79", Sheets("Sheet2").Range("A1"), True, True ---------------------- Public Sub...

please help with this loop ! Cell B2=23 copy range B6:U6 insert indirect(B2) rows starting at row 7 paste copied range (B6:U6) to all indirect(B2) rows Thanks.

In one work book, I constantly add rows in between Rows 8 & 14. If I add 5 rows in the raw data work book, I would like to have the same rows inserted in another work book automatically. Any ideas. Thanks.

Hello Friends, Please help with a formula. I am trying to get the value of column C, 11th Row from top. When filtering the 11th row changes value, and I would want the changed value in another cell (C8). Sample worksheet link is given below...

Hi All, Could anybody help solve this issue. I am using Excel 2010. When opening a file, I get this error message : "Excel found unreadable content in 'file name.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. and when I...