okay, i was told that the links that i give you are not the "secret" link that is so guarded. i came across this on another board and thought maybe someone could decipher it. i am not very computer literate. so, good luck. (PRD's are the numbers in a kolhs item url that designates the item. it is like an item number.)Instructions on how to make clickable links using sequential PRDs
Prerequisites: Must have Excel installed on your computer Must be able to download and install 3rd party application (freeware) Must give me first dibs on any NFL or MLB stuff
Office 2007 users, see alternate instructions for step 9
Download ASAP Utilities HERE [asap-utilities.com]
.5 Install ASAP Utilities 1. Download and open the Excel file 2. In cell B1, change the PRD to the number you want to start with. 3. Highlight cells B1 through B100. 4. Click Edit --> Fill --> Series; Step Value = 1, then hit OK 5. Column D should automatically update with the PRD string you just entered. 6. Right-click column D (the D in the header row), choose Copy 7. Right-click column E, choose Paste Special, choose Values and number Formats, then hit OK. 8. Highlight column E if it isn't already. 9. From the file menu, click ASAP Utilities --> 13. Web --> 3. Activate hyperlinks (create from cell values) --> Font layout (keep original) --> Hyperlink type (regular hyperlink cell-option), then hit OK. 10. The ASAP Utilities bar should show on the screen for a few seconds. When it's done, the URLs in column E should be clickable.
Office 2007 Users - alternate step 9 Click ASAP Utilities tab, then Web dropdown, then 3. Activate hyperlinks (continue as above)
Tip: Open SD in your NON-default browser (IE for moi)
When you click the links in Excel column D, it will open your default browser. When doing 100 in a row, and having 100 tabs open, it's easier to just close FireFox, rather than close 100 tabs. Don't close the tabs as you go, just close the whole window when you're done. It will save lots of time
Use Alt-tab to go back and forth between Excel and FF. I could do those searches fast because all I had to deal with were 2 keys (alt, tab) and 1 mouse button. Once you get the hang of it, it's a swift breeze
posted: Jan. 23, 2010 @ 4:30p
so it's find your own deals now? how are you going to catch up to Butcherboy like this?
Disclaimer: By providing links to other sites, FatWallet.com does not guarantee, approve or endorse the information or products available at these sites, nor does a link indicate any association with or endorsement by the linked site to FatWallet.com.
Members of our community may attach files to a post in accordance with the User Agreement. FatWallet is not responsible for the content, accuracy, completeness or validity of any information contained in any attached file. Files have *not* been scanned for viruses. Be especially wary of Excel files which may contain malicious content.
Earn Cash Back while you shop - just 3 simple steps.
1. Sign Up so we know who to pay! (It's FREE.)
2. Shop through FatWallet for deals from your favorite stores. Your online purchases earn Cash Back that builds in your FatWallet account.
3. Get Paid by requesting a payment via check or PayPal.
FatWallet coupons help you save more when shopping online. Use our Coupons Search to browse coupons and offers from thousands of stores, gathered into one convenient location.
As part of our FatWallet Community, you can share deals with almost a million shoppers in our forums. Forum content is generated by consumers for consumers. Share deals, money-saving tips, and more. It's FREE, fun, and addicting.
Our customer experience team is here around the clock - real people ready to assist.