I am going to attempt to design a production spreadsheet which does the following:
1.Orders are put on one page of the spreadsheet (Order Tab) The order is put on listing, Customer, Sizes, Qty etc
2.The user is then able to select an order and if possible I would like a pop up calendar to appear in which the user can then select a production date.
3.One the production date has been selected I want it to open up a new tab if one doesn’t already exist and then cut the information from the order tab and then paste it into the production day.
I have provided a spreadsheet of what I want to achieve but I am unsure if this is possible.
I have been tasked with performing a work measurement study to improve productivity in our organisation. I managed to adapt a paper based report to an excel file; with the view of creating a model. I also intend adding the cost of employing people in specific positions to determine the cost per hour for each specific activity.
I've created a spreadsheet that has a number of command buttons acting as hyperlinks navigating to other worksheets within the workbook and other files. The buttons only function when in design mode and no matter what I try the document will not open in design mode. For ease of use I wanted to avoid training people on how to go into design mode, anyone aware of a work around?
I'm trying to design a spreadsheet to allocate an amount to different bands.
For example - I have the figure 1750.
Band 1 : 0-500 (1) Band 2 : 501-1000 (0.8) Band 3 : 1001-1500 (0.6) Band 4 : 1501-2000 (0.4)
Each unit in each band has a value (in brackets). So as you can see, the value of a full Band 1 would be 500. But the next band is only worth 400 when full, and Band 3 is only worth 300. I want band 1 to fill up first, then band 2, then band 3, then finally band 4.
I would like to be able to allocate the figure 1750 to all the bands automatically - starting with band 1, then 2, then 3, then 4.
Compatibility mode, in 2007, is frustrating me like crazy. I thought it was supposed to 'limit' functionality to what was in 2003. But what it seems to be doing is letting me use features that only work in 2007and then tell me when I save that 'hey, these won't work after you save'. Ugh! I can't even pick a highlight color without getting a warning and wondering what it will look like to 2003 users!
Is there a 'theme' or anything that will truly limit the features I use to those available to 2003 users?
I have a dataset storing 6 numbers in a row (where each number range from 1 to 50 and no duplication of number within each row). Totaling there is 1000 rows ....
I have attahced an example of what I need to do. I need to project due dates for each of our 8 departments based on a ship date of the final product. Each of the 8 dept. have a number of operations (ops) and given number of hours for each op. These alocated hours change on every job plus I have 2 outside operations that may or maynot be added to the mix. I don't have a clue on where to even start with this formula.
My customer makes 6 different widgets, all of which use a different number of the same parts (tabA ~ tabZ) For example, model A has the following: 1 x tabA 2 x tabB 0 x tabC 4 x tabD.
I have a matrix which shows how many of the different parts are in each model. The part number goes down the rows and the model being produced goes across the columns. So this goes from A10:G:21
Now, I have to do a forecast for the next year and I trying to figure out the best way to do it and have each months totals of each part. My forecast has the model numbers going down the rows and the months going across the columns. This is from A1:G7
The way I used to do it is have a line for every part and manually multiply the monthly total by each models per unit and it ends up being a formula that gets longer and longer.
January needs for tabA are (B2*B11)+(B$3*C11)+(B$4*D11) ... February needs for tabB are (B2*B12)+(B3*C12)+(B4*D12)...
When they have 20 distinct models it gets difficult. Also, there may be mid-season changes to the bill of materials that make it difficult to change.
I have a production schedule with start and finish dates for each project. To the right of this I have a matrix with "week starting" dates. What I am looking for is a formula that will indicate how many days in each week the project will take. Below are the cells filled in correctly. However, I did this manually. Any idea of a formula? I'm pretty new to this.
WEEK STARTINGSTARTFINISHUNITS PER DAY9/1/089/8/089/15/089/22/089/29/089/10/089/24/0813.4503530
I need to make a spreadsheet on excel which shows the production schedule of a product over 4 days.
Then I need to make a supply ordering sheet which shows how much supplies are needed to do the above task and how much each item in the supply list will cost and when the items would need to be ordered.
I work for a manufacturing plant where we manufacture one product which is then sold under different names.
The product is made from the same material.
I am looking for a way to match up production to the orders and then subtract the produced quantity from the orders.
Tab 1 - Orders: Column 1 has the items (A1, A2 and A3 are all produced from A), Column 2 has the date when the order has to ship and Column 3 has the ordered volume.
Tab 2 - Production: Column 1 has the raw material, Column 2 has the production date and Column 3 has the amount manufactured.
now if i wanted to be able to look up jason then have it populate which Dept he worked in, in cell A1 in my excel spread sheet what code could I use. Just want to look up one area in my access data table then show it in A1 one item at a time.
I have daily production sheets (Excel sheets) that I fill out every day indicating the day's production totals. The files are named by the day's date. For example today's sheet (4/24/13) would be 042413.xls. However, I would like to be able to pull certain pieces of information into another separate spreadsheet. For example, my boss asked me how many of a certain product we made over the last month. So, I'd like to pull the product info, the date made, and quantity made into another sheet. And I'd like to be able to do this automatically for a date range that I specify.
There should be a Login and Logout Button and a Start time end time button to record data to the next sheet in the workbook. Also it would be great if it includes a Break and EndBreak button so that the time taken in the breaks gets recorded in the next sheet in the Workbook.
Every Morning colleagues should click the LoginButton to start and click the logout button at the Day end to get the total production time recorded in the next sheet. (Total production time should be Total time taken minus breaks). We have a 9 hour shift.
I have a 5 major categories of products e.g. Ketchup, Hot sauce ,mayonnaise , pizza sauce etc.
Now each of these individual categories are further divided into number of of subcategories based upon the the sizes and brands.
I want to create a sheet (One sheet) where I have to record production of each product on daily basis.
Like for example if I am producing ketchup, I select ketchup from drop-down list,Now in next column I have to select production size from predefined sizes i.e subcategories. But it should also be from drop-down menu and it should only show me the subcategories of my selected product like ketchup .I think this has something to do with data validation but I am not sure how this model will work.
I have a very large spreadsheet where i have orders, product and line status listed. I neeed to find the line staus of each product in production against the order. I'm using an array sumif formula but since the spreadsheet reachs 10000 rows of information I dosn't alway calculate correctly.
ORDERPRODUCTSTATUS ABCDAPPLEPICKED ABCDORANGEON HOLD ABCDPEACHSHORT ABCDYAMSSTAGED EFGHAPPLEPICKED EFGHORANGEON HOLD EFGHPEACHSHORT EFGHYAMSSTAGED
Required Result Order ABCDAPPLEORANGEPEACHYAMS PICKEDON HOLDSHORTSTAGED
I've been reading some threads lately about worksheet design and wanted you advice on something.
I have a worksheet that is about 7.5mb. The details of the worksheet are:
A. 19 total worksheets within workbook, three are visible B. 1 master worksheet (raw data) that is updated monthly C. There are 13 worksheets (for each outer office) that pull data from the master. D. A couple of "Summary" sheets that summarize totals, profits, losses for each area
Situation is this....All code runs fine, but when it's time to save the worksheet it is kind of slow doing so b/c of size.
Would you suggest making a seperate WORKBOOK for the outer offices? I gave this a try yesterday and it worked fine, but I also added code to save once the data was extracted and that part took about 5-6 seconds (I know that's not horrible, but I'm comparing it to previous times).
For some strange reason the workbook I have been using on a daily basis has suddenly decided to go into design mode and stay there. No matter how many times I click the design mode button in and out it always stays in and I can't use my buttons.....it just selects them?
How can I format a Pivot Table with 5 levels. I try to use the "Design" but it only format the first 2 levels of the Pivot Table. I need to distinguish each level with different colors. I think manually is a bit difficult.
I have a production report card spreadsheet with numerous checkboxes. Originally I also had text boxes for user input - which I have since removed all of and simply unlocked cells for user input (I protect the spreadsheet). My problem is that now that I have removed ALL of the textboxes - I get the error message "Can't exit design mode because Control 'TextBox3' can not be created." everytime I go to lock the spreadsheet after tweeking or upon opening of the file. I also cannot use the checkboxes now because I am stuck in design mode.
Any thoughts on what might be causing this...or better yet...how to stop the error msg altogether? I googled and no answers...some theories that it was a bug with excel2003...but I find it hard to believe as I found posts for the same message of users of WORD2003...so I am thinking it might be VBA related?
I am in the midst of developing a Userform with a purpose of entering/retreiving and amending data. A rough approximate of about 50 sets of 3 text boxes is required for user to type in data. Is there a kind of limit or performance issues if there are so many text boxes available? What other ways would make it work? Would appreciate some advice from the veterans in this field.
im trying to make a few things work at different stages.
1. Im TRYING to create a not so simple programme with Excel for My Wifes Creche - She would like to have a programme that, when she gets a phone call from a parent to check availabilty in lets say - 3 months time, it reports back with a number of availabiltys for that date in a specific room.
2. Rooms are broken in 4 categories ( up-to 12 mths old "Baby room" 12 mths to 2 yrs "Wobblers room" 2-4 yrs "Toddlers room and finaly Playschool,)
3.So far what i have done is this =IF(G2<$A$1,"",IF(G2<$A$1039,"Baby",IF(G2<$A$1404,"Wobbler", IF(G2<$A$1770,"Toddler",IF(G2<$A$2290,"Playschool", which gives me a room from inputting the Date of Birth.
4. ive then used the form button to give me the option to add edit and delete entries from the headings (First name Last name Date of Birth Room -but this will show once DOB is entered.
5. i have tried to run the =COUNTIF(A2:A7,"Baby") to try and get the total baby spaces taken up at a given date however this wont work for me and isnt giving any error message, just a blank cell.
I have been writing VBA code in Excel for about 4 years, but I am self-taught, so I only know what I have had to learn. Recently, I learned that I could run a macro from a cell formula. I created several hundred cells (on multiple worksheets) that include calls to various macros. I only want to run these when I know they need to be updated, not every time I change a cell value.
I turn on Design Mode and try to modify my worksheet (adding or removing columns, rearranging stuff) and some macro(s), somewhere(?) execute every time. This can sometimes take 15-20 seconds for everything to update.
Did I hit some magic key sequence, somewhere? How is it that some of my macros, somewhere are running with Design Mode enabled (and turning it OFF, by the way)?
The spreadsheet I have designed is to be input offshore by one group, and the values that get put in this shared workbook will feed into another shared workbook (for reference and ease, I will call one offshore. book and the other uk.book).
It seems that I have to save the offshore.book (so could I use some autosave code, for every 5mins or so? I dont have the plugin so would have to write it in), then hit update links in the uk.book (again, I presume I could write this so it triggers off every 30mins or so, but can be done manually if required). It seems abit fiddly doing this, but this is the way they wanted it done (my idea was to put into a database, but got out voted).
The figures in the uk.book would simply be a vlookup. However, we do not want the uk team to be able to look at the other book so would the links still work properly? (ie there would only be one open workbook at a time - direct access to each others spreadsheets shouldnt occur.)
