+ Reply to Thread
Results 1 to 4 of 4

Seeking Guidance/ Help with my Macros/VBA Code (File name changes with what date it is)

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    7

    Seeking Guidance/ Help with my Macros/VBA Code (File name changes with what date it is)

    Hello All, BIG time newbie here to the macros/VBA world so bear with my lack of sufficient knowledge. I have to do an inventory report everyday for work that is constantly changing. Multiple problems:
    1) I do not know how to make an array stop at the last row (there will never be the same amount of rows on any given day). Example:
    Selection.AutoFill Destination:=Range("C2:C304") ---> this needs to be Range("C2:Last row") and i do not know what that specific code is. There are multiple instances in the code where I need to change it to be the last row and not a specific cell.
    2)I will like to delete just the last four rows of the BB0716 file sheet 4 (the pivot table) in E281:F284 . Again, this will not always be its place holder as it could be higher or lower in the excel sheet but ALWAYS the last 4
    3) I will always have an excel window open with the two excel workbooks open of RBCxxxx and BBxxxx that will look like the base models attached. My problem is how do i make 1 macro to reference a file that changes names constantly? For instance tomorrow will be rbc0717 next day rbc 0718 etc. The file is always saved as the previous WORKING (M-F) day's date.
    4) At the end of this code i am not done with my process, i just don't have a clue what to do next. This is what i need to do:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by andrewg10; 07-18-2013 at 07:53 AM.

  2. #2
    Registered User
    Join Date
    07-17-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Macros/VBA Issue

    Sorry ran out of room!

    1) In the RBC0716 file,sheet RBCvBB, after the macro is done you should see the file sorted ascending order. I need to delete all rows that contain a zero.
    2) I need to then replace all cells in column D that have #N/A and turn them into a zero, which will fix row E. Then re-sort from B3:end of row Exxx(again don't know proper code). Then simply resize all cells and make column F 4 times the size (the size of F to I on a normal Grid)
    3) Then i need to do the exact same thing to sheet BBvRBC. Then I am done. Any Ideas?

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macros/VBA Issue

    Andrew,
    Welcome to the forum!
    If you had used code tags and wrapped your code with code tags as per forum's rule, you would not have filled up the page.

  4. #4
    Registered User
    Join Date
    07-17-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Macros/VBA Issue

    Thanks for the heads up AB33

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Issue with macros and password protection
    By Chiccada in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-17-2013, 10:26 AM
  2. VBA Macros Array List Issue
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 01:48 PM
  3. Macros causing a Read Only Issue
    By michellecairns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2011, 07:45 AM
  4. Issue with Vlookup using Macros
    By kapil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2010, 06:01 AM
  5. Personal Macro issue - 2 x macros
    By angel56 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2007, 04:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1