# ebay

1. ### Power Query - split out lines of data in a single cell

Hi, I have the following data in excel and am looking for a way to split it out into seperate lines - I was thinking Power Query could be the answer but not sure on the steps I could take. It is a one off data clean so I am also up for doing it in Excel via formula but again not certain on the...
2. ### Formula works on paper, but not in spreadsheet. Error = a specific expression is added to desired result.

Hello, l am using LibreOffice Calc but l'm hoping it won't affect matters. KEY TO EXPRESSIONS: \$AG\$3 = PayPal fee percentage \$AG\$4 = PayPal fixed fee per transaction (e.g. £0.30 per transaction) \$AG\$6 = eBay Fee Cap \$AG\$7 = Alternative Payment Gateway fee percentage \$AG\$8 = Alternative...
3. ### Formula for calculating eBay selling price

Hi folks, I'm not sure if this has been posted before or if there is a guide on how to do this on this forum, so apologies if there is. I want a formula which I can use to work out my selling price on eBay, assuming I want to make a 15% profit of the selling price, and the following are my...
4. ### Ebay vba url issue

I have a vba code that extracts ebay product details the code works fine if i am using a direct url in the code Original Code for search, but only searches 1 item .Navigate2 "https://www.ebay.co.uk/sch/i.html?_from=R40&_trksid=m570.l1313&_nkw=jackets&_sacat=0" This variation of the...
5. ### March Conundrum Power Query Problem and the Correct Path to Take !!!!!

Hi Guys & Girls Here we go head scratcher of the month ? I will try my best to explain without boring you to death. I have three connection files in Power Query that I know what I want to do but not sure which path to go down. So let me explain the table names and what they do:- 1...
6. ### Select Multiple Items on multiple choice list-box depending on a cell value.

Hi Guys, Hope you are well I hope you would be able to help me. Is there a way for multiple selection listbox to be able to select the items in that listbox automatically, depending on a cell value when the button is pressed ? For example: I have a multiple choice listbox with eBay...
7. ### Complex Multi Tier Lookup in PQ to return Fee

HI Guys I have an experimental sheet with a shared link HERE. My quest is i have a file from eBay with my listings also I have a file from my supplier. I have merged two tables so I have my selling price on eBay & my supplier'ss price. I am trying to build a sheet that works out all the fees...
8. ### Solver Type Formula or Chicken Egg Query

OK, guys, I have a headache trying to work this out and need some help. I have a product that costs me £100 looking at the table to the right I want to make a profit that fits the table. But the profit is it to include eBay FVF & PayPal Fee. So we are looking at a Chicken & Egg scenario. I...
9. ### eBay + Paypal Fees formula

Hi guys, Having a bit of a brain fart today and cannot get my head around this.. I want to be able input a COST (what it costs me) into lets say A2 I then want to be given a PRICE of what I should sell it for.. Fee's that are incurred are: 9% eBay Fee + 20% on top of that for VAT (so 10.8%...
10. ### Need Macro to extract Amazon data and Photos, Thanks!

Hello everyone, I have an Amazon store with 2000+ products but I need a Macro to extract data from Amazon URLs of my products, particularly the "Product Bullet Points/Features" section and "Product Description" section. Then the next I need is to download the 1000x1000 pixel or greater full...
11. ### Calculate eBay BIN price

Is possible count by formulas eBay Buy It Now price ? My cost price is £10 I want 40% = £14 (£4 profit) I need add ebay Fees + Postage + PayPal fees so I need selling price £17.90 Where is PayPal 3.4% + 20p Ebay 40p listing Ebay 10% Fee Postage £0.9 I need formula where I set my cost...
12. ### Macro that grabs links from Ebay

Hello, I have 2 macros, one that grabs the links for items on this page (Motorcycles in Model:CB | eBay), called ListUrl Sub ListURLs() Dim Anchors As Object Dim HTMLdoc As Object Dim Rng As Range Dim row As Long Dim URL As Variant Dim Wks As Worksheet URL =...
13. ### Duplicates

I sell a lot of motorcycle items on eBay, and eBay's duplicate finder is slightly more advanced than Excels so I am having a little trouble. I work with a large list of bikes and sometime the strings of information get muddled into different orders. e.g. CBR125 Air filter Air filter CBR125...
14. ### Amazon eBay Pricing Formula

Hi everyone, I sell furniture on Amazon and need to be able to calculate the end ‘Sell price’ taking into account various cost factors which can change (in some instances) E.g A chair’s cost price from supplier is £10 (including vat) I want the formula to calculate a minimum profit of 25%...
15. ### Strange Question: I would like to transfer my photo listings to excel then transfer to ebay

Thanks for reading: This is my first post. I'm an ebay powerseller currently, and I have a private photo collection of over 10,000 unique photographs in several digital folders. (yes they are all digital). They also have the titles already there as the file name for each photograph. 1) I...
16. ### Ebay question: Calculating Asking Price Based on Cost of Goods Sold

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...