Small Scale Stock Sheet / Epos Style Spreadsheet

Jan 8, 2010


We run a fairly small start-up company and I would'nt mind knowing if it was possible to have some kind of stock control system on 'worksheet1'. On 'worksheet2' have some kind of 'Till Style' GUI interface where you can input the products the customer purchased. And then maybe of 'Worksheet3' have a printable recipet which you can hand to the customer.

Of course the idea would be for what-ever is purshased via the 'Till-Style' GUI on 'worksheet2' to alter the stock QTY on 'worksheet1'.

View 9 Replies


ADVERTISEMENT

Stock Order Sheet To Be Created From Stock Inventory

Jan 8, 2014

I have created a stock sheet on Sheet1, i have say 100 items and each item has a min and max stock order. Once the item hits a min low, the last cell (O) will display an order needs to be placed.

I was wondering if there way a way that on sheet2, it can calculate all the data on sheet1 and if there is stock that needs to be ordered, it will appear on sheet2?

This way i can just print sheet2 and send it to the supplier without having the entire 100 items displayed -if it does not need to be ordered?

View 7 Replies View Related

Stock Control Spreadsheet

Feb 2, 2009

I have an opening balance colum for the month(I5), then a colum for receival stock for each week in the month + total of stock received for the month(O5), also a colum for delivered stock for each week in the month+ a total deliverd for the month(U5). I wish to then calculate the closing balance in (V5)

Therefore the simple formula =(05-U5)+I5 with the product dispalyed in (V5)

opening balance 3 units(I5) receivals =0(O5) deliveries = 3(U5) closing balance should equal =0 (V5). However the product displayed in V5 is incorrect and shows 6
What am i doing wrong? what formula will give me the correct answer to this equasion?

View 3 Replies View Related

Insert Small Photos Into Excel Spreadsheet?

Oct 20, 2012

