Making Squares

Jun 15, 2006

I would like to:

1-Make Rows & columns 1/4" X 1/4"

2-Be able to enter dimensions into an input box that would then draw a square(or rectagle) with the inputed dimensions in INCHES.

View 3 Replies


Add The Squares

Mar 24, 2009

How would I add the squares of cells A1:ZZ1 or A1:A1000, without having to do

=SUM(A1*A1+B1*B1+C1*C1... etc

This is a basic example of what I actually want to do, but is essentially the same problem.

View 11 Replies View Related

REQ Sum Of The Squares Of The First 'n' Natural

May 8, 2006

I need to do a Sum of the Squares of the first 'n' Natural
Numbers. Something like:


If 'n' is 8 say, then the function would return 204.

Thats 1*1 + 2*2 + 3*3 + 4*4 + 5*5 + 6*6 + 7*7 + 8*8

Likewise if 'n' is 6 say, then the function would return 91!

View 9 Replies View Related

Sum Of Squares Calculation

Jan 16, 2008

I'm trying to do a sum of squares calculation, between and within groups, across multiple columns.

I llike this to occur automatically when I input the data. Where I've running into difficulty is calculating the mean of each group(without sorting and manually selecting). See sample of data below:


Note that there are more columns of different parameters I've just inserted two for demonstation

View 9 Replies View Related

Delete All Little Yellow Squares?

Dec 20, 2013

Further to here where exactly in options do I delete all of these little yellow squares with script signs in them which are invading my spreadsheet?

View 14 Replies View Related

How To Automatically Sum The Squares / Cubes Etc Of List Of Integers

Jun 13, 2014

I have a lot of lists of integers and I want to sum their Xth power automatically, for X = -3, -2, -1, -1/2, 0, 1/2, 1, 2, 3, 4, 5, 6.

For example, take this short list of integers: 1 2 3 4 6 12

The sum of their Xth power must be: 1^X + 2^X + 3^X + 4^X + 6^X + 12^X

How can I do that?

View 5 Replies View Related

Stop Squares When Adding TextBox Text To Cell

Nov 8, 2006

In a userform i have created an textbox. The user types some text in it and after clicking an OK-Button this text must be copied to a cell To allow multiple lines (enter = new line in textbox) i have changed the textbox property EnterKeyBehavior to True. The problem is that after copying this textbox1.text to a cell in see square blocks in the cell.


instead of

I use the following code to copy the text into a cell:

Private Sub CommandButtonOK_Click()
Dim TextboxText As String
TextboxText = TextBox1.Text
ActiveCell.Value = TextboxText
Unload Me
End Sub

how to avoid this [] (should be like alt-enter in a cell)

View 6 Replies View Related

Making A Map

Feb 3, 2010

I am making a simple map in excel. I have my floor plan on sheet 1 and the location of product on the floor on sheet 2.

Currently I have some formulas on sheet 1 that link to some sales data on sheet 2, but what I would really like to be able to do is use the search function on page 1 and it give me the location of the products in a given area.

The data is broken up into group location on the second sheet.

View 11 Replies View Related

Making Lists...

Feb 6, 2010

I have four columns containing about 200 addresses.

A Names
B Streets
C Cities
D Phone no.

If I write a name in D1 I want to get the corresponding street, city and phone no. in E1, F1 and G1.

I also want to copy the formula downwards let's say ten times so I can make a list.

If I for example just want to make a list of three names (D1-D3) I want the rest of the fields to stay blank.

View 6 Replies View Related

Making Add-in Macros Available

Aug 2, 2007

I've created an Add-in (.xlam file) in Excel 2007 and installed and activated it (it shows up under "Active Application Add-ins" on the Add-in menu for new workbooks).
I can see the macros and code when I go to the VBA editor, but the macros don't show up in the regular macro list.

I know that I can write code for the new workbook that will reference the Add-in code, but I want other users to be able to install the add-in and run the macros in it right away without any knowledge of VBA. Is there a way to make this possible?

View 11 Replies View Related

Making A Calculator From To Vba

Feb 11, 2008

i made a claculator in, and now i have to make one in vba, what i did was as follows, first ill post the code from last year, then my vba attempt;

View 14 Replies View Related

Making A Button

Mar 14, 2007

I have a spread sheet that tracks progress reports that are due every 90 days. I have a due date colum that will automatically get high lighted if the 90 days have passed to inform me or my staff that the report is late. I would like to have a colum with a button in each row that allows the reader of the spreadsheet to press "YES" for that accont's progress report having been turn in. When the "YES" button is pressed the date due date column advances to the next 90 day due date and the highlight would turn off.

I used the conditional format to change the due date column to Yellow if =TODAY() is less then or equal to the due date. But I can figure out a way to select something and turn the highlight off and advance the due date to the next 90 day due date.

View 9 Replies View Related

Making A Roster

Mar 30, 2007

I have been asked to make a formula that sums up the hours in a week and then tells me whether I am below or over the budgeted hours for that week!

I cant get it to work since I cant figure out how to have the same formula in all the cell that sums up early, mid and late shifts, ie 06-14, 14-22, 22-06.

The graveyard shift is a problem there since I get negative hours.

Further more, I need to have the formula ignore cells to be added up if it has letters in it, we write an R for Rostered day off.

View 9 Replies View Related

Making A Barlist

Aug 20, 2008

............Beer........ Total
Stefan:....1........... 0,70Ä

Now i need a button that when i click on the name the amount 1 gets 2,3,4,5,6, ect and that it calculates the price up as a total

View 9 Replies View Related

Making A Report

Jun 6, 2006

1- I 'm working with a table wit many Sheets.

I want to make a Report Sheet with selective ranges(cells)
the selective cells should paste as link ( in order to be updated cells)

2- then how to Zip this worksheet to zip file ( to save it)

3- If I have a Macro and i want to perform this macro to all sheet except one sheet how to that ?

View 6 Replies View Related

Making Cell Mandatory

Aug 21, 2012

In Column B of my spreadsheet i have a drop down that only allows users to enter "Yes" or "No"

Is it possible to make Column C a required field if "No" is selected in column B.

So basically if cell b4 is "No" then i want to make it manditory that cell C4 is filled out with a reason why.

Same thing for cell b5 then i would like cell c5 filled out before they continue using the sheet. etc.

View 1 Replies View Related

Making Dropbox From Datatable?

May 6, 2014

I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc.

View 5 Replies View Related

Making Spreadsheet Smaller?

Mar 28, 2014

I built what I can only describe as a fantastic spreadsheet. It wasn't until after that I realized it is 123 MB in size, but even for the complexities within it, it still feels like that is quite large.

I can't share the file due to proprietary reasons, but any general tips as to things I can do to make it smaller (and therefore faster to run).

I tried saving it as a binary spreadsheet and that dropped it to about 80 MB, but I don't really know what that does and if it will impact the sheet performance in any way.

View 2 Replies View Related

Function Making Worksheet

Apr 24, 2008

I'v got a school task about making a excel worksheet.

But we have just started and i havent gotten all the functions to work yet.

The task itself is :

Make function that tests if D9 is larger then 100 and I9 is less then 50. If true "Kontroll" if not "OK" should be written.

Also, if "Kontroll" shows up it should have a dark green "OK " should just be black

Its roughly translated from norwegian. If you need some more information I will try to provide it

View 10 Replies View Related

Making Sure Cell Has 'J' Prefix

Nov 23, 2008

i have a cell "h23" that must always start with a "j" or a "J"
the trouble is some of my users are only putting in the number
ie 2345 when it should be j2345 or J2345

View 3 Replies View Related

Making One Worksheet Talk To Another

Dec 8, 2008

I know I posted this same topic about a week ago but I went through the first 20 pages on the forum and couldt find it, i tried the search option and nothing came up. I have several worksheets in the same workbook. When I enter a number in one cell in work sheet A, I want the same number to show up in a given cell on work sheet B. How do I do this? I can make words move from one shet to the next but numbers dont seem to be the same.

View 6 Replies View Related

Making A Summation Table

Jan 11, 2009

I've run into an issue for which I can find no elegant solution. I consider myself a competent Excel user, so it's pretty embarassing...

What I want to do is to sum the values along the 'axes' of the table. In order to fully explain that, I'll give a small example:
Let's say, this is my source data

View 2 Replies View Related

Making List From Various Cells

Jan 14, 2009

I have a workbook of contracts that I have designed in excel. Each worksheet tab/title is the contract number, i.e. 3487. On each individual contract I have the contact name, address etc. Each cell/field is in the same position on every contract. In other words, every B1 is the Group name, every B2 is the first name, every C2 is the last name, etc. What I'm trying to do is to make a new page with all of the contact info on it so I can make labels etc. I hope this is clear.

View 5 Replies View Related

Making #N/A Dissapear (or Appear Blank)

Apr 15, 2009

How do you make a cell appear blank when it has a formula in it refering to a cell that hasnt been used yet?

I would like some cells to be blank instead of having #N/A in them.

View 7 Replies View Related

Making Cell A Hyperlink

Jun 2, 2009

I have a table which as a few columns, the left column is called name and the far right one is called email. The name cells have a drop down list which refers to another workbook with peoples names, when you select a name other cells are automatically populated using the vlookup function such as phone number, email etc. In the workbook it is referencing too with all the data, the email address are like a hyperlink which creates an outgoing mail if you click on it, is there a way to have this in the table as nothing happens when you ckick on the text.

View 6 Replies View Related

Making Columns Get Sequentual?

Sep 22, 2009

One of my colums has a list of customer Ids:



I just added a bunch of new customers, like 400 of them. Is there a way to make the column automatically add a customer ID, in sequencial order down the column for 434 more customers downward?

View 2 Replies View Related

Making IF= Formulation Come Back As N/A

Nov 2, 2009

I am trying to create an IF formula so when i try to get the percentage change if lets say the 2008 number was 0 and the 2009 number increased by 9 than i would get an error so i want the if formula to come back as n/a.

View 5 Replies View Related

Making A Time Sheet

Dec 1, 2009

I made a time sheet. In this time sheet i made a macro where when I press ctrl+t it fills in the date in a column and the time in the column next to it. So to start my day I would press ctrl+t and to end it i would goa column over and repeat the macro. and then i made it so that in the fifth column it adds the 2 times together with this formula "=IF(E27>0,(IF(G27>E27, G27-E27, 1+G27-E27)),"")" formula works fine unless you make a "mistake" and change the ending time manually to a time that is early then the starting time but on the same day. So I wanted to see if there is anyway of the total time column can return an error message if the ending time is earlier then the starting time by looking at the date in both date columns. Im going to attach the workbook to this post. on the tabs on the bottom it is under time sheet. and i think the macros should transfer over too. ctrl+t is the time macro if you want to try it out.

I may have not been so clear on explaining it so ask any questions if that is true.

View 13 Replies View Related

Making New Spreadsheets From Tabs

Feb 19, 2013

Is there an easy way to make a new spreadsheet for each tab of a current spreadsheet?

View 3 Replies View Related

Making A Synonym List

Dec 12, 2007

i have to make a synonym list out of existing wordlist for my professor. As far thatís the most boring job I would like to ask you people, if it could be automatically done by a vba code. I donít think that thatís technically possible but I hope though that I am wrong and that some one here can help me. I will try my best to describe the problem as good as I can. Please let me know if its not precise.

Here we go!

I have a wordlist containing four columns A,B,C and D. In column A we have got Source Words(sw), in column B word specifications1(ws1), in column C word specifications 2(ws2) and in column D we have many meanings and target words separated by comma (tw1,tw2,tw3,Ö) for (sw). The interesting columns for our problem are only A containing words (sw) and column D containing meanings and synonyms(tw). The wordlist is supposed be get larger through finding, enhancing and adding synonyms in the same list. The difficult thing would be to make a macro with two modes. In first mode which asks each time before it adds or enhance a cell and in second mode the macro should do all the work alone without asking the user. The existing wordlist looks like: ...

View 41 Replies View Related

Copyrights 2005-15, All rights reserved