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,
Yes, there is a way, and more than one way.
Skip,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: Data from one excel sheet to another
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,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: Data from one excel sheet to another
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.
Excel does not have PAGES. It has SHEETS.
please describe this workbook in greater detail.
Skip,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: Data from one excel sheet to another
RE: Data from one excel sheet to another
Print pages are irrelevant to this task.
Please answer the other question.
Skip,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: Data from one excel sheet to another
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,
Don't let the Diatribe...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Just traded in my old subtlety...
talk you to death!
for a NUANCE!
RE: Data from one excel sheet to another