I try to avoid asking questions here, mostly I learn from just recording
macros then tinkering with them (that is just too cool), or the so
called help feature. The times I have asked though I have been just
blown away by the knowledge and generosity of the resident experts.

I hope I can explain this clearly,

I'm trying to select a variable range in VB based on cell data. I've
tried the index function, it doesn't work for me. I thought that was
the answer to my prayers.lol
Basically what I'm trying to do is have a macro that when executed
takes values that were just entered into cells by a user and puts those
values into a specific cell designated in the macro with a set column
and a variable row depending on a value in a cell defined by a spinner
or other means .

Essentially what I'm trying to do is use my custom oversized forms
I've created in worksheets to enter data. Then I want to have that data
compiled in other worksheets in plain old lists. Then I have my custom
oversized reports that utilize the stored data in various ways.

There must be a simple macro floating around that accomplishes this
seemingly everyday basic need of any business.

I have Access too but I haven't messed around with it too much because
I'm really attached to the screens I've made in Excel for operating my
business(because of my A.D.D lol). I didn't think Access offered that
flexibility. Excel seems like it should be able to do anything I need
it to, if I could just figure it out. I really don't mind the extra
work. I'm just learning as I go and know very little really. It is
really frustrating when you hit a stumbling block. This is a major
hurdle for me. Can someone please enlighten me?


signed, Perplexed


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=503747