Thread: Workbook to workbook data entry needed.

I have been usually fairly successful in doing what I wanted in Excel, but I have hit a roadbolck.

I cannot get information in one workbook to display in another workbook. I have always been able to do it in the same workbook, but this time I need separate work books.

Looking at the examples, one is a spreadsheet, the other is a book of invoices.

My preference would be to enter the information in the spreadsheet, it would then populate the invoice with the information.

I suppose in reality it would also need to create a new woorkbook, rather than a new sheet.

I can then send the invoice to the printer, give my customer his/her copy, file my copy, and the transaction would be complete.

I want to totally get around having to enter this information twice, once on the invoice and then later in the speadsheet, as I have been doing.

Any help would be appreciated greatly, . . . I'm pulling my hair out, and at 65, there really ain't much left to pull out.

May God bless,
Dwight

royUK, . . . Thanks for the prompt response, and you are 100% correct in your answer.

I subscribe to the double edged old saying: Necessity is the mother of invention, but Laziness is surely invention's father. I already have an invoice form I have been using for the last couple of years, and just thought that if I could link the info to a simple spreadsheet, . . . it would be easier and quicker than going to the trouble of going through the process of inventing the database and hammering out all the bugs in it.

Besides, . . . that was something I had never attempted (linking two workbooks like that) and I had in the back of my mind that it should be a simple process. I did a church budget for a friend of mine using all sorts of linked pages, cells, rows, and columns, . . . BUT, . . . it was all contained in the same workbook, so it was a piece of cake.

This would have been a "NEW" thing for me, . . . and I just got frustrated when I could not find the proper function or command to make it work.

Thanks for the suggestion, . . . I'll probably just whack it out in Access, . . . have to fight some logistical problems, . . . but nothing I cannot manage.

May God bless,
Dwight

It would be so much easier for me if I coudl make it out of leather, emboss it, dye it, finish it, and put some brass hardware on it. THAT I can do anytime I want to.

Thanks much for the advice royUK, . . . I'll just try to muddle through it.

May God bless,
Dwight