This report spreadsheet is exported from SAP. Since SAP has a limit number of displaying the columns, there are 40 headings (= 40 columns) in the report has been broken down to 4 rows of headings.
How to use macros to move 3 those extra rows to one row and the number still matches each column? I also attatch the file for reference.
is to display a set of data based on filtered information.
My Data base:
Company Department Name
A X John
A Y Joe
A X Jane
B Y Bob
C Z Kate
A X Kerri
Based on user selection of Company and Department, I want to be able to display the relavent names.
If user chose Company A, and Department X, I want to be able to display
John
Jane
Kerri
I've used the ROWS, Index, Small combination that works perfectly (Please see sample below). However, since the this software doesn't support the ROWS function, and doesn't support Macros.
I'm new to Macros and below is my requirement.I need to split my data into multiple rows based on count and the first row should have the value but the other rows should have a value as zero.
Input
Count Value
1 400
2 101
3 300
4 450
Output
Count Value
1 400
2 101
20
3 300
3 0
3 0
4 450
4 0
4 0
4 0
I'm working in Excel 2007 and need to move data from multiple rows to a single row if the ID matches.Below is sample data I would be working with. I want to move data from columns F-U to the right of the original data in the row above it. I would also like to delete the rows that had data moved.
GIDSurnameNameEmployee Number OriginalDate of birthGranting ARE
Employing ARECountry Employing ARECHCM Supplier IDVehicle
Investmt. shares / Awards at termination dateMatching Shares
at termination dateTermination
[Code]....
i could do with:
move data up a row if row above is empty
move data left if column before data is empty
tia
add your top 10 if you like
I have a worksheet in which I have sorted the data based in date and numbering (column I and E). I would like to create 2 macros for following actions:
1- all rows with the value "TOM" in column C will have to be deleted.
2- all rows with a value of 601 or 602 in column E, will have to be moved to the bottom of the sheet after the last row with data. The rows that have been moved will have to be sorted based in date (column I) and numbering (column E).
I've got an excel file with over 20,000 rows with Column A being having values of a "Vendor Number" while Column B has a "Vendor Name" Here is an example:
Vendor #Vendor Name
1001ABC Supply
1002Larry, Moe, Curly Inc
1003John Smith
1004Fred, Wilma, Barney LLC
I'd like it to find the rows where the Vendor Name has a comma present, and then put it in another sheet, or in another column like column C and D. If I can't get both the Vendor # and Vendor Name re-inserted someplace, that is OK. The Vendor Name is the big one.
I have 3 columns and 200 rows. The first column is for Name of product. 2nd column for number and 3rd for $value of number of products. Have 200 rows. Have done a sort and checked. 2 sets of rows are for the same product name. I want to know if it is possible to add up values in 2nd and 3rd column, 2 rows at a time , then 4th and 5th column and so forth, by some formula rather than doing it manually?
View 4 Replies View RelatedI have an excel workbook with 8 worksheets. Each worksheet has vertical columns (approx 250 columns per sheet) of numeric data. Is there a function or macro that will combine all of this data into one vertical column without having to individually cut and paste each one into the new column?
View 3 Replies View RelatedI have few columns, which I need to sum them up at the bottom.
Now the problem is the number of rows will not be same.
the macros code for it?
In Sheet1 --> Emp id, Emp Name and Emp dob having some 'p' rows
In Sheet2 --> Emp id, Emp address, Emp Designation and Emp blood group of some 'q' rows
Now, i want in Sheet3 --> Combination of both Sheet1 and Sheet2 data. Note: Emp id in Sheet1 and Sheet2 are same which indicates an unique identifier. I attached a file for your reference..
I've got a rather simple question. I need a code which would activate a cell which is located 10 rows down from the currently active cell. I found this piece of code
Sub move()
ActiveCell.End(xlUp).Offset(10, 0).Activate
End Sub
but somehow it does not do the job it is supposed to do.
I have always saved each macro on a single workbook, saved the workbook using the macro name, so I can go use that spreadsheet for a specific issue. Now, however, my job role is changing to where I have to do a lot of things like get a file from Bob . . . slice and dice and then forward it on to Carol, etc. Then I have to save spreadsheet A to this directory, spreadsheet B to that directory . . . .
I am sure there is, I just can't get my head around it to have one spreadsheet that has ALL my macros that would be available to me on other spreadsheets? I tried using "show macros in all open workbooks"
I have a sheet that holds my inventory and has 3 colums. The colums are serialnumber, techid and date. I also have a sheet for each techid. Is there a way to delete/move a row of data if the serialnumber is entered on another sheet.
example.
I have a serialnumber added to my first sheet. I go to a techid sheet and enter that same serial number. Is there a way to copy the entire row the same serialnumber is on and copy to the current sheet? Possibly a search function where I enter a serialnumber and it finds the same thing on the main sheet and copies the rows into the current sheet.
I need a way to move every 7 rows into columns.
So rows 1-7 become columns 1-7, rows 8-14 into columns 1-7 etc.
I'm trying to adapt a macro written elsewhere on this forum for my purposes. I need to move 127 rows of data into one row. The macro written does exactly what I would like, except that it only works for 3 rows, rather than 127. How do I get this to work?Here's what I have so far:
[Code].....
We run reports from active directory to see user accounts that have not been logged into the network between 30 and 90 days. We have a few spreadsheets within a workbook (Investigate, Disable, Delete, No Action). All user accounts are imported into the investigate spreadsheet. What we would like to do is automatically take predecided accounts (service accounts that we do not log on to the network - only meant for services, etc) and move them from the investigate spreadsheet into the No Action spreadsheet. These accounts all start with svc. Generic accounts start with GEN and so on....
View 14 Replies View RelatedI am trying to create a macro the looks at column A and moves the entire row to another worksheet or deletes the entire row based off of the value in each cell. Right now I have the Macro replace the downloaded values to either AG, G, GI, ICP, IMG or delete. The idea be to move all of the values with AG in column A to the AG worksheet, move G to the G worksheet, etc.. and then delete all of those with delete in the cell.
View 14 Replies View Relatedi learned how to highlight a row by placing an X in a single cell, my next question is:
Is there a way (most Likely there is) By placing "J/C" into a cell, make the entire row cut and then insert itself into my second sheet on row 2? "insert into a new row and not over existing information?"
now i have done this in the past using a Macro, select the row and then by pressing ctrl+k it would cut the row and then insert it into row 2 of the second sheet.
I've got a pretty nice Worklist setup in Excel that enables you to organize all the work you need to do in a month. However i end up with little holes in the list whenever i finish a task because what my macroes does is whenever a job is marked as done on the list it moves that job to sheet2, which contains completed jobs. I'd like to have a macro that shifts all the rows 1 down whenever a job is completed(ill just call it from the job complete macro) but it needs to jump over(skip) row 26 because that row contains some images that my macros use. Altso i would like to, if possible avoid inserting any rows or cells or hiding them because that will totally mess up my macros :p I know i know, im not dynamic enough.
I've included a sample of the worksheet so you can see what i want.
By the way, I've altso got some trouble with a public function.
I need to cut 2 rows when i put "V" in E column, and then to paste them below row that have in column A, "OLD".
Ex:
I have many rows with data like this:
.......A..........B.........C.......D......E
1...subject
2...notes
3...subject............................."V"
4...notes
5...subject
6...notes
...
25..."old" row...............................
I need to cut the row with "V" in column E and the below row, and paste them below row with "old" in A column, like this:
.......A..........B.........C.......D......E
1...subject
2...notes
3...subject
4...notes
...
23..."old" row...............................
24...subject............................."V"
25...notes
I have data that I want to move to columns:
-----A
1 Apples
2 Bananas
3 Oranges
4 Watermelon
5 Grapes
6 Kiwi
It should move every two rows to columns, like so:
-----A------------B
1 Apples-------Bananas
2 Oranges -----Watermelon
3 Grapes-------Kiwi
4
I need to look into a particular cell on a specific column.
if this cell does not contain a number, then I need to delete the entire row, not column.
and then of course do this for 30K+ rows.
if sheets("sheet1").cells(x,7) is not a number ( dont know how to write this )
then delete row and move up.
I have cobbled together bits of code from around this forum to do what I need (thanks to all those I stole from!) but I'm stuck on the last bit.
I have a spreadsheet and the user types into an input box what they are looking for and the cursor moves to that position.
If the data is initially off the page when it is returned it is on the last row of the page I now see. Sometimes it may be appropriate to see data below it.
Is there anyway the found cell can always be shown about half way down the viewable page? (so that about 10 rows below are seen - obviously if the data is at the top then no movment is needed)
I tried the "ActiveWindow.SmallScroll Down:=10" but hit problems where the data was on a higher screen than the last search.
I am using excel 2000
I created a macro that is supposed to copy the contents of about 500 rows, and move them all up one row. One of the things that is contained in those rows are a bunch of links to Microsoft Word documents. When I try to move the 500 rows up manually (just copying, and pasting one row higher), it works fine. The link remains entact.
However, when I use the macro I recorded, the link no longer works. It looks like it is there (the text used to represent the link is there), but when you click on it, nothing is there. Here's my code....
I have attached a sample file and would like to have the expected format as shown in the attached. Would greatly appreciate if someone could show me the faster way of reformating the data instead of doing it manually.
View 3 Replies View RelatedI have an original workbook. Also I have saved a "copy of the original Workbook". So the sheets and other headers are same. Now i want that If i delete a row in Original Workbook then the row should go out from origianl workbook and copied to "Copy of Orinal Workbook" in the same sheet from the the row is being deleted. Suppose row 7 of sheet1 is deleted, then the data of the row 7 from the original WB should go to row 2 of Copy of origianl WB (Being the first empty row. Similary if any row is deleted from sheet2 of Original Wb, the same should go to first empty row of Sheet 2 of Copy of Original WB. By this I want to keep a record of those rows which are deleted from the original Wb for future reference.
View 2 Replies View RelatedI have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............
View 3 Replies View RelatedThe small attached "Demo2" file indicates my problem. In the "Scorecard" sheet I'm using macros driven from listbox menus to hide or unhide rows on the "Tasks" sheet. It is VITAL that the rows on the "Tasks" sheet not be deleted or have new rows inserted. But, if I Protect them then the list box macros won't function. Is there a macro that will allow these macros to hide or unhide rows without allowing a user to add or delete these rows in the "Tasks" sheet? If possible a simple "global" solution is preferred as I have 100+ If/Then entries to contend with...
Attached File : DEMO2.xlsm
I Have a sheet called "Main" in Which I use a Doubleclick Private function. When the user Double clicks on a row, I want excel to take note of the row number that was clicked, then move to a different sheet and copy the row in the new sheet (Called "Data") with the same row number as the Target row that was Double Clicked.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 4 Then
Sheets("Data").Select
Sheets("Data").Rows(Target).Copy
Sheets(" Chart Data").Select
Sheets("Chart Data").Rows("2:2").Paste
End If
End Sub
I know The (Target).Copy line is incorrect but I dont know what the correction is.