Search results

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

Thanks Luke, this works perfect....I have made certain ammendments to suit the sort prefrences. One other thing in addition to the above macro, is there a entry to select the data matching two criteria and pasting it to a diffrent sheet. For eg in the attached sheet post running macro 1...

Hi All, I am trying to create a radom sampler for selecting random cases for audit, attached si the macro created. Within this macro i am unable to add the loop entry to ensure that the random formula is applied to the last entry in the 1st column. Kindly assist

Thank you NARAYANK991 this works great. should have thought about using data_text :) Thank you all

Sorry for the delay, below is what i am using {=COUNT(IF(('Status report'!A2:A111="Aug'13")*('Status report'!B2:B111="Open"),COUNTA('Status report'!C2:H111)))} Sample file has been uploaded on dropbox link https://www.dropbox.com/s/jd4nclj6owt4s2p/Status%20Report.xlsx?m

Hi with count ifs I am getting #Value and with Sum product am getting #N/A error

Hi All, I wanted to check for a little modification in using Count(if with a count A condition. Attaching a dropbox link for sample file... https://www.dropbox.com/s/jd4nclj6owt4s2p/Status%20Report.xlsx?m I am trying to get a count of "cells with text" in Defect Calculation sheet based on...

Hi All, Thanks a ton for help with above formula, i wanted to check for a little modification in this with a count A condition. Attaching a dropbox link for sample file... https://www.dropbox.com/s/jd4nclj6owt4s2p/Status%20Report.xlsx?m I am trying to get a count of "cells with text" in...

Awsome narayan... this worked perfectly... I had tried count a - countblanks earlier insted of<>... Thank you everyone for assistance

here is the dropbox link https://www.dropbox.com/s/ighlme35ti376ld/Samp.xlsx?m A brief description on what i am trying to do... Sheet 1 is going to be my raw data base which will be updated daily... in Sheet 2 in fron for every agent there are 3 coloumns Reject, exchnage and Refunds.. I want...

I tried adding 0 to it and also as an array but no result.