Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
script to launch a program from excel | Excel Discussion (Misc queries) | |||
Macro Script | Excel Discussion (Misc queries) | |||
how do i program a vb script in excel to tell me which cell has f. | Excel Programming | |||
Initiate perl script in linux from a Windows VBA program | Excel Programming |