Data from one excel sheet to another

[ptw78]

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?

 

[SkipVought]

Hi,

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

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

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[ptw78]

Can you show me?

 

[SkipVought]

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

What code do you have so far?

Where do yo uneed help?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[ptw78]

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

 

[SkipVought]

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.

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,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[ptw78]

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.

 

[SkipVought]

Print pages are irrelevant to this task.

Please answer the other question.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[ptw78]

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

 

[SkipVought]

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,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[ptw78]

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