Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution?

Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.

What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).

I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?

Thanks,

Peter Fraga
(fragapete@hotmail.com)

Hi All,

I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw

Dynamic sub tables based on a master sheet array formula

The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))

B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.

What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.

I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.

My question is...does anyone have any hints how to optimize this formula?

Thanks
Tony

math trick

column a column b
numbers reuslts 10 0 13 0 19 15 23 15 32 30 27 15 40 30 70 65 I'd like to say if number between 15 and it's multiplication put the the multiplication numbe

10 between 0 -15 put 0
13 between 0 -15 put 0
19 between 15 -30 put 15
23between 15 -30 put 15
32between 30 -45 put 30

and so on
for any number

i'm working until 250,000

thanks

A discussion about sharing ideas for startup businesses:

Developing new startup ideas

led to this shared Google spreadsheet:

startup ideas spreadsheet

While I am no whiz at Excel, I wanted to manipulate the items on my desktop with Excel 2007, so I downloaded the Excel version of the file (File/Download as Excel). When I load the Excel .xls format into Excel 2007, it opens fine, but the word wrap is inconsistent. Some rows have the words wrapped, and some don't. When I click between the 1 and A to select the entire sheet, and click on "Word wrap" to toggle the entire sheet, the unwrapped rows will still not wrap. The individual cells that do not wrap seem to have the wrap line box checked, too.

Does anyone know how to make all the lines wrap?

Thanks a lot! I sure appreciate your help.

Lester

My question is If I have a cell where I am using "wrap text option", is there any way to split a e-mail address at a pacific point, with out having to use the space bar, which makes the e-mail address have a space in it. Anoutherwords my e-mail address are on two lines,in the same cell, so to keep my collumn narrow as possable. Thanks Dan

When you are making a formula say

=A5 + A6+A7

when you are doing this in cell D423, it sometimes gets annoying to have to either type in A6 and A7 manually or to navigate to A6 and A7.

I know there is a key you can hold down after doing A5 that keeps you on A5 even after putting in the + sign, so that you don't have to navigate all the way back there.

I can't figure it out!

Does anyone know what this is?

Please help!!

Thanks,
Michael

Hi Folks,
I've been trying to get the text in my VBA Userform textboxes to wrap onto the next line when it runs into the border of the box.
How do you set it up so that it does this. I've tried the properties window and set the word wrap to true but the text still stays on one line and goes out of sight.
Any help is appreciated.









EDIT: Thanks Marvin, it worked perfectly!

I have a chronological log in Excel 2003 (Windows XP) which shows to on-going status of various projects. As time goes by I add comments to some of the cells and the cells get fairly large.
I have some cells (with word wrap) which now have approximately 1550 characters in them. After this many characters, word wrap doesn't work for any additional characters in that cell, so the rest of the entry doesn't display on the worksheet.
Question: Is there a size limit on the number of characters a cell will display with word wrap? Is there a workaround to this problem, other than inserting another row beneath the questionable one, to continue the entry ?

So I used Excel Magic Trick 185 to dynamically pull content from a spreadsheet: http://www.youtube.com/watch?v=6bGKhbUYOas

However,
It is only working for a few of my columns though and I am getting reference errors, http://www.mediafire.com/?gje8srbp8x2j48w

Can anyone check into my spreadsheet and help me understand why I get these ref errors? Is it because I have spaces in the column names or within the cells? I know a macro is probably a better way to do this, or an auto-filter, but I need it to dynamically update. Any ideas on how to fix this problem or a better way to solve it?

Thanks!

I am having some problems with a text box not wrapping the text to fit it in a text box that shows 252 in width.

Is there another command that I can use in vba to make sure the text will wrap and fit in the text box?

Again thanks for any and all help.

Kurt