Creating A GUI Front End For An Elaborate Calculator
Nov 4, 2007
I have a very elaborate excel file that will calculate a price for our customized product. The user enters figures into about 15 fields, and hundreds of calculations take place and give the user a unit-price for that item.
Further, this excel workbook contains 3 queries to our enterprise database that get updated on opening.
What I want is to have a front-end GUI form that the user accesses like an html page that can be viewed internally by only users withing the intranet.
The main point here is that I have very sensitive information in the workbook. The last thing I want is for it to be emailed to our competition. Protection is not an option either, because I heard it can be easily cracked.
I want my user to access the excel spreadsheet without ever getting their hands on the original.
Maybe this thing should have been written in some other software package all along, but this is what I have to deal with.
View 9 Replies
ADVERTISEMENT
Sep 3, 2009
in creating a macro that will remove all frontspaces, trailing spaces from entire sheet + remove characters like (), *,-, &, @,/,',;,. from columns E and F,
in col E and F there should either be string or numbers, everything else should be removed.
View 9 Replies
View Related
Nov 9, 2013
I'm very new to excel, my boss request me to create a discount calculator. A cost of price is given. We have a fix discount rate of 5% of that cost value. Some new customer want more percent of discount to the item they purchase. To deal with that, a markup price will be quoted then we will make a discount according to what the customer prefer but the final discounted value will be always be the discounted 5% of our cost value. I've problem creating it because as example; the customer request for 15% discount, when I add the cost + 10% then minus it back to 15%, the value I get will no be the same of the fixed reduced 5% value of my cost value.
ac16xpZ.jpg
View 5 Replies
View Related
Apr 22, 2014
I am trying to create a price calculator for a particular product line which has multiple sizes and configurations. I would like to use drop down boxes so the user can select the size, type and attachments which will be narrowed down by the previous selections.
I would like the formula to be able to calculate the cost of the components based on the selections made. Based on some research I believe this can be achieved using data validation, indirect function and the vlookup function, however; I'm not quite sure how to go about this.
I have attached the document I have started for reference.
Chain Sling Price Calculator-4.xlsx‎
View 3 Replies
View Related
Feb 20, 2010
Im using this formula but want to add ROI in front. =sum(t1/q1)
What is the notation?
View 9 Replies
View Related
Jun 30, 2006
I have a question, how do i display a number 0 in front of another number? Example, I am working with these zipcodes and there is a 000213 but it only shows up as 213 in the cell. Is there a way for it to be 000213 with out me using the tilde sign `000213?
View 4 Replies
View Related
Nov 6, 2008
i have to copy and paste values from an sap program over to excel spreadsheets, and I usually do about 15 at a time that end up in a column: 15 different cells. The value I am copying are ID numbers that all begin with zero and excel automatically removes the zeros at the front of each number. Is there a formula/process for preventing this.
View 2 Replies
View Related
May 23, 2013
I am trying to create a custom number format that will put a plus sign in from of the value in a cell if the value is positive.
Here is what I have been using:
+#,###;-#,###;"On Forecast"
There have been a few problems with this. Firstly, the values are have two decimals, and I have not been able to adjust it accordingly. Secondly, there are some cells that contain only a zero, and the custom format above changes the zeros to 'On Forecast. Other than these two issues, that custom format works.
View 1 Replies
View Related
Feb 18, 2012
Is there a formula for adding zero's in front of numbers?
Example:
If a single number is found in cell B1 add two zeros (2 would become 002)
If two numbers found in same cell B1 add one zero (34 would become 034)
View 7 Replies
View Related
Feb 11, 2013
I just needs to know how i can pull picture which is placed in front of any value like we pull some data through vlookup formula but here i want to know we can pull picture which is placed infront of any value.
In output sheet i have shown example of what i want and in data sheet my data is placed like that. What i want to that i enter picture id in output sheet in search option if pull's picture which is placed infront of it in Data sheet.
Click Here to see my sample File.
or [URL]
View 1 Replies
View Related
Aug 7, 2008
ans....>and
Good evening. I would like some helps about how to use sumif or any formula that can sum my credit. For example
code------credits
a12345------1
*b12345-----2
c12345-------1.5
*d12345-----3
The answer is 5
I would like to sum the credits only * infront of them.
View 9 Replies
View Related
Sep 8, 2008
I have a worksheet to keep track of products. I use an SKU column with a Unique Number to keep track of those items on the shelves.
When I started my project I never imagined that my database would grow as large as it has. I started my SKU numbers with 80000, never suspecting that I would get to 90000. I am now at 125700. Many items have been removed / sold so it only encompases only 15500 rows.
On the site that I sell these Items, the SKU's when displayed start with 100000 and go to 125700 where 80000 is next and goes to 99999? ( or the reverse depending on which tab I choose ) Not sure why this is but there is nothing I can do to change the way they do it so I must find a way to change my system. With all the 80000 - 99999 items numbered - changing them to 6 digit 125700+ numbers would be a huge undertaking so I would like to add a 0 in front of each 5 digit Number in my SKU Column. That way my items will show 080000- 125700 instead of starting in the middle.
I do keep the column my ascending order so it is currently formated as a Number. I do at times copy an paste or pull ranges items by SKU numbers to mark down or modify.
When I place a 0 manually in front of 80000- it disappears when I move from the Cell.
If I change it to a TEXT cell- it stays in place.
Excel help doesnt answer my dilemma-- nor does my book.
I see there are masks etc -- or is just text OK ? (as I stated - I do use an numbered order or range to identify groups of items at times )- if text is OK, what is the best way to add a 0 to the start of each 5 digit number other than individually ?
There are Gaps in my sequence so I cannot just replace the first cell with 080000 and pull down.
View 9 Replies
View Related
Mar 6, 2009
How can I use a VBA to change the font color to red for all the dates on a sheet that are within 30 days of today?
View 9 Replies
View Related
Apr 14, 2014
What I have is a sheet with Command Buttons on, and one of them when clicked launches another application which has a log in screen.
I can't for the life of me get it to bring that application log in window in front of the excel application when it runs.
I have tried various ways of sending Excel to the back once the button is clicked, but just can't get it to work.
Ideally, once clicked the new application log in window will come up in front of excel, and set focus on the Password box, is this impossible to do just from inside excel?
We are looking at
[Code] .......
View 4 Replies
View Related
Aug 15, 2012
What is the code to hide my vba calulating on screen? I have vba doing a bunch of things (like updating values etc.) that I don't want the user to see while using the spread sheet.
View 2 Replies
View Related
Nov 20, 2012
I have chart object in the sheet. I wrote code that makes the cart big, but it is not on top of other things. I need to add a snippet of the code that would make it "bring to the front".
View 1 Replies
View Related
Oct 23, 2013
How to remove a space in between, front & last in a excel, since i have a huge data
for example
i have in col something like this
S01 E201 = in another column i need like this S01E201
if there is space before the letter S and if there is space after the last letter 1 in need to remove the space in the excel
for more clarification
Col A
Col B
S01 E201
S01E201
S02E201
S02E201
S03E111
S03E111
View 2 Replies
View Related
Aug 15, 2007
I need to know how I can delete NUMBERS in front of the names....
I.E.
Colume B
12Smith
12John
13Chris
152Matt
1111Joe
12569Joe
1234Smith
I need to delete the numbers in front of the names - i have about 26thousand records like this and need to know how i can delete them.
View 9 Replies
View Related
Jan 16, 2008
I have a number of macro's which correspond to shift numbers 1 - 23
I would like to have a drop down list on the front sheet so that the user can select the number at the end of the shift which activates the corresponding macro
View 9 Replies
View Related
Aug 16, 2008
I'd like to keep a progress bar userform I created in front of other windows that are opened by a module that is scanning through the data within each file. While files are opened, I want teh progress bar to stay shown at all times. Within the module opening and scanning the documents I show the userform as follows: userform1.show false
I've serached the site and found a link that supposedly explained how to do this but the site is worthless.
View 5 Replies
View Related
Mar 26, 2009
I have a spreadsheet that I exported from my accounting software. For some reason there are 4 columns that all begin with an apostrophe and have various lengths of white space before the wording begins.
What kind of formula can I use to get rid of the apostrophe and have the wording be left aligned within the cell with no space before or after it?
The file I am working on is attached. They are columns C, D, E and F.
View 2 Replies
View Related
Jan 21, 2013
I have 36 pages of names, addresses & contact info ETC that I want to print. I have a printer that offers a cover sheet in the print setup.
My list of names addresses ETC takes up two full pages of paper for each name. There are 16 columns across the sheet that contain data for each entry. I would like to print this so that I can turn the pages like an address book and see all of the data for a given set of contacts on each two page spread. So what I need to do is print the first half of the contact info on the inside of the first page and the second half on the next page and so on.
How can I set this up?
View 4 Replies
View Related
Oct 30, 2009
I've got a macro that searches & opens a most recent file. I'm trying to figure a simple way to bring to the front the workbook which is opened by the macro.
View 2 Replies
View Related
Mar 7, 2007
I am working on a project for a monthly report. My back sheets have (or will have) 12 columns of info for monthly income/expense for multiple companies. The front sheet will have 2 columns, one for the past month & one for cumulative.
Obviously the cumulative is an easy one to pull off, but how can I make the correct column show up for the current (last) month I am working on.
Rather than make it tied to the actual date of input, I have used an approach in the past with a "sum if" formula for a single reference where =sum if(b6:b6,a2,a6:a6) but I'm not sure how to make it work for 12 references. Can this be done?
View 10 Replies
View Related
Jun 20, 2012
reading a zero number in a cell
here an example :
on Cell A1 = 01
on Cell B2 = 10
so I write at C1 the formula is =left(A1,1) but how come the number that comes out is 1 not 0 (zero) ?
but if I write at D1 the formula is = right(A1,1) the number comes out is 0 (zero)
how to make the formula that can read the zero in Cell C1?
View 9 Replies
View Related
Jul 18, 2012
Here is the current code I am using: =IF(A1="MIXED DBLs 1st Place",'Mixed Doubles'!B9,"")
What has happened is I am changing the Field Mixed DBLs to a field that could have multiple values, so I am no longer going to be able to do a test on a Hard-Coded Value.. So is there a way to only validate on the front of the word like just MIXED DBLS and nothing after that??
View 2 Replies
View Related
Nov 2, 2012
I have a bunch of rows that overlap other cells after using the format painter. My workaround has been to drag the row down to reveal the cell values. What's a better way to highlight many rows and do this in one shot? Adjusting each row to reveal text isn't efficient. I would like to not use macros either to solve this problem.
View 1 Replies
View Related
May 26, 2009
i have data which has lots of these hyphen "-" how can i get rid of them,
for example -Eq Cash-
i need the result to be
Eq Cash
Also i have lots of front spaces in my data, how can i get rid of those? so for example
Test (there is 2 spaces before T)
View 9 Replies
View Related
Jun 13, 2007
I want to remove the front zero(s) from the front and put a space before the last two letters for the following column of data in Excel:
0001MG
0020MG
0100MG
1000MG
Final result will have this format and the data are right aligned.
1 MG
20 MG
100 MG
1000 MG
The numbers can vary (e.g. 0150MG, 0025MG,etc.) but the arrangement is always the same: four figures for the first 4 characters and two letters for the last two characters.
The format of the cells containing the data is: “General”
My table has 7 columns and these data are in the 5th column in a worksheet called “ProductSummary”. The number of rows for the records can vary from 10 to over a couple of hundred.
How can I use VBA to: 1) automatically select the table range in that worksheet and reformat all the data in the 5th column.
View 6 Replies
View Related
Oct 2, 2007
When I draw a vertical Scroll Bar and set the Min and Max in Properties, the Min gets set at the top of the Scroll Bar and the Max at the bottom. This seems backward to me, but it's probably an issue with Microsoft's programming. To get around this, I've entered the Max value in the Min and the Min's value in the Max. This allows the Max value to be at the top of the Scroll Bar and the Min at the bottom, but I was wondering if this is anathema in the world of coding, and could I be setting myself up for coding problems down the road?
View 2 Replies
View Related
