Tech Levels in Excell Spreadsheet format...

[raynor]

quote:

---

Originally posted by WhiteHojo:
ps - Taterbill - nice work... one question I have is how do I link other columns to each row when using the your sort buttons? I added some info to column D but when the sort buttons are used, the new Column D info did not stay adjacent to its correct unit description.

---

I hope Taterbill won't mind if I go ahead and answer this question. Thanks to both WhiteHojo and Taterbill for this excellent job.

1. On the View Menu, go down to ToolBars and put a check next to the Visual Basic toolbar.

2. On the Visual Basic Toolbar, you should see three icons in the middle. The third from the left says 'Design Mode'. Click on this one. Excel should display a small window with an identical icon in the middle of your spreadsheet.

3. Right click on one of the three sort buttons and select 'View Code' from the menu.

You should see the code for the three buttons. Look for lines that look like this in all three of them:

Range("A2:C771").Select

4. Change the C to a D so that it applies the Select operation to columns A through D instead of just A through C.

5. (Close the Visual Basic Window and click the Design Mode icon in the middle of your screen to go back to normal view)