Recent content by salviakshay

Hi, I am trying to make a Quality form in Excel, the questions will be one below the other with a drop down to choose from ( Yes, No, N/A) or Points (10, 15,20,30 etc). I want a macro that helps me transpose all the results of one evaluation to a new sheet in horizontal format and add the...

Hi Luke this was great worked like a charm

Hi Luke, I have ammended the file path, one finial thing remains and not sure if this can be incorporated, is it possible to add the user name to the file name before it is saved. for eg the randomizer will be used by multiple analyst, current the files are being saved as Extract_current date...

HI Luke, This works great i have edited the macro to include current time as well with Format(Now, "dd-mmm-yy h-mm-ss") command. Will it be possible to save the new created file to a diffrent folder, currently it saves the file in the folder from where the randomizer is being run. what if i...

Hi Luke, So what i am trying to do is post running following code Sub Random_Sampler_Final() Dim lastRow As Long Dim ws As Worksheet Dim wb As Workbook Application.ScreenUpdating = False With ThisWorkbook.Worksheets("Input") .AutoFilterMode = False lastRow = .Cells(.Rows.Count...

Hi luke, In addition to the attached earlier code, i am trying to have the automated email functionality, i found a code from some post (by you :)) and used the following to achive this. however in the earlier macro the new workbook is being created with a new name how do i edit the macro to...

HI Luke, sorry i forgot to mention that the copy agent logic was excluded. it was a bit confusing when the randomizer was used. i found a better way of doing it through PIVOT in chandoo tutorial http://chandoo.org/wp/2014/01/31/how-to-select-a-random-sample-from-all-your-data/. The above macro...

Hi Luke, I have attached the sample file, above code was giving me error while calling the second code. In the attached file, the second macro should copy the details from "pivot" sheet starting from a2 till E last row and paste it to a new workbook

Also a side request :- How do i learn the macro language

Hi Luke sorry if i sound stupid but i am trying to add the modifed code to following code, after the pivot refresh the next code should copy the data from a2 to end of E and paste it to a new workbook Sub Random_Sampler_v2() ' ' Random_Sampler_v2 Macro ' With ActiveSheet .AutoFilterMode =...

Hi Luke, I need to edit the macro to copy the rage from A2 to the last entry in column E. eg a2:e555.

Hi Luke, How do i edit the last row entry to copy the data from range A2 to last data of column E and paste it to a new sheet. currently the code reads data in the sheet only for column A lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

Hi Luke sorry for late reply I was OOO... this works as needed.

Hi Luke, I ment to mention 1 sheet only with details of all the agent is same sheet. one below other.

Hi Luke, it will be 1 sheet with unique entries for each agent