Search:

Type: Posts; User: Chandresh; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Maro to copy data and paste based on cell value

    Thanks for your help
  2. Re: Maro to copy data and paste based on cell value

    Hi Below is the entire code which i am using were i have declared WB as woeksheet

    Sub CopyRND()
    '
    ' Chan
    '
    Dim wS As Workbook
    Dim wb As Worksheet
    Set wb = wb.Sheets("Process")
    '>>>>...
  3. Re: Maro to copy data and paste based on cell value

    it says runtime error 424
  4. Maro to copy data and paste based on cell value

    Hi Team ,

    I have 3 sheets Process, Master & Data
    Process sheet Cell “C1” has row number Example:”A2”

    My macro should copy data from Master sheet “A4:L200” and paste it in “Data”sheet based on...
  5. Replies
    2
    Views
    84

    Re: Loop Macro to all sheet

    Thanks
  6. Replies
    2
    Views
    84

    Loop Macro to all sheet

    Hi Team,

    My below code is running on activesheet how to loop through all sheets except two sheet



    Sub PDFSheetNoPrompt()
    Dim wsA As Worksheet
    Dim wbA As Workbook
    Dim strName As String
  7. Replies
    0
    Views
    66

    Name as the First Row of the page

    Hi ,

    I have multiple pages in a sheet I am trying to give first row of the cell as a file name reference with the below code but its not working
    can any one help me the correct code

    Example...
  8. Re: Macro for Creating PDF based on Cell Value

    HI thanks for the code .

    it created the first PDF however unable to create the others ,could you please help
    it says
    run-time error -2147024773 (8007007b)
  9. Re: Macro for Creating PDF based on Cell Value

    Yes
  10. Macro for Creating PDF based on Cell Value

    Hi Team,

    Can anyone help me with a macro which will create diffrent PDF for each page in a sheet and name it based on cell value and save in folder on desktop.

    Example : i have one sheet with...
  11. Replies
    2
    Views
    160

    Re: Macro to set a path

    Thanks for your help
  12. Replies
    2
    Views
    160

    Macro to set a path

    Hi all ,

    i have a macro which copies data from one workbook to current work book which is working fine.

    i need a help if i want to copy the data to some other file with the help of giving path ...
  13. Replies
    3
    Views
    222

    Re: Macro for forder Name reference

    Thanks
  14. Replies
    3
    Views
    222

    Macro for folder Name reference

    HI,all ,

    I am using following macro for extracting the data from sub folders my macro is working fine.

    just need a help if macro can update the reference of folder in column "Z" from where the...
  15. Macro to Run in all subfolders with criteria

    HI All,

    I need help in writing a macro which will run in all sub folders.

    I have more than 75 folders in which it contains 8 excel workbooks each. one of the work book named " Summary" has the...
  16. Re: Saveas active word document in specific folder

    Thank you very much for your help
  17. Saveas active word document in specific folder

    I am using the below code to copy values from excel and paste into word document and the macro is working fine .

    I am facing the issue while doing saveas word documents could you please help me...
  18. Open Excel and Paste in current workbook

    Hi All,

    can any one help me with a macro which will ask to select the excel file from the path(getopenfile method) and paste in current workbook

    I am using below code however it takes long time...
  19. Re: Copy data from Workbook and save in existing Workbook in specific Sheet

    Hi upload sheet is in macro workbook which is open , we need to copy the sheet from data1 workbook in macro workbook in upload sheet
  20. Copy data from Workbook and save in existing Workbook in specific Sheet

    Hi All,

    Can any one help me with a macro which can copy the entire worksheet from one excel work book(workbook name is Data1) to current workbook in -Upload worksheet.

    1) Both the workbook are...
  21. Replies
    7
    Views
    269

    Re: Ignore one sheet and run

    Thanks for help
  22. Replies
    7
    Views
    269

    Re: Ignore one sheet and run

    Hi I have many worksheets in the workbook in that there are 2 different worksheet with name 1) summary
    2) summarynew

    Above macro should copy the filtered data from all the worksheets (except...
  23. Replies
    7
    Views
    269

    Re: Ignore one sheet and run

    HI Thanks for your reply , however I am still facing the issue, could you please send me the entire code.

    Thanks in advance
  24. Replies
    7
    Views
    269

    Ignore one sheet and run

    HI All,

    I am using below code to run a macro however facing some issue , could you please help.

    what macro does- filters data in all sheets based on certain criteria and copy the filtered data...
  25. Replies
    3
    Views
    189

    Re: Conditional Formating

    hi,

    if I use below code my entire range becomes blue

    If cell.Value <> "" And (cell.Value > 0.05 Or cell.Value < -0.05) Then

    thanks
    Chan
Results 1 to 25 of 99
Page 1 of 4 1 2 3 4