×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data from one excel sheet to another

Data from one excel sheet to another

Data from one excel sheet to another

(OP)
I have two .xls files, one has account numbers on it, can call it A.xls. The other has a bunch of fields set up almost like a sheet of paper that would be filled out, which is 2 pages long, but repeating for a couple hundred pages, which can be called B.xls. Is there a way to create a macro that will take the account number from A.xls, put it into Extra, then pull the fields and put into the required fields in B.xls for all the repeating pages. So acct 1 from A.xls put into Extra, pulls fields to put in B.xls, goes down two pages for the next acct have the fields filled in?

RE: Data from one excel sheet to another



Hi,

Quote:

Is there a way to create a macro that will ....

Yes, there is a way, and more than one way.

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Data from one excel sheet to another

(OP)
Can you show me?

RE: Data from one excel sheet to another


Why did you not ask that question in the first place?

What code do you have so far?

Where do yo uneed help?

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Data from one excel sheet to another

(OP)
pretty much everything, i'm not a coder. I figured it would be something easy to make, but i'm starting to learn it's not

RE: Data from one excel sheet to another




If it were me, I'd code the entire thing in Excel VBA.  Excel is MUCH more powerful and versatile than Extra VB.

Either way you go, check out the CreateObject method.

Quote:

The other has a bunch of fields set up almost like a sheet of paper that would be filled out, which is 2 pages long, but repeating for a couple hundred pages, which can be called B.xls.
Excel does not have PAGES.  It has SHEETS.

please describe this workbook in greater detail.

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Data from one excel sheet to another

(OP)
sorry i mean if you where to do a print preview i would put dotting lines around the pages it would print, basically if you scroll down you would have multiple pages if you printed it.

RE: Data from one excel sheet to another




Print pages are irrelevant to this task.

Please answer the other question.

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Data from one excel sheet to another

(OP)
basically i have a list of data & account numbers on one file, i have another excel file where i need to put that data in certain rows/columns and it keeps scrolling down filling in the different data. almost like doing a mail merge i guess. or i can get the data from extra extreme instead of the first excel file but the accounts numbers are going to be on the first excel file

RE: Data from one excel sheet to another




so you want to loop thru the cells in what COLUMN A, on Sheet1, in A.xls?

PUT the value value WHERE in Extra?

GET the values in Extra from WHERE?

Then write the values you got in Extra into B.xls, Sheet1, WHERE?  How is the data mapped?

ALL THAT is what you have to describe in great detail.

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Data from one excel sheet to another

(OP)
ok, i can get this, will have to do it tomorrow. have to go to school. thx for your help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close