Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Open and print sheets in a workbook using vba

    I want to be able to click a command button and the macro will open another work book and print the first 3 sheets in the new workbook

    This is what I got so far

    Private sub...
  2. Re: How to print worksheets from a different work book?

    Sooo what I'm trying to do is I have a main sheet where I enter all this data. Afterwards I have a button on the sheet and it prints all the receipts I need. I want the receipts to be in a separate...
  3. Re: How to print worksheets from a different work book?

    I named the sheets "1" "2" "3" "4"
    I don't have to put in the whole file name where it's located? Like the "c:" drive part?
  4. How to print worksheets from a different work book?

    Private sub command button1_click()
    If Range("J15").value=4 then
    Workbooks("c:\ tournament\bad beat\ receipt file.xlsm").worksheets(array("1","2","3","4")).printout
    Else
    End if
    End sub

    Says...
  5. Re: Help with entering data in one workbook and updating data in another workbook automatically without opening the 2nd workbook

    I the main sheet I enter data like name number
    On the receipt workbook I want the data entered on the active workbook.sheet to be in the same so when I print the receipt it has the current info
  6. Help with entering data in one workbook and updating data in another workbook automatically without opening the 2nd workbook

    So I have a main sheet where I enter all the data and it asks how many receipts I want printed
    The receipts are in another workbook. How do I update the receipt workbook with the new data entered in...
  7. Re: Help with putting a formula into a cell in vba keep getting error

    Thanks!
  8. Help with putting a formula into a cell in vba keep getting error

    When I try to put a formula into a cell in vba using

    Range("A2").formula="=iferror(vlookup(A1,'array sheet1'!A2:B20,2,false),"")"

    I get application-define or object-define error

    I use...
  9. Re: How to printout a specific number of sheets in a work book based on a value entered

    Help
  10. How to printout a specific number of sheets in a work book based on a value entered

    I have a workbook where in the 1st sheet I have a spot to enter a value and then I want to click a button and it will print the next corresponding sheets in the work book. For example if 5 is entered...
  11. Re: Trying to consolidate data from several sheets into one

    Sheets("CD").range(cells(2+x,3+x)).value=sheets("pit 1").range(cells(5,2+x6)).value

    I get application defined or object defined error
  12. Re: Trying to consolidate data from several sheets into one

    I took a picture but how do I post it in this forum?
  13. Re: Trying to consolidate data from several sheets into one

    There is a lot of data want to try to run a loop
    To move all the data to one sheet
  14. Trying to consolidate data from several sheets into one

    Need to run a loop that takes data from one sheet and put the data onto another.

    Sooo on the new sheet

    C3=B5
    D3=C5
    E3=D5
    F3=E5

    C4=H5
  15. Replies
    2
    Views
    159

    How to ad the text in column B to column A

    I have last name in column A and first name in columnB.
    I need it to combine together in columnA

    ColumnA. ColumnB
    Steve. Smith

    Will look like
    Steve, Smith
    In columnA
  16. How do I run a loop for how many rows I have

    X = 1 to y

    Next x

    Y has to be the number of rows I have data on my sheet
    How to I set what y is?
  17. Re: getting rid of multiple entries of the same name but adding a value together

    Actually I got it to work! Yeah! Thnx a lot!
  18. Re: getting rid of multiple entries of the same name but adding a value together

    Its adding up in column F which is what I need but the info in columnB is overwritten with the info from columnC and columns C,D,E is blank
  19. Re: getting rid of multiple entries of the same name but adding a value together

    they added more colums now!fml!

    so now i have column A,B,C,D,E,F

    add totals of column F if column A,B,C, are the same column D and E dont have to be the same




    can you tell me how to...
  20. Re: getting rid of multiple entries of the same name but adding a value together

    Actually I need them both to match cause of common first names
  21. Re: getting rid of multiple entries of the same name but adding a value together

    If column A match then column B will match for sure
  22. Re: getting rid of multiple entries of the same name but adding a value together

    Column A is first name column B is last name column C is a value. I need it get rid of duplicates but add column C together. I need column A and column B to stay the same.

    So the data would look...
  23. Re: getting rid of multiple entries of the same name but adding a value together

    It's adding it up and putting the result in column B and deleting the last name. I need the results to be in column C and retain the last name
  24. Re: getting rid of multiple entries of the same name but adding a value together

    How would the vba change if I need to ad column C together and not column B
  25. Replies
    22
    Views
    913

    Re: converting expression into total mins

    My bad I forgot to change C1 to C2.
Results 1 to 25 of 45
Page 1 of 2 1 2