+ Reply to Thread
Results 1 to 2 of 2

wrong macro? doing something wrong?

  1. #1
    Registered User
    Join Date
    03-02-2016
    Location
    Vancouver British Columbia
    MS-Off Ver
    office home & business 2016
    Posts
    14

    wrong macro? doing something wrong?

    Please help me out with this last question and ill have this workbook complete!

    Sheet 3 in the workbook is a self made chart

    Column A is project name
    Column B is start Date
    Column C is End date

    I have than made a table for the full year
    (columns D THROUGH AH) are JANUARY 31 DAYS
    (Columns AH THROUGH BK are Febuary 29 Days
    and so on with December 31 ending in column NE

    all of these dates are in those columns and across row 2

    what I am trying to figure out is how or what macro do i use in the first cell below january (cell d3) so that with the start date in column b and end date in column C those are entered and i select across the entire row it will fill the proper dates with 1's and 0's where applicable, Than i will turn the font to white so it doesnt show up and have it converted to a bar resulting in a self made bar chart represented off the start and end dates

    so basically once i enter the start and end dates i want to than just click and drag across the entire row and have it automatically fill out the 1's and 0's or if somehow will automatically change to the bar once i click and drag that would be awesome but if not i cant figure it out either way

    i tried entering =IF(AND($B3<=D$2,$C3>=D$2),1,0)

    but when i drag it across the row it only copies all the 0's its not applying 1's where the project is undergo

    please help me

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: wrong macro? doing something wrong?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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] What is wrong with this macro?
    By detel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2015, 04:37 PM
  2. Wrong value to run the macro
    By dilipgr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2015, 06:33 AM
  3. [SOLVED] What is wrong with this Macro???!!!!?!?!?!><
    By AstToTheRegionalMGR in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-17-2015, 02:59 PM
  4. Wrong coding or RANDBETWEEN is wrong?
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-31-2013, 10:01 AM
  5. HELP: What is wrong with this macro??
    By henwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 08:20 AM
  6. What's wrong with this macro?
    By belly0fdesire in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2006, 07:00 PM
  7. What have I done wrong with this Macro???
    By Shandy720 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2005, 12:05 PM

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