User Box entry Pasted into cells

**humboldtguy** · 08-03-2009, 10:53 PM

Hi, I think this should be easy, but i don't know how to do it, i have a hidden worksheet named "View & Print Invoice", and i want to have users click a button that says view/print invoice, and a user box would ask for an invoice number, the macro would then put the user's entry into cell "O12" of "View & Print Invoice, then create a copy of View & Print Invoice, rename it as the contents of cell "O12" in the new worksheet I have some code below, but don't know how to paste it all together....the top code ask's the user for a customer number then copies and pastes entire rows....don't need that, just the user's entry put into one cell....I got this code from these forums, and don't really understand vba that well yet, anyway thanks for the help guys

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**royUK** · 08-04-2009, 03:02 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I have created numerous invoice programs and never yet had to store invoices as a cmplete sheet. It's much more efficient to have one invoice form than can be populated using VLOOKUP based on the invoice number. It is necessary for the relevant data to be stored in a table on another sheet.

**humboldtguy** · 08-04-2009, 05:12 AM

Ok, I will post my workbook, there will not be a sheet for each invoice, the ability to open up an invoice into its own sheet at any time, all the data from the invoices are stored in an xml file, along with customer records and product records...so thats another question i have, can i export my xml data with a macro? Anyway, thanks for any help you can give me, much appreciatedEXCELHELPFORUM.xlsm

**humboldtguy** · 08-04-2009, 05:27 AM

some notes on the workbook, only the customers, invoices, inventory, and get map tabs will be visable...the others I am using as templates, Each worksheet has some instruction, so it should be easy to get the general idea.....so on each sheet, row 1 is blank, but the user forms copy into put onto row 1, row 2 copies the information back from the user form....i hope that makes sense...anyway, thanks again for the help, you guys on this forum have been just terrific