Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Hi Trebor thanks for the reply. I am not signed up for Box.com as of now and I still really want to know why its not working. I think its something new I will learn if it ever happens again. Listen I...
  2. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    HI Trebor76 there are no spaces nothing. Your code is actually not breaking, but what its doing is looking threw my modules as i see them flash. It is taking info from different modules i have and...
  3. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Hi yeah i agree with you guys. There is something with my sheet. I am going to review it today and figure it out and will get back to you guys on what it was.

    Thanks again
  4. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Hi,

    Thanks for the reply, but again i am getting debug on both codes and i dont know why.

    Trebor76 it debugs at this spot


    Set WS = ThisWorkbook.Sheets("LCP")

    My workbook and tab is LCP....
  5. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    I just opened the sheet LCP. I then changed the tab to Sheet1. Now it skips above break and breaks here.


    counter = .Columns(c).SpecialCells(xlCellTypeVisible).count
  6. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Yeah i did it for an example to show how I was splitting it, but thse results should be in 2 different books.. The Worbook's name is LCP yes (active book). Whatever it does after that i dont care. It...
  7. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Hi thanks for the response(My Answer Is This) Your code debugs on me at this spot.



    lastrow = Workbooks(WB).Sheets(WS).Cells(Rows.Count, c).End(xlUp).Row

    So it doesn't work because nothing...
  8. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Trebor i think i see whats going on with your code. I think it searches threw all my modules of codes and is picking up other stuff to do and pasting it on the new sheets. Instead of looking at just...
  9. Re: Copy certain lines from active sheet and paste it to book 1 and 2

    Hi guys thanks for response, but both are not working. Trebor i do get 2 sheets that open up, but it doesnt paste from orginal sheet. Wierd on what happens. The Anwser your's debugs right in this...
  10. Copy certain lines from active sheet and paste it to book 1 and 2

    HI,

    Trying to do something like this


    If "Yards" is in column A then copy and paste all the rows to a new book

    If "Grass" is in Column A then copy and paste all the rows to a new book.
    ...
  11. Re: Need to add todays date everytime i save file

    o yeah sorry I don't know why I cut that off. It was the file format


    FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

    Thanks
  12. Re: Need to add todays date everytime i save file

    hi thanks for the resposne, but i am getting these in red? like something is wrong


    ActiveWorkbook.SaveAs Filename:=fname,_
    Application.DisplayAlerts = True
  13. Need to add todays date everytime i save file

    ChDir "C:\Users\frank\Desktop\OCIP"
    ActiveWorkbook.SaveAs Filename:="C:\Users\frank\Desktop\OCIP\LCP.xlsx", _



    The file I am saving is called LCP. I would like it to be saved different every...
  14. Thread: =sumif?

    by zone709
    Replies
    4
    Views
    146

    Re: =sumif?

    i got it eric thanks had to take out <
  15. Thread: =sumif?

    by zone709
    Replies
    4
    Views
    146

    Re: =sumif?

    this is giving me all numbers. Looking to pull in all numbers that dont have the name equal rental in column D
  16. Thread: =sumif?

    by zone709
    Replies
    4
    Views
    146

    =sumif?

    Add numbers up in column C that don't have the word (equp rental) name in column D. I was thinking =sumif <> equp rental, DD

    I don't know
  17. Replies
    7
    Views
    267

    Re: Formula help return number once only

    I did but the first name keeps pulling in the same name all the way down. I am leaving now i will check tomorrow. Thanks fro the reply.
  18. Replies
    7
    Views
    267

    Re: Formula help return number once only

    Hey guys thanks for the reply. I just ran into something simliar and tried these formulas but didnt work.

    In column B I have names that are the same but only want to return one name at a time like...
  19. Replies
    7
    Views
    267

    Re: Formula help return number once only

    works great thanks for the help
  20. Replies
    7
    Views
    267

    Formula help return number once only

    Hi,

    Trying to do a formula to return number only once.

    Example
    Staring from row A2

    I have going down an more.
    A
    10
  21. Replies
    6
    Views
    307

    Re: ? How to find duplicate numbers in a column

    Thanks guys
  22. Replies
    6
    Views
    307

    How to find duplicate numbers in a column

    HI trying to find the fastest way i can find duplicate numbers in column BQ. Meaning i have like 500 lines of numbers in BQ. Just want to find out whats duplicting. So if 6 and 6 are in column BQ i...
  23. Replies
    12
    Views
    717

    Re: If formula not working right

    Hi ok i just tried scotts maybe ill use this thanks. Also the "" works now thanks for the reply
  24. Replies
    12
    Views
    717

    Re: If formula not working right

    HI I came back here cause I cant get rid of this return "

    If nothing returns right instead of returning blank cell like I think its suppose to. It returns " Anyone know why this returns "
    ...
  25. Re: Need to return dates not sure either formula or macro

    This is it. Why didnt i think of this this way. Thanks for the help. I really didnt think it out to much. :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4