Looking for a way to insert small photos into a excel spreadsheet.Would it work with data validation or even a lookup table.The photos need to be inserted every 8th row.Is it best to name each photo?I`m not started yet as i not sure if this is even a possibility but if there are ways i will make an attempt...Maybe a VBA code could automatic insert them when a button is selected..they are 2 columns x 4 rows in size the photos

View 3 Replies View Related

IF Formula - Identify New Stock Items In A Spreadsheet?

Mar 27, 2009

I have two spread sheets from one of our suppliers, one was issued in 2008 and the other 2009. The newly issued sheet has about 400 extra items. How can I identify these new items of stock easily. I have attached both sheets for you to look at.

View 5 Replies View Related

Set Up Spreadsheet To Calculate Margin On Stock Positions

Nov 16, 2011

I am trying to set up a spreadsheet to calculate margin on stock positions.

There are 3 tiers, based on number of shares. My example:

400 shares in held in total.

1st 200 shs margin at 10%.

next 100 shs margin at 20%.

everything above 300 shs (ie 100) margin at 30%.

The 400 shs may be made up in any number of ways, (ie lots of smaller amounts) and i need a formula to give me the margin amount on each position, flexible enough for when positions are added / removed.

I've been looking at SUMPRODUCT but can only seem to make it work for the total, not each individual position.

View 9 Replies View Related

Setup A Basic Stock Control Spreadsheet

Feb 22, 2009

I've set-up a basic stock control spreadsheet. Part of this requires updating prices of products. My approach was to use 3 columns A,B & C. C would show the current unit price of a product. Where there is a change in price this would be entered in A which would then result in a new average unit price to be calculated automatically in C. When ever this change occurs i need the then 'old' price which was in C to be shown in B aswell.

I've tried using various averaging formulaes but i'm thinking they were probably to basic or just plain wrong

View 9 Replies View Related

Pivot Style - Modify 1st Style Under Light Category

Oct 26, 2012

Is there any way to modify the 1st style under the Light category? I like it because it's the most simple but it won't allow me to Modify or Duplicate. Is there a work around to duplicating/copying it? I've tried manually creating a new style but I can't get it to get the lines fills correctly.

View 2 Replies View Related

Cell Update With Real Time Stock Quotes For Particular Stock

Aug 7, 2012

What is the easiest way to have a cell update with real time stock quotes for a particular stock?

View 4 Replies View Related

Convert Time On Scale Of 100 To Scale Of 60?

Feb 1, 2013

How can we convert time on a scale of 100 to a scale of 60?

View 3 Replies View Related

Protect The Whole Sheet Except For A Small Area Where Data Can Be Entered

Jun 6, 2009

I need to protect the whole sheet except for a small area where data can be entered and if possible make it so that the work sheet can be sorted. I have attached an example sheet.

View 2 Replies View Related

Excel Sheet That Will Separate List Into Small Groups

Aug 24, 2013

I'm trying to make a excel template that will take a list of names, changes but generally around 100, and randomly separate them into 4 sets of 8 groups evenly.

This grouping would be repeated 4 times, but there are some conditions.

Firstly, the same person cannot be put into a group again with someone they have previously been grouped with.
Secondly, someone appearing in the first or last groups cannot appear in that group again.

I've been trying to do it via some complex cell formulas but they are quickly becoming overly complex and im not sure if it will actually work which has completely demotivated me. Ive not been looking at VBA but am now thinking its the right route. Ive been thinking of having a master list and then have an attribute of who people have been grouped with before during each of the groupings, and also what number group they were in and then checking against that or something, but im not sure if that is the most efficient solution.

I attached an example dataset : demo dataset.xlsx‎

View 2 Replies View Related

Get Totals From One Sheet In Spreadsheet To Show On Another Spreadsheet?

Apr 7, 2014

I have 2 sheets in my excel spreadsheet. One tracks data for a number of projects five different employees are working on. The other sheet is where I want to total up the number of minutes each employee has worked on their individual projects. I tried writing an IF statement like below but I am only getting the total in the first field even if the employee's name is not Employee 1....

[Code] .....

How I can write this so their totals show up in the correct row?

View 3 Replies View Related

To Copy And Paste Something On My Spreadsheet (sheet Titled Input Sheet)

Apr 3, 2007

Everything seemed to be working until i tried to copy and paste something on my spreadsheet (sheet titled Input Sheet). When I paste anything onto this sheet I see the Paste happen and then Excel just hangs (no errors?). I just left it for over 5 minutes and nothing happened (still hanging). I had to close it down using X

I have LOTS of different codes and different sheets in my spreadsheet. I was wondering if anyone knows how I can go about Pinpointing the problem. Chances are no one will be cutting and pasting but I would like to know why this is happening but have no idea how to go about investigating?

View 9 Replies View Related

Scale In X Axis

Apr 12, 2007

The scale on our chart in the X axis is mandating a numeric number. It is showing "39200" instead of 4/28/07. In any event, we would like to have 4/9/07 -- the last date we have data for and the last date that we have referenced on the X axis.

The chart is in the attached chart.xls and the data is in the attached chart.xls

View 9 Replies View Related

R1C1 Reference Style

Dec 30, 2006

I have tried to reset the cell reference style back to A1 from R1C1 (Tools-->Options-->General tab-->uncheck R1C1 reference style), but when I close Excel and reopen it, the reference style changes back to R1C1 style. When I make the change I described above using the Options feature, it changes it for the current file and saves it with the file. When creating a new file in the same session, it keeps the A1 reference style, but when I close Excel and reopen it, it returns to the R1C1 style. Any ideas about how to return to the default A1 reference style for the next Excel session?

View 9 Replies View Related

Macro Shorcut For Style

Aug 19, 2009

How to set macro shortcut for toolbar items which do not have a shortcut already like the "," style button which converts 12000 to 12,000

View 6 Replies View Related

VLOOKUP() Style But 3 Value Lookup

Mar 4, 2009

I have a table that has, amongst many columns, a year, month and a name column.

I want to do a formula that takes in 3 values (name, year, month) and returns a sum of values found in a variety of other columnswhere these 3 values are matched.

I would know how to do this in SQL but wonder if Excel can do this type of thing on one large data table?

View 9 Replies View Related

How To Select All Cells With Particular Style

Jan 19, 2012

Is there anyway to select all cells with a particular style in a worksheet? Like a "Go To" (F5) or Find Styles equivalent?

View 2 Replies View Related

How To Apply Style To Text In VBA

Feb 8, 2013

I have this code to copy excel data to a word document:

Code:
Set wrdRange = wrdDoc.Range
With wrdRange
.Collapse Direction:=wdCollapseEnd
.InsertParagraphAfter
xText = Rng.Cells(i + 1, 1).Value
.InsertAfter xText
.Collapse Direction:=wdCollapseEnd
End With

I need to apply a heading style to xText after inserting. xText can contain many words.

View 2 Replies View Related

Clear Cells With Specified Style

Jul 4, 2007

I have a spreadsheet wherein the defined data input cells are formatted using styles, i.e. data input style. I would like to know how to select all cells formatted with that style within a spreadsheet (whether worksheets are visible, hidden or very hidden) and delete the contents of those cells while still keeping the cell style.

View 9 Replies View Related

Place The Sheet Tab Name In My Spreadsheet By Formula

Sep 6, 2005

"DRHannay" wrote:

> how do I place the sheet tab name in my spreadsheet by formula?
>
> Excel 2003

Try:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

View 14 Replies View Related

Matching Two Cells Having Almost Same Number But In Different Style?

Dec 22, 2013

I want to know if there is any formula to match two numbers which have same digits but are in different style. I have attached a spreadsheet with numbers in column A and Column B. Both columns have the same number just the style is different, is it possible that i get a match based on the digits match and then return the output as correct or wrong?

If all digits match from column A with column B it should show as correct else wrong.

View 2 Replies View Related

Remove Unwanted Style In 2003

Nov 1, 2008

i have quite a lot of excel 2003 spreadsheets which once edited and saved by excel2007. now, i'm using back excel 2003. (because my efficiency dropped by half by searching the command i wanted in excel2007.) when i open them with excel2003 again, there are a lot of styles. i want to remove them. but it is a tedious job to remove them one by one for these spreadsheets.

View 3 Replies View Related

Concatenate Cells Address Style

Dec 30, 2009

How can I concatenate 2 cells address style? I'm trying to merge 2 cells into one, so that one is under the other in the same cell.

View 5 Replies View Related

Setting Particular Formatting Style For Column?

Dec 3, 2012

I have an excel that gets updated monthly with new sales data. The sales data comes straight from our custom CRM system in a .xlsx file. All columns on this spreadsheet have a column type of general.

In the excel that is updated monhtly however their are certain columns that are set to a date type so that we can group pivot tables by date. Currently I have to paste the data that is exported from our CRM system into the monthly spreadsheet (beneath all the prior months data), create a new column next to any date field and then use the formula

Formula:

[Code] .....

I then have to take the resulting data and paste them as values over the original data so that it is in the correct format.

Is there a quicker way of doing this so I don't have to keep adding a new column and doing the forumula, can I somehow set the column so it automatically converts data in a general format to a date format.

View 1 Replies View Related

Web Style 'Back' Button VBA Code

Jul 20, 2009

I have been trying to get a back button to work on an 2003 excel document that works like a website.

In the web toolbar there is a facility to go back and forward (very much like using internet explorer). I want a button on the actual sheet that does this command. If i record a macro and click the web 'back' button it records the end result of the process, not the process itself -

eg if sheet 1 and sheet 2 link to sheet 3 and I click a hyperlink from sheet 1 to sheet 3 then create a back button on sheet 3 and record a macro by clicking on the web toolbar back button the macro records the end result - eg Application.Goto Reference:="Sheet1!R14C8". However if i then go to sheet 3 through sheet 2, the back button I created takes me to sheet 1 not back to sheet 2.

Anyone know the code I could use to make it actually go 'back' to the previous page?

View 13 Replies View Related

Thousand Separator As Indian Style

Jun 27, 2005

we in india to any number put comma as stated below

ie 15,13,10,565.00

fifteen crores thirteen lacs ten thousand five hundred sixty five only.

00,00,00,000.00

but excel we have only thousand separator.it separates the number after every thousand.

can it possible in excel to formate number as per our style.

00,00,00,000.00

View 5 Replies View Related

R1C1 Reference Style Won't Stay Gone

Dec 12, 2011

Every time I copy and paste cells in a specific workbook it changes the reference style to R1C1. Setting it back in the options, saving the document, closing Excel then reopening brings it back as A1 referencing but copy and paste will again return it to R1C1.

I've checked for VB code and there's nothing there either.

View 1 Replies View Related

Macro To Select All Cells With Style X

Jan 26, 2012

Is there a macro that can select all cells with a certain style and then clear the values. The idea is that a big document has cells that are formatted as "entry-fields" and others that are not. I want to be able to select all of them with a macro (they are everywhere) and clear them of their contents (hence a reset button for this style).

I've tried something with If Target.Style = "entry-field" Then but i don't know how to search for them and have them in Target or a variable in the first place.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved