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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data from one excel sheet to another
- Thread starter ptw78
- Start date
SkipVought
Programmer
Hi,
Yes, there is a way, and more than one way.
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Don't let the Diatribe...talk you to death!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
Just traded in my old subtlety...for a NUANCE!
- Thread starter
- #3
SkipVought
Programmer
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!
- Thread starter
- #5
SkipVought
Programmer
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.
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!
- Thread starter
- #7
SkipVought
Programmer
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!
- Thread starter
- #9
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
Programmer
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!
- Thread starter
- #11
- Status
Similar threads
- Locked
- Question