Edit

Forums
Black Friday 2009

Excel Spreadsheet - BF Filtered Ads - BF2008 Buying Guide Archived From: Black Friday 2009

  • tweet this
  • Post to Facebook
  • Text Only
  • Search this Topic »
  • Classic
  • Go to Page :
  • 14 5 6789
alert mods    

socalgirl1 said:don't quite understand how to sort the list once i download it? can't click on data, sort. it's not clickable. it's a protected doc, so if i try to unprotect its asking for a password. can anyone help with this? i just want to be able to sort by item/category.
thanks,
gayle

Same problem here. It does look like it's protected now. I downloaded a copy a week ago and it was workable, but this updated file is locked. Still useful though, thanks again OP.

eta: Just copy and paste the worksheet onto a blank worksheet and you can sort and filter from there.


alert mods    

.


alert mods    

FrugalFreak said:can anyone tell me why the spreadsheet is protected thus making it impossible to arrange columns where I can view them easier? I don't do MIR and want to move the price in that column so I don't have to keep going back and forth with horizontal scroll bar.

any way to do that OP? or is the customization locked?

anyone have the first version released before it got locked?

Create a new worksheet then copy and paste all from the original to the blank sheet. Your new worksheet will be unlocked.


alert mods    

Amazing.....More laptops please??


alert mods    

is there another way to obtain the spreadsheet? both links are blocked for me at work. if someone could pm and then email to me that'd be great.


alert mods    

Great spreadsheet, but why no WalMart?

You'd figure the #1 retailer in the country would be a priority.


alert mods    

Is there a mobile friendly link for the download?


alert mods    

All,
Here the sheet that allows you to add or remove columns. Please note if you edit this sheet and then want to add the updates (new stores) that OP provides, you will have to do it manually.

Instructions for importing/copy futures updates

  1. Save the updated excel in a different name (so as not to overwrite your changes)
  2. Open BF_Buying_Gude_2008_EditEnabled.xls
  3. Open BF_Buying_Guide_2008.xls (this has the updates that you are interested in)
  4. Select the rows in BF_Buying_Guide_2008.xls that you are interested in
  5. Right click and select "Copy" from the menu
  6. Now goto BF_Buying_Guide_2008_EditEnabled.xls
  7. Scroll down to the last row in this sheet, and select the first cell in the next row (this row should be empty)
  8. Right click and select "Paste" from the menu

Thats it you are done, be sure to repeat the steps above for additional updates that OP keeps providing.

And don't forget to rep the OP.

Excel File


alert mods    

WalMart has been added to the spreadsheet.


alert mods    

Microsoft has free viewers for all their Office components, including this one for Excel. You can also get an oldie but goodie Office knockoff from Corel, which provides Wordperfect and Quattro Pro (Excel-like) for under $10 here


alert mods    

Thanks akelnat! This excel worksheet really took the pain out of Black Friday/Christmas shopping last year. I like to fill in color for items interested. Am I doing something wrong....I cannot get it to allow me to do it?? Thanks again.


alert mods    

Thank you so much!


alert mods    

+1 for great work. thanks.

For those that want to read the XLS spreadsheet:
Highly recommend Open Office 3.0.... its FREE !!

a great free alternative to Microsoft Office 2007.


alert mods    

OpenOffice.org like microsoft office only free.


alert mods    

great thanks


alert mods    

disoriented said:]

Create a new worksheet then copy and paste all from the original to the blank sheet. Your new worksheet will be unlocked.

That's what I did... I wonder why he protected it. Kind of silly. Thanks for your hard work though. Sent a donation your way.


alert mods    

Excellent job!!!


alert mods    

Thank you!


alert mods    

awesome work....
Lets support fatwallet at www.letspoll.com

Love you guys


alert mods    

11/23 - Mega Update - Added Bass Pro, Blockbuster, Burlington Coat, Dell, GameStop, hhgregg, Home Depot, KB Toys, JC Penney and Office Depot

Another large update is planned for later this afternoon.


 Close

Sign Me In
Nickname: 
Password: 
Remember My Login Information:

Forget your login information?

Not Already A Member?
Sign Up Now!



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.


While FatWallet makes every effort to post correct information, offers are subject to change without notice.
Some exclusions may apply based upon merchant policies.
© 1999-2009