I receive spreadsheets with data sorted by column. There might be 500-600 records in approximately 1-8 categories, 14 columns wide. One column is used for the category. I would like to copy or move the data in each category to a new sheet within the file, so I can work with each category separately. I do this manually now, and have to do it multiple times for each file, as the data changes daily.
The category names are rarely the same from one batch to the next, so the routine will have to look at the categories and understand their names in order to put the data on a new sheet. Category names are alpha-numeric, like RA114, RC109.
This seems like a VB app, but I don't know VB! Is there a way to do this without VB? If not, is there a well-documented VB template or utility I might use to modify?
i am trying to get a vba procdeure to copy Sheet "Template" and move to the end, but when i run the code, the code copies the template but does not move to the end, how can the below be modifed?
Sub Macro3() Sheets("Template").Select Sheets("Template").Copy Before:=Sheets(6) End Sub
I have the following code to move/copy worksheet and then copy and paste special values. Is it possible during this process to get the user to change the 'moved' worksheet name ?
I am trying to use a conditional macro to move data around in a spreadsheet. Is there a way to use an IF AND conditional statement in a macro? As an example:
Range Select ("M3")
' THIS IS THE LINE I AM HAVING A PROBLEM WITH If Selection("M3").Select And Selection("N3").Select = "1" Then
In the attachment you will see an example of what I am trying to accomplish. What I am trying to do is find VBA code that will move data by date from an (Entry) sheet to a (Historical) sheet. I want to enter a date in B3 on the (Entry) sheet. I then enter data into C3. What I would like to happen is when the data is entered into C3 the sheet goes and finds the same date that I entered in B3 and copies that data from C3 into Column E of the (Historical) sheet.
Sheet 2, Row 1 column B-E contain restraurant names (only on the top row, like field names).. i.e. I manually put the date in because typically the projected date is different from the actual review date.
-A----------- B ----------------C ------D-------- E----- Date |Ruby Tuesdays|Olive Garden|TGIF|Ruths Chris|
I need the data from Sheet 1 Column B moved to sheet 2 in the next open row (i currently have data in row 1..the field names and down to row 35). This will be continuous so each time i need it to add the score as a new row in the correct field (restaurant name), IF the restaurant isnt listed, I want a new field named with the restaurant name and then place the score in the correct row and column. So, in the example I'd need Outback added.
I am working on a project and would like to see if there is a solution for it. i have a workbook that has data entry that is summarized at a master level but I need to automatically use a formula to update another sheet after clicking an udpate button. The data from the data entry sheet needs to be allocated to all the lines that has the same master item based on the formula. A test workbook is attached ...
I have an excel spreadsheet,I have a problem and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|98|99|, which can be found on the columns A, B, C, D, E, F, G, H, I, and I want for example to extract all values that begin with the number 1 ,and to put all the values in the worksheet 2 columns A, B, C, D, E, F, G, H, I,,
For example 1|2|3|4|5|6|7| ,,,,,, up to 1|94|95|96|97|98|99| moved in sheet2 from sheet1.
I tried to extract the filter from the data tab .... sort and filter,,, filter,,,, filter by number,,,, starting with,,,, we apply the filter, but when we selected data values and take that were among the selected what was not good.
In these columns I want to extract all values that begin with nr1 .....1|2|3|4|5|6|7|,,,1|90|91|92|93|94|95| from sheet1 in the sheet2, I mean these...
column A 1|2|3|4|5|6|7| ,1|2|3|4|52|69|78| ,1|22|33|44|50|63|75| ,1|20|31|43|55|60|71| column B 1|2|3|4|5|6|23| , 1|2|3|4|5|6|8| , 1|2|3|4|5|6|9| , 1|2|3|4|5|6|10| ,1|12|13|24|51|60|77| column C 1|2|3|4|50|65|70| , 1|94|95|96|97|98|99|
I would like to copy or move data from one worksheet to another automatically. I have one sheet (Data) with multiple pieces of data for specific individuals. I have several other sheets titled their last name. Can data for example from John Doe be copied to the sheet Doe and data for John Smith be copied to sheet Smith. In essence I would like the sheet to paste everything below John Doe to Doe's sheet and recognize the next name and past that into the next sheet and so on. It may be several different codes, Im ok with that.
One other item all cells do not have data I do need the blank cells copied as well at to not lose the formatting. There is also a blank 2 rows between each person.
If you need a copy of what the data looks like I can send it.
Is it possible to create a cell in one sheet, where after data is entered, will move it to another sheet. Additionally, the data in the cell, after the transfer to another sheet is made would delete itself. Once the data is entered, sent to another sheet and deleted, next time data is entered into the same cell, it would be sent into a row below the cell that the first piece of data would be in. Therefore, after I enter data, [for example] press enter, then go back to input some more data, after a while there would be a long list in another sheet. The last feature of the problem (it would be something extra really) is that the function/macro is to be time dependent - during one month the data would stack up in one column, after the next one begins, the next column will automatically start all over.
The idea is to create a budget book - where on the main page I would only have to enter the value in a specific box, the value then would be automatically sorted into the right row and column in another sheet, after the month/week ends, data would start to stack up in a column devoted to a new month/week.
Of course the data could be entered manually in different sheets, but it proved to be too complex to be useful.
So I have a sheet that has 9 columns A - I sheet is called "Door Switch Times"
Basicall when column F gets data in it I need then a macro to automatically Copy B, C, D to a new sheet called "Main". I need B to be copied to C on Main, "C" on Door Switch Timse to be copied to "D" on main and "D" on Door Switch Times to be copied to "E" on Main. I cant post the sheet as my work computer will not allow me to transfer or share files.
I've got a workbook with a sheet named Data that has the information laid out in a single row. The data can't be fit onto a single sheet for printing / viewing so I've got a second sheet named Presentation that the data get's laid out to 2 rows so that it can be viewed / printed on a single page.
I'm handing this off to non-technical people so I need an easy way to populate the presentation sheet with the data. I've layed the data out using =Data!A1 however, the drag auto-fill doesn't properly fill it down since it's single row to double row.
I have Excel 2003. I need a formula that will automatically move data in a row to another sheet, in the same workbook, based on either a two digit department code or possibly a date. I enter information on a master sheet, (8 columns of data: Text/$/digits) and I need that information to separate out to the other sheets when that department's two digit number is entered on this sheet. There are a total of 6 sheets in this workbook, counting the master. The data I am entering will be about 40-50 rows down of information, 8 columns across. Will this take a macro? Loop?
I've been working on a spreadsheet for the past 12 hours on a sunday when I should be home eating or something (damn projects).
Basically, what I need to do via a button on 1 sheet, is select all rows of data that have a certain variable in a fixed column. E.g. "CLOSED" in Column AV for example.
Then I need to CUT all of those rows out, and paste them into a worksheet with the exact same column layout, under the last used row.
r = 6 For i = Selection.Rows.Count + 1 To 1 Step -1 If Worksheets("Live"). Range("AU" & i).Value = "Closed" Then Worksheets("Live").Range("AU" & i).EntireRow.Copy Sheets("Closed").Cells(r, 1) Worksheets("Live").Range("AU" & i).EntireRow.Delete r = r + 1 End If Next i
I dont know whats goign wrong here. Its not doing anything! As far as i understand the code above, its doing the following:
Sets the loop to increment in steps of 1 Searchs the range AU1 for "Closed"
If the value is "Closed", copy the row, and paste it into the sheet called "Closed" in the cell: 6,1.
find attached my workbook. I need an easy way to move each football teams last six matches to there relevant named sheet ie Bury in this example. The database sheet gets updated weekly so I would need some way for this info to automatically update. At the moment I sort each team one by one and copy and paste the last 6 matches, I am sure there is a better way?
I have a large spreadsheet which I have extracted the data I need, but I am now having a problem tiding it up.
To simplify. I have 2 columns, both containing data formatted as text, each column has some data, but on different rows.
I need to merge the 2 columns without overwriting the data on the second column, with blank data from the first column, and without the column shrinking or growing.
Here is a section of my spreadsheet that needs merging : Excel-1.PNG
I have tried copy > Paste Special > Skip Blanks, but it just copies the column to the other - no merging.
I have a simple sheet with a list of costs (small version attacheds as there are 430 items on full list) when i enter "Y" in the move to invoice column I would like the description, multiple and cost details copied to invoice sheet. The added complication for me is that if for example when there is a requirement for multiples of that cost to be added to the invoice.
I have a sheet called 'TimeRecorded' which will contain lots of rows of data.
If a row contains 'invoice' in column H, then the data in that row, preferably as far as column H, should be moved to the next blank row in a sheet called 'Archived'.
I would like the macro to move every row that contains 'Invoice' in column H to be moved.
I have a DATA sheet that is all of the information reported on a monthly basis. This format will never change, but the data will. I have a second sheet called MMUSAGE.
On the MMUSAGE tab, I have identified which headers (in red) from the DATA tab that correspond with the headers in the MMUSAGE tab. Question is: how do I move the data from the DATA tab over to the MMUSAGE tab under the appropriate headers?
Example: IF Product Number on Worksheet(DATA) = Product Code on Worksheet(MMUSAGE) then move all data to Column L.
Firstly a confession - I've sinned - I got the code below while searchin the forum and in my excitement, I forgot to get the thread details - so I'm sorry!! So the credit for the code to a forum admin:
I have only recently started to learn VBA and have been putting it to practice in creating userforms to help people at my work to be able to timetable more quickly.
I have realised however that in many cases the basic code that I have been using could often be improved. However in the sections below I have not been able to work this out for myself. This needs to be done as after a large number of worksheets exists excel gradually gets slower and slower when running the macros.
I publish a green building mag, and we run an enquiry system for readers on our website. This is the link: [URL] .......
The idea is that readers tell us some info about themselves, including what types of products/services they'd like to receive information about, and we pass their details on to advertisers offering those products/services.
When someone fills out a form, we get data in Excel on their enquiry. It's all in one row - name, contact details, and then the products/services they've enquired about are included in one cell, separated by commas.
So for instance, suppose a listing currently came in as follows (column headings in brackets:
(name) Joe Soap / (job title) Architect / (organisation) Joe Soap Architecture / (address) 123 Soap St, Soapville / (enquiries) insulation, solar panels, windows
Essentially I want it to run like this:
(name) Joe Soap / (job title) Architect / (organisation) Joe Soap Architecture / (address) 123 Soap St, Soapville / (enquiries) insulation (name) Joe Soap / (job title) Architect / (organisation) Joe Soap Architecture / (address) 123 Soap St, Soapville / (enquiries) solar panels (name) Joe Soap / (job title) Architect / (organisation) Joe Soap Architecture / (address) 123 Soap St, Soapville / (enquiries) windows
I have a worksheet that has time clock information. I also have a resource on the web to see some information and even export it. In the exported data it looks as follows:
A1 contains an individuals name B1 says times i.e. "8am to 5pm"
I would like a macro that takes the data from A1 and moves it to another worksheet in the B4 position down, and take the times from B1 and move the first time to the C4 position and the last time to H4.
situation: 3 rows of data, row 1 has HDR in several cells (always in A1).
task
1. search row one for next example of cell containing HDR, excluding cell A1. 2. IF found, create a new worksheet and move all data below and/or to the right of that cell to the new sheet. 3. Repeat steps two and three until the search does not turn up another HDR except in A1.
I have had several intro programming classes, but not with visual basic. I've noted the problem lines with comments below. The problems are probably very easy syntax error.
Sub list()
Dim counter As Integer Dim counter2 As Integer Dim id As Double Dim id2 As Double Dim palletnum As Integer
Let`s assume that I have numerous "Serial Number" in "Sheet1" : http://i40.tinypic.com/2iqbspt.jpg
Now I want to create some cards in "Sheet2" that each card have a serial number that related serial number there is in "Sheet1" : http://i43.tinypic.com/34fz690.jpg. Need easy solution for doing it while when I drag one card to copying it then related serial number in sheet1 would be appear in required field. I mean first card has first serial number of sheet1 and second card has second serial number of sheet 1 ; but I want to doing it quickly with dragging.
I have two different Excel reports and the data needs to be copied from each column on one spreadsheet and pasted to the bottom of the equivalent column on the other spreadsheet.
So, is it possible to get a macro that will copy the data from one column then paste it to the next free cell in the column on the other spreadsheet.
If I could get some code to do one column then this should be enough to get me started and I could apply this to the other columns I need to copy.
I have a number of worksheets and need to move data from the same cells of each work sheet to a summary worksheet. I manually entered the cell id's for the first sheet.
Example =Jan!M6, =Jan!N7, =Jan!O9 etc.
I know I should be able to automatically enter these same cells for the remainder of my worksheets with out manually going in and typing each one (there are a lot of entries.) I just can not remember how to do it. The next sheet is named "Feb" and "Mar" etc.
I want to be able to copy a name from one sheet (Available Players), paste it to a cell in another sheet (Round 1 through Round 20). The cell that will be copied is fixed but the place where it will be pasted will be different and may be on a different sheet.
also i would like to change the color of the copied cell to "greyed" out or cut if it can not be greyed out. I have created a button and put in a macro that i created but have been having problems with it, generic 1004 errors that i can not figure out. i am attaching the document.
I have attached a 97-2003 .xls file with data for multiple store locations on sheet 1, and the desired result on sheet 2. I am actually using excel 2007, but I dont think I need any special features that it provides.
I will try to explain the issue here without opening the attachment.
