Log in

View Full Version : Excel help


thetachi464
Mar 26, 2005, 08:19 PM
I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then go from there. I am pretty good with excel but I am not sure how this can be done or if it can be. If it can please someone help this is not a big deal but it would be nice to know how to do this.

ScottGem
Mar 27, 2005, 06:16 AM
Excel does support forms, so you could create a form and/or some coding to prompt you for the values to insert into the specified cells. What you should be looking at is getting into VBA (Visual Basic for Applications) which can automate Excel to a large extent.