Question about Microsoft Excel for PC

1 Answer

Exel Hi I want to set up a stock control spread sheet for stock on hand, and be able to add goods recieved and minus goods taken. For the goods taken and goods recieved i would like to be able to enter them each time in the same cells and have it add or take away from the stock on hand and then reset so i can put the next value in the same cell. I also would like to have the stock taken linked to certian projects and it be able to do a count and report eeach year so i know what goes out and to which project. Am i expecting too much ? thank you

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

That might be too much for a spreadsheet to do. It's easy to set one up to show what you have on hand and what you took out. The links to certain projects, I would need more details about.

A better way to do it is to use Quickbooks. That way you have a history of who purchased a particular item as well as when you replenished it. Then you can generate a spreadsheet from Quickbooks as well. You can have your invoicing, receivables, and payables as well in one program.

Posted on Nov 08, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I pull a figure from a spread sheet and add it to another in the same file.....


Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

1 Answer

Print is misaligned when printing avery stock


Dear friend,
If you are using Excel or other spread sheet, you shouldn't print in draft mode. You'll need to use Normal or higher definition.

Regards.

Oct 13, 2011 | HP Photosmart C4480 All-In-One InkJet...

2 Answers

.xlsx file doesn't open in


try to uninstall the MS Ofice by clicking start > control panel > Add or Remove programs then remove the Office. Restart pc and install the Office using your CD. Hope that your XLS sheet will come true...

Feb 22, 2011 | Computers & Internet

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

2 Answers

Need to make gluten-free bread


bobs redmill gluten free mix for bread machines. we just use the standard bake setting but select B for doneness level. found it gets a little too dark on A.

Mar 20, 2009 | Toastmaster 1183N Bread Maker

2 Answers

Exel files slowly open


Hi Sahil,

This can be difficult to resolve on the first pass because there is so many things to consider. I have no idea what your experience with excel or computer maintenance is. All my training in industry has told me is go for the "low hanging fruit" first (try the easiest stuff first).
1) When did you last defrag your computer. That can be a fast easy fix. I don't know what your operating system is but you may have a defrag program included as part of the system.
2) How much memory do you have installed and if you have added some did it match what you had installed because memory will run as fast as the slowest stick installed.
3) Any other programs running in the background? My antivirous program is scheduled to scann at specific times when I would normally not be trying to be productive with my favorite programs. I have all the memory installed that I can and if my antivirous program is running and I try to do something else my system tempts me to persue fishing instead of computing just so I could use my machine as a anchor.
4) Do you have an infection of malware to contend with? When has the last time been that you scanned your system for system leaches.
5) was there a specific time that the software slowed down and if so what was done to the system at that time. Can it be undone?
6) Are you the only person on the machine?
7) Just how slow is slow? My machine takes 2 sec to load excel - 5 sec to load a spread sheet that I have been collecting data on stocks for 3 years but is a rocket processing the data and developing the individual graphs that is responding to the macros commands.
So is your expectations of the program realistic?
Investigate your issue and try to reason out what could be going on. Collect more data about your system so I can better guess from wayover here.
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}
Evenif this is not what you wanted to hear please don't forget to rate the answer. I can always learn from your opinion of the service provided.
Thanks
Glad to be of assistance


Oct 21, 2008 | Microsoft Excel for PC

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Problem with columns


In Excel 03, I went to Help, typed in "column" and they had a "add or delete columns" topic. Did seem to answer your question. Very modestly submitted. I ain't no expert, just nosy.

Jan 26, 2008 | Microsoft Excel for PC

5 Answers

Formula required


at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...