Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    243

    Re: VBA to move data

    I need the data on the related tabs for project submission.
  2. Replies
    4
    Views
    243

    VBA to move data

    Hello,
    I an in need of a VBA Code to move data from one tab to another based on the action column.

    Example: This is the main sheet (Tab) holding all data
    Sheet Name: FUTURE

    <tbody>
    A
    B
    C
  3. Thread: Macro Error

    by wavery
    Replies
    1
    Views
    186

    Macro Error

    I have been running this Macro for a while and all was good until my computer was upgraded to windows 10. My excel is now Excel 365 2016. The debugger highlights the row I put in red. Any help with...
  4. Replies
    8
    Views
    254

    Re: Why 1004 Run Time error at Red Text?

    I tried the date string and got no positive results. This code has been working for awhile now so I fond it strange that the date would all of the sudden not work. The only difference between this...
  5. Replies
    8
    Views
    254

    Re: Why 1004 Run Time error at Red Text?

    Msg Box Shows $A$1:$AA$101646
    My Data A1:AA15841
    My table is set A1:AA15841
  6. Replies
    8
    Views
    254

    Re: Why 1004 Run Time error at Red Text?

    The Code was working fine until I added a new month of data. I added it the same as always??
  7. Replies
    8
    Views
    254

    Re: Why 1004 Run Time error at Red Text?

    Not sure I understand? Sorry for being such a noob
  8. Replies
    8
    Views
    254

    Why 1004 Run Time error at Red Text?

    Sub CopyData_Machine_Performance()
    Application.ScreenUpdating = False
    Dim lastRow As Long
    lastRow = Sheets("DATADump").Cells.Find("*", SearchOrder:=xlByRows,...
  9. Re: VBA: Copy Date in Cell B2 & Paste Range B3 to last Row

    This is great thank you.
  10. Re: VBA: Copy Date in Cell B2 & Paste Range B3 to last Row

    Column "A" will be fine.
  11. VBA: Copy Date in Cell B2 & Paste Range B3 to last Row

    Hello,
    I am looking for a VBA Code to copy the Date in Cell B2 on Worksheet "Page1" and Paste the date in a range from cell B3 through bottom row on same worksheet.
  12. Replies
    7
    Views
    337

    Re: Workbook Too Large Won't Open

    I got the workbook open. I noticed that there are a lot of sheets listed in the VBA Project list that don't exist in this workbook.
  13. Replies
    7
    Views
    337

    Re: Workbook Too Large Won't Open

    Thank you for your response. When I move existing sheets to a new workbook is there a way to update all of the formulas or will I have to do each one?
  14. Replies
    7
    Views
    337

    Workbook Too Large Won't Open

    Hello,
    I have a workbook that I use for "Performance" tracking of our machines. I currently have multiple worksheets in this workbook. I have tab for graphs with 15 different graphs on each tab....
  15. Re: Copy Data From One Sheet To Another With VBA

    THAT WAS IT!!!!!!! It works great, Thank you for all of your help.
  16. Re: Copy Data From One Sheet To Another With VBA

    PC / WINDOWS 7 PRO / 64-bit OS

    Sorry for being difficult, but once working this will save me a lot of time.

    Thank you for sticking with this
  17. Re: Copy Data From One Sheet To Another With VBA

    2016
  18. Re: Copy Data From One Sheet To Another With VBA

    Not sure what I am doing wrong but Im unable to get the test download to work. Same result creates column headers but no data??
  19. Re: Copy Data From One Sheet To Another With VBA

    This is great!!!! The Macro created the column headers "Asset Number", Game Type", "Lease Cost", however there was no data?
  20. Re: Copy Data From One Sheet To Another With VBA

    Hello,
    Sorry I was off yesterday. Yes the year column does have more than one year. I can add a "Year" cell on "REPORTDATE" Cell D2 if needed to filter.
  21. Re: Copy Data From One Sheet To Another With VBA

    I am saying that I need the data based on a certain month of the year. The month is decided by the date entry on worksheet "REPORTDATA" of this workbook in cell C2. I guess we could have the macro...
  22. Re: Copy Data From One Sheet To Another With VBA

    Yes "Lease Cost" is "Fee Amount". "Gaming Month Name" is the month date, 1/1/2018, 2/1/2018, 3/1/2018 and so on. All Asset Numbers for any given month will have the same "Gaming Month Name" 1/1/2018,...
  23. Re: Copy Data From One Sheet To Another With VBA

    Alansidman,
    I tried the code and it retuned no Data. I would also like for it to run with a "Gaming Month Name" Example 5/1/2018. Please let me know f you need any more info.
  24. Re: Copy Data From One Sheet To Another With VBA

    Thank you for your replies.

    mumps: It is "Game" Type" sorry. I would like for it to be in order "Asset Number", "Game Type", "Lease Cost", also I would like to run it for a "Gaming Month Name"...
  25. Copy Data From One Sheet To Another With VBA

    <tbody>
    Gaming Month

    Gaming Month Name

    Gaming Year

    Denom

    Game Type
Results 1 to 25 of 25