Thread: Excel Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jim hardwick jim hardwick is offline
external usenet poster
 
Posts: 2
Default Excel Macro

I'm trying to convert an old macro from Lotus 123 to excel and am having some
difficulty.

What I want to do is look at the data (which is a number 1-75) in a specific
cell and match it from a range (rows labelled 1-75), then goto the matched
cell in the range and search column by column until it finds a blank one.
Then input the data from a input box into the blank cell.

The problems I am having are getting the macro to activate the matched cell,
search and then input the data to the sheet (I've got the input box to come
up).

Please Help Me