I have some files on disk where I need to copy a part of the file name to make a search in our database. The files are PDF. They can have a long name of short. The only thing that does not change is the last part.
The last part ends like this:
1234_vw golf_Es_1234567_20140321.pdf
I'm interested in the part in red to be taken out and put in a cell to the right of the file name.
I used the below code that I found googling. Now I just to cut the part out in red to be able use it in my search in a easier way.
I have some values in column A which looks like those in table which is shown down bellow. I have somewhere in the middle of that column one empty cell. Of course i have empty cells after the last value. I want formulas or macro or anything which will cut that column in that empty cell and all cells bellow the empty one put in column B from A1, and all cells above the empty one put in column C from A1. I tried everything but i have problem because i dont know how to eliminate empty cells bellow the last cell with value.
I have a document needed to be printed with some pages in the middle in landscape page type, the rest in portrait. If using Word it would be easier, but in Excel I cant find the section break to chage page setup separately. Is there anyway to do it. Currently I'm printing the document separately in portrait and then landscape with some page break added and page number modified. However it's quite troublesome and easy to make mistake.
I have a spreadsheet with 2 worksheets. On the first "active parts" I have a list of active part numbers and on the second "All Parts" I have all of the parts available.
I want to compare every part in the All Parts worksheet to see if the part number exists on the Active Parts sheet - if it's there, I would like it to return the value "Active" in column B in All Parts. I have a formula in column B in All Parts that seems to work for the first few, but as soon as it finds one that is active, the rest of the cells below all return "Active".
I have sheets with names of people in columns....some married...some not. When they are married, here's a sample format...
Jones, Donald T | Baker, Sarah Jane | Jones, Sarah Jane | Smith, Sarah J | Jones, Sarah Jane Smith
In this example, I would like to be able to determine which of the Sarah's belongs to Donald w/o having to visually look at each record ( 100,000's of records). (FYI: the names for Sarah would/could be her Maiden Name and possibly a name or two from a former marriage). What I need to be able to do is match and extract the names of Jones, Donald T and Jones, Sarah Jane and Jones, Sarah Jane Smith and eliminate Smith, Sarah J and Baker, Sarah Jane.
In my example, Donald is in the first column, but can be in any column on a row so the name positions are random across the columns. However, the format for each column is then same...Last Name, First Name Middle Name(or Initial) with a comma always after the last name in each column. The length of the last name also varies.
VBA or Formula that will search the cells in the columns of each row and return the names (complete contents of the cells with matching last names) that have a matching last name for that row.
I have seen a worksheet/workbook in the past that only contains (for example) Columns A:H and Rows 1:150. The rest of the columns and rows do not show. Unfortunately I cannot find the example I was looking at and I cannot find any information on how to achieve it.
I've inherited this monster of a spreadsheet that is consistently being added to and updated. Everyweek a new column is added and data entered. When one row is done, it gets cut and pasted to the Inactive sheet; however, the problem I am encountering if that the rows all have different amounts of columns, depending on when they were added and how long the items were on the sheet.
For example:
A B C D E F G H I
[code]....
So when I go to move row 1, when it becomes inactive, to the Inactive sheet, I have 8 columns of data that I need to cut and paste to make it line up with that sheet, which goes monthly. Is there any way to automatically cut out the empty columns of data for each row so that it can be condensed, rather then going through each one?
I would like to do a find in a column for “yes,” and if it is True I want it to cut the row where it was found as well as the one above it to Sheet2. I need it to loop through the sheet appending to the ones that were found previously in Sheet2.
I am trying to develop a macro in excel that CUTS AND PASTES rows of data from one worksheet in to the next available row in a new worksheet if there is a date in a particular cell. If the cells that are being checked for a date are empty, then the routine would skip these rows of data.
Here is an example of the worksheet. All rows containing a date in the Scanned column, would be cut and pasted in to a new worksheet. And any rows that have an empty cell in the Scanned column are ignored. If the Scanned column is filled at a later date, then when the macro is run, the data in that row would be cut and pasted in to the next available row in the new worksheet.
I've set up a spreadsheet structure at work which is three workbooks linked together.
I created this initially within My documents saved locally to my machine. Now though, I need to move the folder containing these workbooks onto the server to be accessed by others. My problem is that when cutting and pasting the folder, the formulas within the three spreadsheets still refer to their original location within My Documents rather than following the folder to their new location.
I'm pulling data from my servers (alarms) and have roughly 10 alarm points, reporting 9000 alarms. I've been able to pull them off the server on an excel file, have been able to sort them, but would like to venture into the hope that there is some sort of formula that would take the duplicate alarms(cell a1-a9000), delete them, and report how many duplicates were removed from the list in cell b1-b10
xyz xyz xyz xyz 123 123 zzz
---
somehow it could be turned into "xyz 4" "123 2" "zzz 1"
AS you can see in the attached file, I have several collumns of data going form 2012 to 1992. I would like to know the quickest way to invert this so the data is presented 1992 to 2012.
I am trying to cut all rows with the date less than 2 days older than the current date. Cut and paste it into a new worksheet in same workbook and save it into a specific folder.
[Code] ....
I am getting an error on the line :
[Code] .....
Saying Object doesn't support this property or method.
I am baffled because one worksheet I can cut/paste and none of the reference cells whether they are dependents or precedents change--in other words, all formulas remain exactly the same. I switch over to another tab in my back-end and the formulas change when cutting/pasting cells.
In column A I have the age of a sale i have completed (compared against todays date) and from B - N of the same row i have the data that coresponds to the sale. As Column A changes daily by 1 i would like to only keep the rows whereby column A is between 1 - 10. For any that are above 10 I would like to cut and paste to a second sheet, strangely entitled "older than 10 days" !
as there are formulas after column N which calculates the data i would only like to cut columns B - N of the specific row.
I think I need to create a macro that first sorts column A so I have the oldest data at the top and then a loop to check if these are above 10, i then want to cut from B - N and paste into another sheet.
I have to look through an entire table and find certain criteria (eg. "STEVE'S PIZZA SHOP"). It might be in columns G or H, or it could also be in Columns C or something of that nature. What I'd like to do is search through the table, find each instance of said criteria and cut each row the criteria apperas in to a different sheet. I'd like to do this as a macro, so I can set it up for other criteria as well. In addition, if I can include in the macro a way to create a header row (which I'm pretty confident I can myself), as well as change the title of the sheet the information is moved to. I have looked up Do-While loops, For-Next loops, If-Then loops. I am at a total loss.
i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.
I am trying to auto-populate text in cells in area A, based on data I enter into other cells in area B. I want the area A cells to be for display only, as all editing will be done in area B. The problem is: how do I do this such that the text I write does not get cut off if is longer than the column width? See the attached document for a clear example and description of what I am trying to do...
I have an Excel 2007 workbook with several sheets, and various cells in several of the sheets have column headers with a description in the same cell enclosed in curly brackets, e.g. Header{Description}. I would like to to keep the column headers in their respective cells, but move (cut) the descriptions along with the brackets to the respective cell comments.
code to take jobs that are done on one spreadsheet and send them to the next available row of a specified range on another worksheet. I am also looking to incorporate a way to delete the empty rows that are left behind.
I have already made code to select the completed jobs, but am still unsure how to approach the next part. I can't even paste the selected range to another sheet without errors from range sizes.
The following code is done up to the point where I cut my selection.
Sub Update() Worksheets("OpenGen").Activate Dim c As Object Dim rngA As Range
I'm making a project where there's a list of skills and next to each skill is a cell where the user can put how many skill points are in that particular skill. Now, on a separate worksheet is the place where it shows the consolidation of what skills they know, and how many points are in each. My question is, how can I copy over these skills and how many ranks are in each, without copying over the skills in which they put no points.
I am going to use Excel sheets as computer exam forms. What I need to know is: Is there a way of protecting parts of an excel worksheet from alteration? I want a sheet that will accept answers in specific areas only, and will not accept entries or alterations in other areas.
Does anyone know of a way to select fragments of the following text?
The string is "toby.cameron1".
I need to be able to select just the "toby" and "cameron" parts. Also this string is variable in that it might be "james.brown" or similar without the number at the end.
I can't use a Left or Right statement because of the varying length of names and the uncertainty of having a number at the end.
Is there a way I can copy the start of the string until the period. And do the same from the end but ignore the number whether it's present or not.
From that, is there anyway to copy the numbers off the end of a string?
i.e. my string is ASY-623 or DRGN-12 or WDSR-7
The string will always be letters a dash and then numbers.
