• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    need to create an automated excel workbooks based on criteria

    Hi Frds I wanna create a separate excel books based on status of the column F(Status). If contains pending completion, then the respective rows needs to be copied to new excel workbook along with the existing headers. and these excel file needs to be saved in folder and folder and excel work...
  2. V

    how to create sheets only for weekdays using coding in 2003

    Hi frds, I have a doubt and can anyone clarify it. Based on the template, i want to create separate sheets for every mon to fri (not for weekends)present in the respective month Example:for december month. If i press over a button which is the tempplate sheet, i should get 1st sheet name as...
  3. V

    if with multiple conditions in excel

    hi frds, below is my query, I have set of 16 digits numbers in a column. there is a another column based on this column. Let the columns be C & D. Baed on the last 2 digits of the column c , column D value should get changed. I have following conditions. if the no ends with 22 ---- AAAA...
  4. V

    assign keyboard shortcut key to run my macro?????

    I have written a subroutine procedure. would like to assign shortcut key i used the following sentence (Application.MacroOptions Macro:="g", HasShortcutKey:=True, ShortcutKey:="^Q") but it is not working when i press ctrl+Q
  5. V

    Run time error in the shared workbook

    hi, I tried to copy the values from different sheets and paste it and added the values in a separate protected sheet of the same workbook. macro is working well if the workbook is unshared. if i shared the workbook, it is not working. can you help me, pls?
Back
Top