My main sheet has the results of a competition in rows 1-100. 75% of the results won't count for the jumpoff ( its a horsey competition) and I want to automatically copy the successful details to another sheet. I've worked out how to to omit the unsuccessful results by using an IF statement ( IF cellx is > x then copy ) but I still end up with 100 rows - with 25 results and 75 blank rows. How can I copy but compact it down to 25 rows.
As a second question I need to sort the results. I know how to do a manual sort & I even worked out a macro so one keystroke can do the sort. It woruld be better if the sort would be automatic whenever there is a change in the scores.
I have a file of users and security codes. each user should have at least one security code. How can I get rid of all the good combinations and only leave the bad ones?
Example: user: joe blo security code = 1 user: jim white security code = 1 user: sam song security code=5 user: jo jo user: billy boy security code=1
You can see Jo Jo does not have a security row. I need to the good ones to be removed so only the user with the missing security code is left:
Does anyone know why, when I copy a Worksheet (right click Worksheet > Move or Copy > Create a copy), Excel occasionally fails to copy across the embedded objects contained within the Worksheet (e.g. Charts, Command Buttons, etc.)?
This is very frustrating, and I'm wondering whether it's the way my Worksheet is configured, or whether this is a known bug.
I want to copy the current region on sheet 3 and paste that into sheet2 starting with cell E4. But I don't want to actually use the copy method. I believe there is a way to do this. I was thinking the following:
[Code] ......
The idea I had was to simply state that cell E4 would be assigned the value of CurrentRegion on sheet 3. Is there a way to bypass the copy method?
I want to do a loop where you can copy say A3 worksheet 1 then add another sheet naming the work sheet "A3" then copying A3 worksheet 1 to A1 "A3". After that looping to A4 to a new work sheet naming the work sheet "A4"copying the value to A1 "A4", etc...
Is there a simply way of doing this loop? I can probably fit my other coding into the structure.
I am pulling my hair out trying to figure this out. Any help at all is greatly appreciated. I created a spreadsheet for a friend to track his profit/loss for his business; he is not very computer literate so I created separate tabs for each month. I have no idea what he did but the horizontal scroll bar and all of the tabs are not visible, he is using excel 2000 on windows XP. Unfortunately we are not in the same area so I can’t go look at his screen. When he emailed the file back to me and I opened it, it looks fine. Also when he opens any other file it does the same thing. I have gone through all of the obvious causes, everything is correct in the tools, options.
I have a sheet which contain an horizontal split (Option Windows/Split). I have selected the row 16 to split the sheet so that I can have a header when I scroll down. However, when I print this data sheet, the first row, at the top of the screen, is missing. In the preview and on the printed sheets, the first row is missing on the next printed pages. In the first page, all is ok, but not on the next ones. Does someone have an idea why Excel is behaving like that?
I have a summary file in which I capture data from multiple sheets in one existing file (targetfile.xls).
One month might contain sheets that do not exist next month. When updating (edit) links, Excel reports an error (invalid external reference) on the first missing sheet, and does not continue checking/updating links for the rest of the document.
I tried =IF(ISERROR( SUM('[targetfile.xls]sheet1'!$M:$M)),0,SUM('[[targetfile.xls]sheet1'!$M:$M)),
I have two columns which i want to compare, they contain text data such as A123.
what I'd like is if its in column A and not in Column B then add to bottom of column A.
Once its in column A i can do the vlookup's to draw the other data, costs etc, over but don't know how to identify, and add, the missing codes to the list.
On occasion I cut a table from a website and paste into Excel. If/when that data is subsequently deleted from the sheet the gridlines no longer show. I've tried turning the gridlines on and off to know affect. I've tried setting and clearing borders, but that made no different to the gridlines either. Even if I highlight the entire sheet and delete it makes no difference. I can't think of anything else to try.
I am using Excel to generate a CSV file to load into a industrial cutting machine. The CSV file is used to import the cut list. As such formatting and the data per cell in Excel is important.
What I am presently trying to do is input the dimensions and type of the overall part and have the individual pieces be generated in a second sheet. I can presently do something of the sort using extensive 'if' statements. The problem with this is that I can only generate one line for every line I enter.
So this leads to what my problem is. I want to be able to have the info on 'Row one' 'sheet one' generate its parts list (which maybe 1-3 rows) and post that to sheet 2. Then 'row two' 'sheet one' generate it's info, but place it into the next unused row on sheet two. One of the issues I am having is that each row on sheet one may need to generate between 1-4 lines, maybe more, and I don't know how to not overwrite or have gaps on sheet 2.
Am I looking at going into macros or learning VBA?
I have workbook that has several sheets within the workbook that are set up identical. Each of the sheets in the workbook are for a specific company.
As of right now I have been adding a sheet to the workbook that is an overview for what is in each sheet (the individual companies). Currently I am doing the formatting of the heading and column names manually and I pull the data from each sheet with a VLookup. I have been trying to enhance my VBA skills with coding something that will fill in the appropriate cells from worksheet to worksheet.
What I am trying to do is to populate an overview sheet with cells C24, C25, and B36 being static on each row per sheet. Then each row will be populated with cells C(36, 59, 70, 81), D(36, 59, 70, 81), F(36, 59, 70, 81), G, and H(36, 59, 70, 81). The overview sheet will have the diagram below in a ru
I am copying a large sheet into a spread sheet. The problem is one of the columns contain numbers with some cells having an asterisk at the end of the number. This causes problems with the formulas on other sheets that use this data. Can I use a formula or what is the best way to eliminate the "*".
I have a userform which clones the latest sheet and produces copy of it on the next sheet. The first sheet they will be cloning is the sheet called 'template', I however want this to be hidden since I do not want anybody to modify a sheet which basically serves purpose of a template. And once cloned, it is no longer needed.
On the click of the command button, the macro will create sheet1 taking the info from sheet named 'Template' in the same workbook . And now on the next click of the command button, Sheet 2 is created taking the info from sheet1 and Sheet 3 is created taking the info from Sheet 2 and so on. Here is what I currently have, so how can i modify it in order for my scnerio to work?
I have a couple of spreadsheets that requires me to copy data from Sheet 1 that matches certain criteria to Sheet 2.
I have tried using posted VB codes that have been written for other people but they dont seem to work (this is probably to do with me not actually knowing what I am doing, as I am not sure what I should be replacing and what I need to be deleting etc out of the pre-written code )
I need to be able to search on column e in Sheet 1 for anything that has just h written in the cell and then copy all the rows that match into Sheet 2. I also would like to ensure that when it is copied it doesnt go in row 2 but maybe 4 or 5 as I have quite allot of headings.
I've seen some examples here and I think I understand the consolidation function. However, my query has the added level of needing to consolidate each member:
I have a table of data that looks like this:
SURNAME NINO CODE NO OF UNITS
Smith AB123456C 8AIA 1986.4805
[Code] .........
There are a number of clients that have multiple investments that are shown by an alpha numeric code. I need to consolidate the number of units for each member in to one line. Ideally the output would look like this:
I have a source sheet which contains data. Within this data there is a column (column 3) called Name and I would like to take the data from this sheet and paste it onto a new sheet but in grouped format. So take all instances where it finds criteria 1, then 2 and so on and just paste it on a new line each time it finds a criteria. So far I have the following code to search
Sub loopy() Dim rngTemp As Range ' the range variable declaration Dim intCounter As Integer 'counter as integer ' the following loop goes through all the cells in column a up until the last used cell in the column For Each rngTemp In Range("a1", Range("a" & Rows.Count).End(xlUp)) 'increment the counter if the cell has value fridge If rngTemp = "Fridge" Then intCounter = intCounter + 1 Next rngTemp MsgBox "There were " & intCounter & " cells equal to Fridge" End Sub
I have a file that has simple stats for multiple days. At the end of each day is a "Summary" line. I can't figure out how to find the lines that have the word Summary in them and copy all the values in that line to another sheet. I've made a mock up of my data. I have minimal experience with Macros, but am learning quickly.
I have a workbook, "Assessment District" with 3 worksheets. In worksheet "Original," I have 252 rows with columns A-V. I want to copy two coloumns "C" (range 6-252) and "N" (range 6-252) from the worksheet, "Original" into a new worksheet titled "Send" in columns A & B. I only want to copy the two columns "C" and "N" for each row, if column Q does not contain "beach town" or "freeway."
For example, row 6 contains beach town, so I wouldn't copy C6 and N6 onto "Send," but row 100 doesn't contain beach town or freeway, so I would copy C100 and N100 into "Send."
This is a workbook that would be updated annually.
I'm not skilled in VBA at all, but want to impress my supervisor where I'm interning.
I have a separate sheet that I will drop a csv file into. On another sheet, I would like to copy that data. I know how to copy a cell and drag it to collect all the cells for the first go around, and this would work great if only my csv file had the same amount of rows each time, which it doesn't.
Is there anyway to create a macro to copy a dynamic range of rows from another sheet?
what I need, but can't seem to string anything together for the final product. What I want to do is search one sheet, in column BQ, for the word Complete. If a cell has that word in it, I want to copy that row, paste it into another sheet, and than go back and delete that row, and continue the search until all rows have been searched. Is there a simple way to do this?
I was thinking of an auto filter, but I'm not sure it'd work how I want it based off of what I've read.
