entering data from one worksheet to another

N

nidabland

I have the following information on one worksheet that I need to transfer to
a new worksheet in another format.
Refer Acct Amt
80312 43700 -36,500.00
80312 43705 39,518.76
80312 12300 -44,704.76
80312 11606 5,186.00

I need it to look like:
Refer
Acct. Amt.
with the acct. #'s going down column A, starting at row 4, Refer #'s across
Row 3, starting in column D and the amt automatically filled in at D4. I
have a lot of data to enter this way and I'm hoping someone can tell me how
to populate the second sheet without having to enter everything again. I
tried SUMPRODUCT, but it didn't work. thanks ahead of time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linked data 0
using data from one worksheet in another worksheet 1
index/if function 0
How to copy files from Onedrive account to another 2
Formula to fill in fields when cell is blank 2
Merging/Combining workbook data 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Problem with SET & REF function 0

Top