↑
  • Home
  • About
  • Coupon Database
  • Price Comparison Tool

How to Shop For Free with Kathy Spencer

The Coupon Database Extreme Couponing, freebies, coupon, database

  • Deals
    • Find a Deal:

      • Black Friday
      • Glitch
      • Class Action Lawsuits
      • Recalls
      • Victoria’s Secret Deals
      • Baby Deals
      • Pet Deals
      • Online Deals
  • Stores
    • Grocery Stores:

      • Stop & Shop
      • Shop Rite
      • Shaw’s
      • Market Basket
      • Big Y
    • Retail Stores:

      • Amazon
      • Ocean State
      • Kmart / Sears
      • Target
      • Victoria’s Secret
      • Walmart
    • Drug Stores:

      • CVS
      • Rite Aid
      • Walgreen’s
    • Dollar Stores:

      • Dollar General
      • Dollar Tree
      • Family Dollar
  • Freebies
    • Find a freebie:

      • 100% FREE
      • Birthday
      • Black Friday Freebie
      • Money Makers
      • Samples
    • The Latest:

      FREE Energizer Batteries! 4/18-4/24

      Possible FREE Gain Dryer Sheets Digital Glitch! 4/18-4/24

      2 FREE Fage Sour Creams at Stop & Shop- No coupons needed!

      FREEE + Moneymaker Babybel at Stop & Shop- No coupons needed!

  • Coupons
    • Find a coupon:

      • Insert Schedule
      • Coupons.com
      • Savings.com
      • RedPlum
      • Smartsource
      • Retail Coupons
      • Restaurants
      • Couponing 101
      • Database
    • Coupon Database

    • The Latest:

      Sunday Coupon Preview 04/25 ~ 3 Inserts Expected!

      Shaw’s Ad Preview 04/23 – 04/29

      Dollar General Ad Preview 04/25 – 05/01

  • Forums
  • Ad Scans
    • The Latest:

      Sunday Coupon Preview 04/25 ~ 3 Inserts Expected!

      Shaw’s Ad Preview 04/23 – 04/29

      Dollar General Ad Preview 04/25 – 05/01

      Sunday Coupon Preview for 04/18 ~ 3 Inserts Expected!

      Save Insert Preview for 04/25

  • recipes
    • The Latest:

      Jack Frost Cocktail Recipe 21+

      Crockpot Chicken Crack Taco Recipe

      The Recipe Shop: New on ShopRite Site!

      Pan Seared Broccoli with Garlic is the PERFECT side dish!

      Classic Green Bean Casserole with a twist!

How to Shop for Free may earn affiliate commission from our posts. Read our full disclosure policy here,

How to get Stop & Shop LTC into an Excel spreadsheet without manually typing them

September 22, 2016 by mlambrose Leave a Comment

Some people say you can do ANYTHING in Excel except cook. Well maybe I’m the only one who says that but for those looking for a list of their Stop & Shop LTC that will allow you to print, delete, or cross off your items  theres a way to do that. Not an EASY way but for those with some comfort level in excel quick once mastered!

First open this excel workbook ltc database.xlsx

You will see a security warning that says  macros have been disabled.   Click the button that says “Options”, then “enable this content” then “ok”

HTSFF

Still with me? Great!

Now log into your stop & shop account and click on “Coupons”.  Load any coupons to your card that haven’t been already.  Then click on “View Loaded Coupons”.

Click on your mouse just before the first coupon, and keeping the button down, drag all the way to the bottom so ALL of your coupons are highlighted in blue.

HTSFF

 

 

 

While all of the coupons are highlighted, click on any coupon and select “copy”. (not copy image, just copy)

 

Go back to that excel workbook you already opened  and on sheet 1, right click. Select “paste special” and select the option to paste as text.

HTSFF

 

Your worksheet will look similar to this:

HTSFF

Click  on the tab titled “View” at the top of the page,  then click the arrow under “Macros” , then “View Macros”.

You will see a macro called “reformat_LTC”.  Click the button that says “Run”

Untitled

You’ll watch excel go through all the formatting to get to THIS:

 

Untitled

Took a bit to get there, but you now have a list of all of your LTC in a list and you can delete, cross out mark the date used or however you choose to keep track of your LTC list.

This is the workbook completed as of all of the LTC I have on 9/22/16, your exact list may not be the same. ltc database.xlsx

 

Enjoy!

 

Filed Under: Articles, Evergreen, HTSFF Site Updates

About mlambrose

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

never miss a deal

subscribe to thenewsletter

Featured Articles

Home Made Mosquito Repellent

Are you getting our Daily Newsletter?

How Stop & Shop Stacking and Overages Happen

search

archives

categories

Legal  Privacy Policy  Press
Copyright ©2021, How to Shop For Free with Kathy Spencer. All Rights Reserved.
Design by Pixel Me Designs