Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |