Excel form help

Question

barney789 9 Newbie Poster

13 Years Ago

I have a excel spreadsheet that contains the following information: part name, part number, calibration, rev. level and other information. I also have a form that I have to fill out every month using the information from the above mentioned spreadsheet. Is there a way to input the spreadsheet information to the form? I have to hand write this form every month and I'm looking for a way to keep from doing it. I need to be able to print for each month of the year. (I'm currently using excel 2003.)

Any help with this would be much appreciated.

microsoft-office office-suite

3 Contributors
5 Replies
258 Views
5 Days Discussion Span
Latest Post 13 Years Ago Latest Post by barney789

BBAD 58 Junior Poster

13 Years Ago

Are you wanting to do like .

Sheet one has the total's and then sheet to can have =sheet one Cell xyz.

It maybe easier if I see the sheet or try and understand more of what you need.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

qwiktalk 0 Newbie Poster · Answer 1 · 2011-06-05T23:04:01+00:00

Seems like you need a simple VBA script. I'd suggest checking out a tutorial like this one: http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_Excel/629.html

Or, if you'd like to talk through it with an expert, we just launched http://qwiktalk.com

barney789 9 Newbie Poster · Answer 2 · 2011-06-07T23:59:33+00:00

I hope this helps.
Sorry for being so late with this

qwiktalk 0 Newbie Poster · Answer 3 · 2011-06-08T00:35:39+00:00

I guess I don't understand exactly what you want to do? What is your input for the form? eg, Do you want to enter a part number and then want the rest of the form to fill out the remaining fields? If so, you can do that with the VLOOKUP function.

barney789 9 Newbie Poster · Answer 4 · 2011-06-09T04:47:00+00:00

There a few things I need this do. 1) sort according to calibration due month 2) put the part number, part name, rev level, location, and Ak number in the form 3) print the form for the first part number on the sorted list and procede until all the part numbers have been printed on the form. (I know this is more of a database function but I don't have it ready yet. I was hoping I could get a work around the database for now) If the sorted list has 13 part numbers that has a calibration due for that month then I should have 13 sheets of paper with the above mentioned info on the form. I hope this explains more of what I'm trying to do.

Thanks again for looking at this issue.