I have a complex script that I want to program but do not know where to
start. Let me explain my situation.
I have to complete reports at my work by inputing numbers from one
spread sheet to another. It is very time comsuming. Now, what I want to
do is simple, all I want is to input the numbers from one spread sheet
to another in the correct fields. Thats easy but here is when it gets
complex.
The spread sheets changes order in cells every 2 hours. Example, I
want to input ABC number from one report to another but ABC will be on
b2 at the 1:00 report and then at 3:00 it will be on b23, so I cant do
a simple index, so this is my idea. ABC on this sheet equals ABC on
this sheet. I wanted to know if you could program scripts based on
alpha charcters instead of cell placement cause the cells change all
the time.
You do not have to give me the answer, just point me in a direction
that I can work with. I would prefer to search it up myself and see how
to do it. If you have broad answer I can work off of that.
Thanks for anyones help.
BJ
--
bjwoodruff
------------------------------------------------------------------------
bjwoodruff's Profile:
http://www.excelforum.com/member.php...o&userid=24259
View this thread:
http://www.excelforum.com/showthread...hreadid=378673