Excel, Data Generation from contents

E

ezykiwi

Hi all, Just wondering if someone can help me.

I have Sheet A with 150 items in Col A and B...

I then have another sheet... Sheet B... which has about 20 rows o
information...some of which grabs information the contents of A1 and B
from Sheet B.... into formulas.

That works fine. However I dont have to have to enter the 150 A1 and B
items manuelly... and then have to save them as text files eac
time....

Basically If i could have it somehow read the values from Sheet A an
put them into Sheet B... one by one.. it would then put the 20 row
into a database or a main sheet... so that in the end I would have th
3000 listings in a file... in the layout of Sheet B

Any Ideas
 

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

Top