|
I'm trying to make a Worksheet in Excel that pastes values from certain cells into successive rows of another worksheet, according to a Change event [1]. This is important because some people who are basically computer illiterate are going to be the primary users of the Workbook and I want it to be pretty easy for them to make order forms from a list of items sold by different vendors at different prices. I've made little progress so far. I made a small amount of headway yesterday on the 'copying into another worksheet' part by using the name manager to define a name that had the values I was interested in. For some frustrating reason, this did not work at all when I tried to make the name definition column absolute instead of fully absolute (e.g., one cell in the defined name would be $A1 instead of $A$1). In this case, the same (incorrect) cells were called by the name no matter where on the spreadsheet I called the change event. I've had no success on the 'into successive rows' part of the problem, and no idea how I might go about deletion. [1] Basically I have a list of item names, prices, and quantities. I want to copy the name and price into another worksheet if the quantity is changed to something greater than 0, and removed from the worksheet if the quantity is zero or less. smug forum asshole fucked around with this message at 20:57 on Sep 22, 2009 |
# ¿ Sep 22, 2009 20:55 |
|
|
# ¿ Apr 28, 2024 11:20 |