Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

excel visual basic question

  • Please log in to reply




  • Member
  • PipPip
  • 50 posts
Hi i have to write a program for a project.
Basically, its an optimization problem but for job assignments. there are 13 orders and 13 machines and solver needs to find which machine is optimal for which order. when solver outputs the solution, its in a table format where each column and row must only have one value of 1 and the rest are zeros (the 1 means that order should be used at that machine) . The trouble is that i need to use visual basic to enter the data in sheet2. sheet 2 has a table with all the orders listed and it needs to type in which machine that it should use. I can easily do this by searching the output table and seeing which order and which machine has a corresponding 1 under it and type it in sheet2, but i need visual basic to find the 1's from the output table and type the corresponding machine under each order. Anyone have any input?
  • 0




    Tech Staff

  • Technician
  • 1,323 posts
Hello arf,

Is this homework or work-related?

You can try using find:
Excel Find Method in Excel VBA. How to Use Find in Excel VBA Macros

I don't know much about the setup, is there a row for every order and a column for every machine?
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP