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?
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.