pen

Hi I have always used Vlookup but now I need a little bit more. I have a spreadsheet where 90% of the data and columns will remain the same but the on hand qty will always change. I created a small sample sheet where I have column A two different stores that care the same product number and on...

Here's an example: <tbody> John apple John fridge John heart John pear John car Steven soap Steven display Steven pen Steven orange Steven bee </tbody> I would like it to look like, <tbody> John apple fridge heart pear Car Steven soap display pen orange bee...

<tbody> Site Product UOM Product ID ID Value Sale Counter Results A Pen 9 26525802 77587241 1 2 1 A Pencil 9 <tbody> 32266576 </tbody> <tbody> 77586563 </tbody> 2 3 2 A Pen 9 47163111 77595902 3 4 A Sharpie 9 49726635 77592873 1 8 3 B Pen 9 26525802 77583416 8 9 1 B...

Hi guys, I have written some code that looks at a database and filters on a user number and then pastes the data onto worksheets (named as the user numbers) - all of this part is working fine - I have created a very simple array to store the user numbers. I have some additional formatting for...

Hi All, My Records Descript Qty Invoice Number Pen Red 525 SAM-041918-1 Can Led 328 SAM-041918-2 Pen Red 422 SAM-041918-2 Map Big 630 SAM-041918-3 Pen Red 245 SAM-041918-4 Map Big 600 SAM-041918-4 for 6 (six) records above I already created 4 (four) invoices Invoice #: SAM-041918-1 (1 record)...

Hi I would like get weighted average margin by category. I want to use the sales to weight the margins. Any help? thanking in advance <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Invoice Number Product Sales Margin 2 22 Pen 110 15% 3 28 Books 200 11% 4 26...

I have one combo box and a buttom I have this table in excel date name goods name Qty 21-1-2018 David Pen 12 22-1-2018 Peter pencil 14 10-2-2018 David paper...

I've been building a database for my step daughters new business and have found this site a massive help when writing macros as i have very little knowledge when it comes to visual basic. I have created a constent form that clients need to fill in to record all their details etc into the...

Anyone know the code to select the a pen of specific color in the draw tool ribbon? OR point me in the direction online? I can't seem to find anything for this online. I'd like to have a button press select the pen. Thanks in advance!

Columns A, B and C have search formula to find in a table the element in B1. column D is a simple add/subtract formula. Problem when the row is empty "", the formula got Error. Is there a way to use this formula and skip the empty row and preserve the last balance? Thanks in advance. <tbody>...