Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: VBA to copy data from different tabs to new sheet

    Column A has Dates.. Column G has values and cell H1 has unique number
  2. Re: VBA to copy data from different tabs to new sheet

    Column G has data on daily basis from very long time.
  3. Re: VBA to copy data from different tabs to new sheet

    >H1 has the data in all the sheets
    > Date format in column A is DD/MM/YYYY
    Still the macro is not pulling any data to data_store tab
    I can give you the file if that helps you
  4. Re: VBA to copy data from different tabs to new sheet

    I ran the macro.. Its running but not giving any result nor giving any error message.
  5. VBA to copy data from different tabs to new sheet

    Hi,
    I have data in multiple sheets in active workbook.

    Each sheet has unique ID in cell H1 and each sheet has value in ‘column G’ and Date in ‘column A’.

    I want to copy paste the unique ID...
  6. Replies
    5
    Views
    152

    Re: VBA code is not working

    Thank you.. Your method worked and its less complicated too.:)
  7. Replies
    5
    Views
    152

    Re: VBA code is not working

    After below line i am getting error

    .AutoFill Destination:=Worksheets("2018_T933").Range("A6:A" & lastrow)

    and

    .AutoFill Destination:=Worksheets("Sheet2").Range("K2:K" & lastrow)
  8. Replies
    5
    Views
    152

    VBA code is not working

    Hi,

    I am getting "Application-defined or object-defined error" error msg for below codes.. Not able to figure out where i am going wrong. Please help

    Sub conditionE()
    Dim lastrow As Long...
  9. Replies
    2
    Views
    199

    VBA with condition

    Hi,

    Could you please help with VBA code for below condition

    If the date in Column “I” is between 01/01/2017 to 12/31/2017 and Column “H” is >=0.50 Column A should display as A else D
  10. Replies
    3
    Views
    207

    Re: Autofill skipping blank cells

    That helped thank you so much
  11. Replies
    3
    Views
    207

    Autofill skipping blank cells

    Hi

    I am using the below code to autofill the formula however there are blank cells in column C I want the same cells in column in S to be blank... Below code is inserting the formula in all the...
  12. Re: VBA to Highlight entire row with conditions

    Instead of Highlighting the entire row is there a way to highlight the particular cells
    EG: IF Column J blank and Column R has some data then Highlight(vbyellow) only J
  13. Re: VBA to Highlight entire row with conditions

    Condition 3: is not working properly.. If Column S and T both are 0 it should not highlight the row..
  14. Re: VBA to Highlight entire row with conditions

    Yes, Blank and 0 to be created same
  15. Re: VBA to Highlight entire row with conditions

    It will be on existing data. And i would like to exclude CF
  16. Re: VBA to Highlight entire row with conditions

    Thank you so much for your time.. But i am looking VBA for this.. I have other plans for that coding too
  17. Re: VBA to Highlight entire row with conditions

    There are multiple workbooks and multiple people using it... so conditional formatting is not helping
  18. VBA to Highlight entire row with conditions

    Hi,
    I am looking for VBA to highlight the entire rows which satisfy any one of the following conditions for active sheet.

    1. IF Column J blank and Column R has some data then...
  19. Replies
    1
    Views
    519

    Volume tracker in access

    I am new bee here hoping to get some solution. I am looking for a tool to capture the volume processed by the team on daily basis. I tried to create it by own but couldn’t finish it… Could you...
  20. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Hoo.. okay thank you so much for your time...
  21. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Code is working but I wanted the zero if the plan ID is missing in sheet1 or sheet2. Ex: In sheet 'Anderson Heating' There is no value in column F and that is showing as blank I want zero instead of...
  22. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Its giving me an error as "Type mismatch" Coding is stopping at "if mount = "" then mount = 0"
  23. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Sorry I wanted a small thing to add.... Can we have zero in column B or F if there is no value.. Currently its showing blank instead of blank cell can we fill with zero ?
  24. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Thank you so much .. Thats exactly what I was looking for.. you made my life easy
  25. Re: VBA to copy data from a sheet1 and sheet2 to different tabs

    Yes.. Your understanding is correct.. I can convert the 6192019 into proper date format. Like 06/19/2019
Results 1 to 25 of 70
Page 1 of 3 1 2 3