As of right now these are the steps i do to sort...i click custom sort choose My data has headers and then i select from the drop down list the word FRNAME.
is there any way i can setup a macro to do this for me? i tried recording the macro but it just is recording me choosing the column FRNAME is in. This does not work for me since FRNAME end up being in different columns all the time but will always be in row 1.
So, I have two columns on a sheet that all contain drop down boxes for various information. We'll refer to them as column 1 and column 2.
In column 3, I want to have the highest instances of those words sorted with the highest on top, and downward from there, along with the number of times it appears in either column 1 or 2. (And I want the sorting to be dynamic, i.e. when I change what's in column 1 or 2, it will re-rank them according to highest number)
i.e.
Column1 Column2 Column3 (Column4-#) Bob Tom Bob 5 Joe Bob Tom 2 Bob Joe 1 Tom Bob Bob
I have the drop downs and what not for the 1st 2 columns, I just need to know how to make 3 & 4 happen.
I would like to use a vba procedure/procedures to achieve the following: I have a folder with many Word2003 forms in and I want to save just the data from each form and then import the data into an Excel spreadsheet.
Currently I am opening each .doc file in turn, saving just the data to a new plain text (comma separated file) in a different folder and am unable code searching that folder for all the text files and importing them into the spreadsheet. I have a two part question to my current approach:
1) I am 99% there with the first part (opening and converting the forms) with the following code having followed advice from another thread but I need Word open and not showing an open document. Is it possible to add code to take care of opening Word in the background and close it again after so the process is fully automated?:
How to write a code to import all tables from a single word document into a single excel sheet? (we don't know exactly how many tables there will be,or how many rows in a table there will be , but the columns are certain, which is 9, from A to I.
I am trying to find a way to sort a string of numbers within a cell in numerical order as they are entered,regardless in what order they are entered. Example 123,45,478,12 entered cell, and want it to sort in numerical order as it gets entered in the cell...12,45,123,478,4564
I have a spreadsheet with multiple columns. The first column defines a "route", and the next two list "start" and "end" cities for that route. The fourth column lists the length of each route. There are only a limited number of cities, so the same entries appear in both "start" and "end" several times. I would like to use Autofilter to sort the list for every appearance of a given entry in either "start" or "end". Is there a way to make Autofilter sort mutiple columns simultaneously?
I could achieve the desired end result with Advanced Filter, but I want something with the ease-of-use and immediate update/response of Autofilter. Advanced Filter requires explanation (as well as lots of clicking and typing) whereas Autofilter is self-evident. I also want to avoid VBA Macros as they are not well-understood by the users who will use this spreadsheet (and any VBA Macro will require very specific input to work properly.) Is it possible to do what I want? Or is Advanced Filter / VBA the only way to do it?
I have an excel program that is supposed to count word instances in a word document. I can't seem to find the right declaration for a word document. For example to declare a workbook in excel its
Dim wb As Work Book
I've tried
Dim doc As Word.Document 'or Dim doc As Word.Application
as shown in some of the forum posts, but an error user-type not defined keeps displaying.
I'm looking for a way to sort dates from several columns into a new single column (perhaps multiple columns if the entry columns become too numerous). I've included an example. There are currently only 4 columns, but there may be as many as 20 in the future, each with 20 dates under each heading. Any blank cells would be eliminated. If I filled a blank with a new date, that date would be placed into the chronological column. So basically, this would take the date from several different categories and create a single calendar of events.
I have data on 400 rows. Each row has a maximum of 10 cells with data, but many have empty cells with no data. I would like to sort each row to show values of cells in sequence and eliminate empty cells. I can use the sort row function but its a long process for 400 individual rows. Is there an easier way?
I have a spradsheet that I've formatted using merged cells. The spreadsheet has several columns. Into these columns I must enter raw data extracted from our SAP data base. The extraction worksheet has no merged cells. So bottom line, I have a column of say, 30 non-merged cells and I want to paste that column into my formatted spreadsheet that has 30 merged cells of thre cells a piece (90 cells total).
So far I have been unable to do this. If I've attached it correctly, the sample attached
i've put this previously on here with no results. There is a formula already in there though does not work because what I want to achieve is to have Column A & Column C to Match Column E & Column F, to Return the Value YES or NO. I’ve Highlighted in ROW 947 one that should Say NO yet Says YES.
I am setting up a charity accounts sheet, that will also calculate money raised from Raffles, so each raffle will have a name, I can do this by matching the amount with a description but wondered if I could calculate it by looking for specific words or reference in a cell
Sum all cells that the adjacent cell contains the reference "Raffle 0001" but not "Raffle 0002" this needs to be calculated on another cell
Sum all cells that the adjacent cell contains the reference "Rescue" this cell could contain other text as well, so could say "Rescue for Sweetie by Laura Herarty" or "Rescue for Bliss by Jane Telford" all need to be calculated.
I have hundreds of lines with unique tasks in each cell. I wanted to add 'P&C- ' to the front of each task and do not want to go through and add individually as it will take take.
Is there anything that can place in one cell and just drag to the last cell and complete?
E.g.
Current Cell: Task A What I need: P&C- Task A
I cannot add attachments as my work seems to have a restriction on doing it and always asks for admin password
In cell A1 I would like to have a formula that indicates the number of times the word "Yellow Pages" appears in cells C10:C1000. The C column inidicates a referral source. So some of the cells will have "Yellow Pages" and some wont. In cell A1 I would like to have it tell me the total # of referrals from the lead source "Yellow Pages".
My goal is to separate the first world from the rest of the words in one cell.
Since all of the words are seperated by space, I use the the "Text to Columns" function and separate the words, so that I can get the first word into one column. The rest of the words have to be merged again through "Concatenate".
What I'm looking for is a VBA code or Excel function that can identify the first world (which vary in character lengths) and put it into one column.
I would like to do a text split for the name only in cells where contains the word "Name". For example: Name A&A Enterprize
Text split function for it is =MID(A1,FIND(" ",A1)+1,255) so it only recognizes A&A Enterprize.
How would I add an IF, Then function (If the any cell contains the word Name, apply the text split function, for cells don't have the word Name, just leave it blank) if i have to do this for a large data file so i dont have to copy this function for every cell that contains the word Name.
I need a macro code that will edit cells containing links similar to this one "[URL]..." by adding "/current" at the end of them. There shouldn't be any space in between. There are over a thousand of them, and I think this would save me time,
I have a range of cells that contain numbers. In column a, row 3 is where the numbers start and they populate over to column f. I normally have 7 or 8 rows of numbers but this can change. The last row in the first cell has the word 'analysis' I need to copy each row, columns a to f, until I hit the word 'analysis' in the cell which will be in column a. I then need to paste these cells data into another sheet.
I am trying to figure out a formula which will search the contents of 6 cells (o2, p2, q2,r2,s2,t2) for the word "sugar". If it is found in either of these cells, I would like the formula to result in "true" or "yes", if not, "false" or"no" would be the result.
Cells (o2, p2, q2,r2,s2,t2) contain text which can include the word "sugar" but will never contain only the word sugar.
