[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

have a need at the office that could save about several...

<< Back to: comp.apps.spreadsheets FAQ

Question by Neil
Submitted on 11/2/2003
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Not yet rated Rate this question: Vote
have a need at the office that could save about several hundred people a lot of time in an upcoming conversion of data from an old project management application to a new one.  

In the old application,  financial data is presented on a web page in 12 cells across (for 12 months) and in several rows.  The new application, also web based, presents a similar row of 12 cells across and several rows down.  I am able to start in the upper left most cell in the old system and highlight the number and use control-c to copy the data and then move to the new application and use control-v to paste the data.  I then have to reposition the cursor to the next cell by using the tab key.  Is there a utility I can "train" to start in the upper left cell by indicating the location of the first cell in the old and new application and one-at-a-time copy/paste each corresponding cell from old to new application.  

I have tried using Excel as the source data but it, too, only works copying one cell at a time.  

Or is this something that could be built in visual basic?  I would like to be able to specify how many cells across and how many rows of data.

Have you ever seen something like that??

Neil Lesser

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.


FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.


<< Back to: comp.apps.spreadsheets FAQ

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

© 2008 FAQS.ORG. All rights reserved.