I am a long way from an excel guru. I help a customer with their year end tax forms. This year they had to do 43 1099-S forms. They use Quickbooks Pro. QB will process the 1099-misc forms but not the 1099-S forms. What I do is export the QB data needed to Excel and then get it set up in a database. I also have another Excel form that when the QB data is entered into it will print on the pre-printed IRS tax forms. In the past I would copy and paste or just type the items into the form that will print on to the pre-printed IRS tax forms. Quite tedious and time consuming.
What I would like is a macro to go through the database and copy the data to the Excel printing form. Each 1099-S form is three to the sheet. The data from the database will have to be put into certain cells on the Excel printing form. The items in the database will be Name, Address, City, State, Zip, SS#, and amount paid. The name will go in one cell, the address will go into another cell, the city, state, zip will go into another cell, the SS# into another cell and the amount paid into the last cell. These cell that will receive the data are not in the same row or column. The name, address, city,state,zip will be in the same column in three consecutive rows but the other two are elsewhere on the form.
If I had something to start with, then I could probably edit it to make it work for me. Does anyone have an idea of some code that I could start with?
Thanks in advance,
Harold
What I would like is a macro to go through the database and copy the data to the Excel printing form. Each 1099-S form is three to the sheet. The data from the database will have to be put into certain cells on the Excel printing form. The items in the database will be Name, Address, City, State, Zip, SS#, and amount paid. The name will go in one cell, the address will go into another cell, the city, state, zip will go into another cell, the SS# into another cell and the amount paid into the last cell. These cell that will receive the data are not in the same row or column. The name, address, city,state,zip will be in the same column in three consecutive rows but the other two are elsewhere on the form.
If I had something to start with, then I could probably edit it to make it work for me. Does anyone have an idea of some code that I could start with?
Thanks in advance,
Harold