Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Hyperlink w/Sort by clicking a cell
Name: Samir Date: September 22, 2004 at 08:20:54 Pacific OS: WIN XP CPU/Ram: P4/1000
Comment:
When I click on a Cell (eg. 10, "A" in Sheet 1) in MS Excel. I am trying to Hyperlink to another worksheet (eg. Sheet 2) but also sort this information found on Sheet 2 by eg. "specific date" entered in spreadsheet and display it on the screen. Note: The Date information is available in Sheet 2 and can be manually sorted. What im looking to do is create a macro that can Jump to this sorted information by clicking on a "CELL" instead of manually clicking the worksheet and sorting this information.
Summary: Here are a couple of things I found out. 1) When you click a cell and hold, if you move the cursor above the cell while holding the button, you can get just the cell/cells you want. 2) If you click re...
Summary: Found this in Access 2000 help: Bring data from other sources into a spreadsheet. One easy way to bring data from other sources into a spreadsheet is to copy data from another source (such as a text f...
Summary: For your second query use a Pivot Table as it is really good for that. For your first query I would do as follows: "Trailer info in rows 2 and 3 More info in row 4 More trailer info in rows 5 and 6 An...
