Results 1 to 2 of 2

Thread: VBA for Finding the correct date and inputting value

  1. #1

    VBA for Finding the correct date and inputting value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm using excel 2013. I have a forecast spreadsheet with an input box for a"start date" and the weeks are listed horizontally. I would like to have VBA code to find the correct week to put the data into. The code then needs to reference another cell for the value to input.
    Any help is greatly appreciated.
    Thanks!

  2. #2
    Seeker Gary's Student's Avatar
    Join Date
    Mar 2014
    Location
    Lakehurst, NJ, USA
    Posts
    5
    Articles
    0
    Are the weeks listed as 1, 2, 3, ......etc. or by the first date of that week?

Posting Permissions

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