Mommysavers › Forums › Deals & Shopping › Couponing › Coupon/shopping list in Excel
New Posts  All Forums:Forum Nav:

Coupon/shopping list in Excel

post #1 of 16
Thread Starter 
Does anyone make a shopping list in excel with thier coupons, that keeps a running total. So they know exactaly what thier check out total should be.
If so could someone share how to set it up. Cause I tried the other day twice and I just couldn't get it to work out for some reason. Not sure what I am doing wrong cause I can run Quarterly staffing reports and other things in excel wiht no problem but just could not seem to get this one to run.

Thank you in advance,
Kara
South Jersey
post #2 of 16
Do you just want to list the coupons in one column and what the total of the coupons are in another column?

I am not sure if I understand completly, what you are asking.
post #3 of 16
I'm going to attempt to attach the base model of my shopping list excel sheet.

On my excel file I have copied the sheet into multiple tabs, made each tab it's own store, and then slightly tweaked the list to suit each stores needs. Target for example has a place for target coupons in addition to the place for manufacturers coupons (basically just copied those columns over again and renamed it). WalMart doesn't double coupons, so I've removed that column from that worksheet. You get the idea. I also have mine with pretty fonts and some clip art lol

But if you like how I've set mine up it could give you a jumping off point anyway.
post #4 of 16
Quote:
Originally Posted by Karen1985 View Post

I'm going to attempt to attach the base model of my shopping list excel sheet.

I think it should be in a zip folder that I think I got attached to this post....
post #5 of 16
Thread Starter 
I guess what I mean is like say you put dove body wash $ . . . then you have a coupon for $. . . . off you new total is then your next item . . . and minus that coupon but it still keeps the running total of your oop total.
post #6 of 16
Quote:
Originally Posted by strawberrywine97 View Post

I guess what I mean is like say you put dove body wash $ . . . then you have a coupon for $. . . . off you new total is then your next item . . . and minus that coupon but it still keeps the running total of your oop total.

Mine does that....just with a whole lot of extra information too haha You could delete like half the columns I have and end up with that.
post #7 of 16
Thread Starter 
Thank you Karen I got it to open and I see it now. Its is great thank you.
post #8 of 16
Quote:
Originally Posted by Karen1985 View Post

I think it should be in a zip folder that I think I got attached to this post....

I am really impressed! This is something I don't think I would even have the time for, but you've made it easy.
post #9 of 16
Wow I have been thinking of doing something like this but haven't had the time. Thanks for posting this though. I might get it to work lol.
post #10 of 16
Thread Starter 
Quote:
Originally Posted by Karen1985 View Post

Mine does that....just with a whole lot of extra information too haha You could delete like half the columns I have and end up with that.

Oh Karen. . . THANK YOU. I have been playing with this and its just what I was looking for. THANK YOU, THANK YOU, THANK YOU!
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Couponing
Mommysavers › Forums › Deals & Shopping › Couponing › Coupon/shopping list in Excel