I'm attempting to use Excel as a writing tool.. it's incredibly powerful as it will allow me to customize my workspace, create links, flow charts etc... but an area I'm most concerned of is at the heart of this endeavor, which is text... lots of text!
I believe there is a limitation regarding the amount of text within a cell ( something like 250 characters?) Is there a way to customize/format a cell to include much more text?
What route would you advise? ..Forms, pivot tables, textboxes?
I am preparing a very large spreadsheet of text. Once I reach a certain point (a few paragraphs?), the program stops wrapping the text. All of my text is visible in the box at the top of the spreadsheet when I click on the cell. I double checked to make sure it's set to wrap, which it is. I tried merging two cells, no change.
I need the values that are copied from the template to copy over in text form from the "Data" Tab. Secondly, the master sheet has multiple lines for each vendor. For the area highlighted in red I'd like for it to copy all cells in column C for the vendor and search the vendor by name. Then, move to the next sheet.
I will post a rudimentary example: Account Name/Column A Truman school, San Diego Truman school, San Diego Truman school, San francisco Truman school, Atlanta Truman school, Atlanta
In column B, I would like it to assign a unique numeric id based on the TEXT only.
So Truman school, San Diego gets a string of numbers: 1234 Truman school, san fran: 1235 Truman school, Atlanta: 1236
My spreadsheet is about 6,000 records with a great deal of the above situation going on. So school names are identical with different locations assigned. I am trying to import to a database and don't want a lot of duplicate records. That's why I'm trying to assign a numeric value.
I have a problem that i don't know how to solve. I have one cell with values like this: 127;71;512;458;1250;722;2154;742;29;350;
and what to put in lines like this:
127 71 512 458
Has i have a lot of data in the cell and everyday it changes, i take several hours doing it manually. I have tried using the command data/ text in colluns but because i have huge data it leaves a lot out. Do you have any idea how to put that values in lines automatically?
I have a file with a bunch of columns in it. Columns C and D have names in them. I want to filter on these two columns where the results show all rows where the selected name is in both.
Example, If I filter on Column C first on 2 specific names (Joe and Chris), it will not show the results in column D if that name was aligned with a different name in column C (Mark and Steve). I need all rows to come back.
Column C Column D Joe Joe Chris Chris Joe Chris Joe Mark Joe Steve Chris
This is my formula and it returns: -55 bps. =[ASK.xls]QTR!$AT$81&" "&"bps"
However, I want it to return (55 bps). I don't want to just add the parenthesis because in the future this formula could return a positive number. I tried to format the cell differently, but that did not work.
I need to import thousand of txt files into 1 worksheet keeping the file names as data. Each txt file has 2 columns :
1 0.65914 2 0.65945 3 0.86062 ... ... and each txt file represents recordings made at specific time and date (e.g 0158.DSG_RAWD_HMS_21_ 0_ 0__DMY_29_ 2_12_pulses). I would like to have 2 columns: 1) with the time taken from the name of the txt file (e.g. 21:00:00) and 2) the associated recording. Something like this:
Having a hard time putting this one together..Trying to do: Create a formula that counts how many cells in Column L, that fall within a date range and also have a specific category of "text" (Column E). What I've tried:=COUNTIF($L$4:$L$166,"
I have two columns of data and cannot get the column to change the format to display as currenty or accounting, with a currency £ sign and comma separator...I select it all and go to Format cells to do the changes, but it does nothing, at all!
I have the below macro designed to display a message box if a cell in the range specified is greater than the value in the designated cell (BF7). In the message, I'd like to include the value for the cell in another column, from the same row as the cell that met the condition.
For example: Cell E11.........Cell BF11........Cell BF7 Mark....................1.......................0
What I want the message box to say: Mark worked too many days.
Lots of XLS files in a directory (C: emp). Each book has only a sheet1 with the data.
I have another workbook that i need to use to overwrite certain values in one column from each book.
The workbook I have has a column A and B, ID and value.
In each file inside the directory, A3 to last row used in A had each ID. If the id matches to an id in the workbook with the new values, I want to take the value from B in the override table and put it in C in the file. Look at each ID in each file against each ID in the override, replace and close.
I need to make sure that the two sets of data i have highlighted in yellow and blue are completely the same. Please can some one write a formula that will flag a cell next to the blue column indicating that there is a difference between that of the blue and the yellow columns individual row.
I'm trying to convert a very large list of phrases into one list of phrases in one column in excel.
The original list is separated by commas. I can get part of the list to show when I import they're coming up in hundreds of columns instead of one column with hundreds of rows. I want them to be listed horizontally, each phrase in a separate row but in one column. How do I do this? I would transpose from the columns into rows but it's cutting off the data when I import.
In my sheet I have a range on the go called 'cells_replen', I then need to search through the sheet and if a cell matching a given criteria is found I want to add it to the named range. The idea is that when I've done all the adding I can just select the range and then go back through the cells later on without searching for them all over again. The first code that declares the first cell I need in the range is:
I have come across a problem which delivers 0 as a result, I am doing sumifs which i never had a problem before with, however I am trying to include a cell which is variable by using the & in collating data, the raw file also contains that criteria in 1 column so I have no mismatch.
I've made a spreadsheet for tracking sales/profits and keeping a record of orders, I have made a table on one sheet listing customers, and I have a table on another sheet with a Customer column, with cells linked to the table of customers on the other sheet, The cells in the customer column are set to display a drop-list from the external customers table, but when I select a customer, all of the cell data that's pulled in, is written on one line, whereas it has line breaks on the customers list sheet,
Is there a way of getting the list value to display with line breaks, like on the sheet it pulls the values from?
I am needing to sort individual rows horizonally (by columns) - sound simply enough, but apparently its not (unless I'm overlooking something really basic). For example, I need to sort each row (2 - 300) beginning in column B and ending in column P individually. I can do this - one at a time - using Excel's sort function, but its time consuming and this is something I need to be able to do on a regular basis.
I have seen some code around that allows scrolling in listboxes using the mousewheel. I have also seen some code here on the forums about scrolling through a combobox embedded in a workbook. I have tried adapting both of these to suit a combobox on a userform but I cannot get either to work.
Here is the code that I used for the embedded combobox; I added it to the base code for the userform
I then added the following code to a standard module as stated in the forum post;
In the first section of the code there is a msgbox that never gets shown so I don't think code is recognizing the mouse wheel at all.
The second set of code that I used was set up to work with a listbox and it works perfectly with a listbox control. The problem is I cannot adapt it to suit a combobox and if I use a breakpoint to see what is happening Excel freezes. The following code is added to the userforms code;
Then in a standard module I added the following code;
I added this section of the code;
I think this should only work on a Combobox but a Combobox does not appear to support the TopIndex value. Is there a way this can be setup to work with a userform combobox? Sorry about the huge amount of code.
I'm trying to design a Profit and Loss template that calculates off an accounting software data dump. I will attempt to explain the problem here but I have included a summary in the linked workbook which would be easier.
DOWNLOAD WORKBOOK: [URL]
I have two problems:
The Formula: Basically, I need to calculate every cell in the Profit and Loss statement based on the below criteria: The Profit and Loss item accounts, e.g. Gross Income has 6 accounts. There is a reference table for these - so incorporate index match/vlookup? User selected data from 4 combo boxes.
I am thinking a SUMIFS formula (using the combo box values) and somehow combining a vlookup to pull the items accounts. I'm starting to think that VBA is the best method?
Tweaking: The attached workbook is a small example. The full data dump contains 60,000 rows.
Need a way to update a single master file. What happens right now is that the cost manager sends out one file to a lot of different project heads and then on having them return back to him he basically has to individually add in all the data. What i am trying to do is that he somehow carries on sending out the data as there are a lottt of projects and then on returning them they automatically update.
I have been using this macro to separate lots of rows with a certain amount of blank rows.
Code: Sub test() Dim j As Long, r As Range j = InputBox("type the number of rows to be insered") Set r = Range("A2")
I trying to change it so that, instead of inserting how ever many blank rows, it just copys the row above.
Example (Row A to C)
I have been messing around with macro recorder and i could select each row and paste it into the blank rows, but from researching on the internet selecting and pasting data seems to be a waste of resources (ram?) and i will be running this on a couple hundred rows (lots of data). Also, i would like to keep the functionality so that i can still choose how many times it copys/inserts each individual row from a input box.
I eventually want the data to end up like it is shown in the table but i am takin it one step at time because i want to understand what the code is doing.