Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 80761 times)

Offline Centurion

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2012
  • Posts: 1304
  • Total likes: 2
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York / Jerusalem
  • Programs: spg plat,avis pres ,hertz plat ,AAexcutime, delta plat,hilton gold, united
Re: Excel Problem
« Reply #210 on: August 18, 2014, 05:32:41 PM »
Did you put a 1 or a 3
Did you put asin or sku?
Try ro pasre in note pad first then back in excel
If it doesn't show a number you will get this error
you can only make a first impression ONCE

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 118
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #211 on: August 18, 2014, 05:37:00 PM »
Did you put a 1 or a 3
Did you put asin or sku?
Try ro pasre in note pad first then back in excel
If it doesn't show a number you will get this error

asin and sku

never had a problem before

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 6734
  • Total likes: 1463
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #212 on: August 18, 2014, 05:39:31 PM »
trying to upload template to amazon keeps on giving me this error

Error A EAN/UPC value in scientific notation is not allowed: [Product ID Type = "ean"], [Product ID =
as I thought it is not a "number" but text with numeric characters. Format the cells as text in excel. You may need to fake edit each cell if you are doing it after the number was entered. This means to select the cell, place the cursor in the editing area, and press enter. If you are pasting into the cells you may need to right click and paste values instead of using control v. That is the paste icon with the 123 on it.
An alternative method is to type a ' at the beginning of each number.
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline dave

  • Dansdeals Gold Elite
  • ***
  • Join Date: Nov 2011
  • Posts: 118
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #213 on: August 18, 2014, 05:51:32 PM »
thanks so much it worked


Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 6734
  • Total likes: 1463
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #214 on: August 18, 2014, 05:54:51 PM »
I go through this all the time with utility account numbers
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline A3

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Nov 2009
  • Posts: 3271
  • Total likes: 32
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #215 on: September 18, 2014, 12:20:15 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys

Offline AnonymousUser

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 3006
  • Total likes: 4
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #216 on: September 18, 2014, 03:00:02 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys
You can write a macro to get input from the barcode scanner, lookup the row with that item, and decrease the quantity in stock by 1.

Offline Fan of Dan

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2011
  • Posts: 3043
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #217 on: September 18, 2014, 03:30:54 PM »
Don't want this to come across as if I think excel is simple or easy to learn. Where can I learn basic excel either online or perhaps a good book etc. I use it a bit for simple stuff and I think know I am not taking advantage of what it has to offer properly.

Thank you

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7115
  • Total likes: 253
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #218 on: September 18, 2014, 03:34:04 PM »
Hi helpful peoples.
I want to get a simple barcode reader to keep track of inventory, the only inventory I need to keep track of at the moment is finished goods, I need a few columns, such as Item, UPC, New inventory, shipped, on shelf (total)
I would want to scan a barcode and have excel do the rest.
Any ideas where to start?

Also I would want an option for the scanner to lower the inventory when the items ship out.

How complicated does this sound?

Thanks guys
you really need a cheap POS/inventory system. Using excel sounds complicated when there is an abundance of other options.. IMHO

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9267
  • Total likes: 285
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #219 on: September 18, 2014, 03:38:21 PM »
you really need a cheap POS/inventory system. Using excel sounds complicated when there is an abundance of other options.. IMHO
+1
Workflowy. You won't know what you're missing until you try it.

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2152
  • Total likes: 22
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #220 on: September 18, 2014, 06:05:16 PM »
Don't want this to come across as if I think excel is simple or easy to learn. Where can I learn basic excel either online or perhaps a good book etc. I use it a bit for simple stuff and I think know I am not taking advantage of what it has to offer properly.

Thank you
http://excelexposure.com/lesson-guide/
For tech help feel free to Telegram me @DanTechSupp

Offline Fan of Dan

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2011
  • Posts: 3043
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #221 on: September 18, 2014, 07:20:17 PM »

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7115
  • Total likes: 253
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #222 on: November 12, 2014, 02:49:23 PM »
I have a table to unsorted data. Is there a way to sort it alphabetically, then change some values, and then revert it back to its unsorted state?

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3706
  • Total likes: 11
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #223 on: November 12, 2014, 02:52:32 PM »
I have a table to unsorted data. Is there a way to sort it alphabetically, then change some values, and then revert it back to its unsorted state?
Make a column and label it 1,2,3 etc.
when you want to revert back to unsorted state sort by that new 1 2 3 column.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9267
  • Total likes: 285
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #224 on: November 12, 2014, 03:02:07 PM »
Make a column and label it 1,2,3 etc.
when you want to revert back to unsorted state sort by that new 1 2 3 column.
To get the row #s automatically, put this in cell A1 (or any column), and then copy down.
Code: [Select]
=ROW(A1)Then, select the column, do copy, and paste special - values.
Workflowy. You won't know what you're missing until you try it.