Over 1 million tech questions and answers.

Cannot sort selected rows in Excel 2013

Q: Cannot sort selected rows in Excel 2013

I am having what should NOT be a problem with an Excel spreadsheet. I have a chart of information that is divided on this spreadsheet into categories. I want to sort the items within a category by the Product Name column. With the first category, this worked great. But as I am adding categories of products (skip a line, enter the Category Name in column B and on the next line begin listing product names in column C) I cannot do it.

I select the exact cells I want included in the sort.
I select Sort & Filter, then Custom Sort in the Home tab
I select to sort on Product Name, and Values (I want an alphabetical sort)
OK

The ENTIRE table, not just the selected rows all sort and everything is all mixed up. I have tried everything I can think of to get this to work, and it just will not sort selected rows or cells. Any ideas out there?

RELEVANCY SCORE 200
Preferred Solution: Cannot sort selected rows in Excel 2013

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Cannot sort selected rows in Excel 2013

Hi, you cannot just sort one column.
If you sort in Excel you must always select the entire table.

If you add columns the you will have to include those too.

And for the worst part, you will have to fill the table again as it was originally.

Read other 3 answers
RELEVANCY SCORE 83.6

I have a spreadsheet with about 1,100 rows of data in it, and I want to sort each ROW (not column) in ascending order, from left to right, but only cells B C D E and F, the data in A, G and H must be left intact.
I can sort the entire XLS left to right, but that's not what I want, I just want those 5 cells within each row.

Is this easy, or am I missing something, or what ?
 

A:Excel sort within ROWS

Read other 16 answers
RELEVANCY SCORE 82

Hello, below I have listed a spreadsheet in Excel that represents column A-F. Column E contains formulas that come up with a number based on the data in columns B-D. Column F is just a copy of that data that I will manually adjust if needed.

I have all the rows sorted by the data in column E largest to smallest in descending order. The data in columns B-D is copied from data it finds on Sheet 1 of my workbook.

As that data on Sheet 1 updates, and the subsequent data in column E updates simultaneously, I would like rows on this sheet to automatically update it's sort according to the change in data(via formula) in column E.

I'm sure this will take macros, but I need help coming up with what to put in there. Thank you in advance!


 

A:Solved: Auto Sort Rows in Excel

Read other 7 answers
RELEVANCY SCORE 81.2

Hi there,
I got one excel file with 1000 rows in it. Now it got 7 different columns. There is one column which is "email. Now, this email column contains value "admin###email.com" , "saud", sund. Now what i want , all the rows which contain admin###email.com should be separated from all other emails. It can be separate excel file or may be top few hundred rows.

how to do this?

Thanks
 

A:excel problem (sort rows by judging particular value of cell)

Have you tried Autofilter? It is in the Data/Filter menu. Or, the other possibility is Data/Sort.

Jimmy
 

Read other 2 answers
RELEVANCY SCORE 80.8

Excel Masters, I am not sure how to loop through the following code for multiple row formatting. The code works fine if the user has selected cells within a single row. However, when multiple rows are selected, the 'With ActiveCell' formatting only works for the first row selected. How can I loop the 'else' statement to format the ranges for all rows with a cell selected?
Private Sub Button_DeleteRow_Click()
Selection.EntireRow.Interior.ColorIndex = 3

msg1 = MsgBox("Delete this row?", vbYesNo)
If msg1 = vbYes Then

Selection.EntireRow.Delete

Else

Selection.EntireRow.Interior.ColorIndex = xlNone
With ActiveCell
Range(Cells(.Row, "AA"), Cells(.Row, "AN")).Interior.ColorIndex = 15
Range(Cells(.Row, "c"), Cells(.Row, "d")).Interior.ColorIndex = 15
Range(Cells(.Row, "a"), Cells(.Row, "a")).Interior.ColorIndex = 15
Range(Cells(.Row, "j"), Cells(.Row, "j")).Interior.ColorIndex = 15
Range(Cells(.Row, "n"), Cells(.Row, "n")).Interior.ColorIndex = 15
End With

End If

End Sub

On a related note, I already have a separate worksheet change event (ByVal Target As Range) running on this worksheet.
 

A:Solved: Excel Macro - Loop selected-cell formatting for multiple rows

Something like:

Selection.EntireRow.Interior.ColorIndex = 3

msg1 = MsgBox("Delete this row?", vbYesNo)
If msg1 = vbYes Then

Selection.EntireRow.Delete

Else

Selection.EntireRow.Interior.ColorIndex = xlNone
SelRows = Selection.Resize(, 1).Cells.Count
Cells(ActiveCell.Row, 27).Resize(SelRows, 14).Interior.ColorIndex = 15

'(and so on)

End If

?

On a related note, I already have a separate worksheet change event (ByVal Target As Range) running on this worksheet.Click to expand...

If you mean "how do I bypass that for Selection.EntireRow.Delete then:

Application.EnableEvents = False
Selection.EntireRow.Delete
Application.EnableEvents = True
 

Read other 2 answers
RELEVANCY SCORE 80.8

Hi:
Is there a way to freeze multiple rows in Excel 2013. I have tried but no joy.
 

A:Freezing Multiple Rows Excel 2013

you can freeze panes - but it only freezes rows 1 and below
or column A and to the right
put your cursor on the row below the one you want to freeze - say row 6
click in A6 - if you do not want any columns to be frozen
now goto View on the ribbon
Freeze Pane
1st option
a line appears just under row 5 and those rows are now frozen
If you click on any other column - say C6
the columns A and B are also frozen
 

Read other 2 answers
RELEVANCY SCORE 78.8

Hi:
Using excel 2010
I have a master list of items,product code, and price.
I would like to be able to use a separate worksheet and be able to use a drop down menu/list to select and add individually to my worksheet.
Example, there mmight be 1000 items in my master list and I might like to select/import as such 11 items into my worksheet.
Any suggestions?
 

A:Solved: Importing selected rows from Excel sheet one to Excel sheet two

Read other 6 answers
RELEVANCY SCORE 74

Here is part of my code where it errors out in 2013 for the sort .apply but not 2010 and can't figure out why. Help appreciated. I have recorded same in 2013 with same results.
Code:

Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Temp Data\mydata.csv"
Rows("1:1").Select
Selection.Delete Shift:=xlUp
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="<>"
Cells.Select
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Range("A1").Select
ActiveSheet.Paste
Sheets("Mobility").Select
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="="
Application.CutCopyMode = False
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Range("A1").Select
ActiveSheet.Paste
Range("AC2").Select
Application.CutCopyMode = False
Sheets("Sheet2").Select
Cells.Select
Range("U1").Activate
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range( _
"Q:Q"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Sheet2").Sort
.SetRange Range("A:AM")
.Header = xlYes
.MatchCase = F... Read more

A:Solved: Excel 2013 Sort Macro errors out at .Apply but not in 2010

Read other 13 answers
RELEVANCY SCORE 67.6

I do a weekly report that I base on results that I get with search done in Internet Explorer. I can then cut and paste these results into an Excel spreadsheet, but I need to delete most of the information (whole rows) and reorganize the remaining rows by taking the even numbered rows and putting them into the B column, then delete that Row as well. I have included some images that should help. A few more items:

1.)The information that I paste into the excel spredsheet may contain up to, but no more than 350 lines from the original copying source in Explorer (I'm not sure how many lines that translates into Excel)

2.) After every 20 records in Explorer there is a "top" link that gets copied, which needs to be taken into consideration when deleting the extra rows entirely

3.) Another way to look at this is that I ONLY want to keep the rows that have the 7 digit number a space then 2 more digits, as well as the rows that contain the price with the $ For instance the first record in my example I ONLY kept 8055312 11 & $70,000. The price will ALWAYS have a $ and the first set of number will ALWAYS have 7 digits first, no letters.

Attached is a jpg that shows the various steps, the last screen shot has a few of the cells highlighted in the upper left hand side. Those 6 highlighted cells is all of the information I need, and how I need it presented from the first 3 search records, the MLS number and the price.
Thanks!
 

A:Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns

Read other 16 answers
RELEVANCY SCORE 67.6

I am having exactly the same problem as a closed thread. http://forums.techguy.org/business-applications/857921-excel-2007-table-filter-problems.html

Did anyone ever get to the bottom of it?

Basically, if I have a table in Excel 2007, and actually use the filter, it then breaks the autofilter.

I had a table with 6 rows, and it completely messed up.

Now I am down to 4. If I filter on 1, then 1 shows.

If I cancel the filter, only 1 to 3 show and row 4 is hidden. If I drop down the filter, row 4 does not exist.

If I unhide row 4, it is matterless. Excel 2007 's table shows it on screen, but it is no longer in the autofilter.

Filter by row 1, then row 3 disappears into hidden status, and drops off the autofilter. Rows 1, 2 and 4 now show (I unhid row 4, remember?)

BUT< the autofilter now only has row 1 in it. Rows 2 to 4 have been lost from the autofilter.

I need to be able to :
a)automatically add rows
b)filter by criteria
c)reference the table by row and column in calculations

Switching the autofilter off and on does not help. Converting it to a range means all my references went to pot, and also means that referencing and calculating sums breaks it automation. I am utterly depressed.
 

A:Excel 2007 table filter bug is hiding rows and losing rows from the autofilte

Ah well, Looks like I'm not the only one who had this problem. This article has a detailed explanation of what's causing the problem and a few possible workarounds: http://blog.contextures.com/archives/2010/03/19/number-the-visible-rows-in-excel-autofilter/

I found it thanks to http://answers.microsoft.com/en-us/...cel-2007/2364f944-18fa-482d-a1ac-db7464be0894
 

Read other 2 answers
RELEVANCY SCORE 67.6

Hi There

It has been quite a while since I asked for help. I wonder if the following is doable as an Excel macro. The attached is only a demo with only 2 fields and a few rows of data. The real worksheet has more fields and around 3,000 rows.

Sheet 1 contains the data in its initial state and sheet 2 contains data after the macro is run. You will see from sheet 2 that the field labeled QUANTITY determines the number of rows to insert and copy the correct data into those inserted rows. I want the entire row to be copied down as opposed to only the data, since I have more columns than shown here. Is this possible to do? Can anyone help me with writing a macro, since I have over 3,000 rows to do.

Thanks for all your help. You guys are fantastic.

Mario
 

A:Inserting specific number of rows in Excel and copying data in those inserted rows

Read other 14 answers
RELEVANCY SCORE 66.8

Hi,

I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7 help me?

I uploaded a bunch of keyword searches. Came up with 4 columns and anywhere from 100- 400 rows. I need to sort these in different ways. By Keyword so the spreadsheet is by alpha, then by Demand with highest at top/lowest at top, by Supply highest at top/lowest at top, and by Profitability highest/lowest. I know I can't do all at once, I am referring to different sorting methods.

Example: (you have to imagine 4 columns, and the numbers going under each column- when I saw the preview it bunched the numbers together and I can't seem to put them where they belong, but the first # goes under the second col (B), second # goes under "C", third # goes under "D" column:

COLUMNS:

A-----------------------------B-----------C-------------D

KEYWORD DEMAND SUPPLY PROFITABILITY
breathing exercises 7995 5306 1507
celebrations 8523 142301 60
cervical 10235 58395 175
chakra 28455 43099 660

My problem has been that in reading the instructions I don't understand how to do this (perhaps I'm just dumb!) so that each word will still have the "righ... Read more

A:Re: EXCEL- resorting rows so they each relate to original rows

When you sort in Excel, you select all of the rows and columns of the data to be sorted. When you apply a sort to one (or many) columns, all of the data on each row is kept complete and moved up or down.

Is that what you needed to hear?

Read other 7 answers
RELEVANCY SCORE 66

I'm using Microsoft Excel for tracking information and I would like to print out selected rows in a group. Is there any way that I can print randomly selected rows like 1,5,10,15 and have them print out on the page as if they were consecutive rows and not one row per page with spacing as they apear on screen? This uses a couple of pages instead of being able to print one page.
 

A:Printing selected rows?

Read other 8 answers
RELEVANCY SCORE 65.2

Hello there, i have a recordset rsTemp and datagrid TDBGridMain.

How can i print/MsgBox the field x from all the selected rows.

With this:

Code:

[COLOR="Blue"]dim ms as string
ms = rsTemp("ID")

MsgBox ms[/COLOR]

It only Show the last selected row and not the others. How ca i loop through
the selected rows and print the value from the field x from each selected row?. Thanks.
 

A:Print Field X From The Selected Rows VB6

Read other 11 answers
RELEVANCY SCORE 59.2

Hello,

I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

Notes:
the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.
Mzz
 

A:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?
 

Read other 1 answers
RELEVANCY SCORE 59.2

Yet another question, nearly finished the database!

On my hire form (frmHire) I have a combo box "MemberID". When I select a MemberID (from tblMember) I need to check that the MemberID isn't present on tblOverDue. If it is present on tblOverDue I want to create a message box to announce that the selected member has over due items.

I have a query that checks the OverDue table to see if the selected MemberID on the form is present in the OverDue table.
How do I write 'If query returns a result then, msgbox "This member has overdue items" ' ?
 

A:Access 2013 - If selected record is in another table...

Read other 8 answers
RELEVANCY SCORE 58.4

Hi,

I'm using Office 2013 under a recent fresh install of Windows 7 x64. What's weird for me is that the selected text color is now grey even though the "Windows Color and Appearance" applet have the color "blue" for selected items and indeed, selected files and folders have blue shading as expected in explorer, but Word doesn't obey the color. Same issue with Excel & PowerPoint. Is there anyway to make Word picks up the blue color when selecting?

Read other answers
RELEVANCY SCORE 58

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

A:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hi.

I'm a beginner when it comes to VB Script and so I am struggling to work this out. I basically have a worksheet that contains information about different staff members. The sheet is set up so that column A (from row 8 on) is their name and columns B to L (also from row 8 on) are other staff attributes. Due to several reasons, there is more than one listing for each staff member (up to 40). The database is supposed to be there so that any staff member can come in and look up their information (or that of any other staff member). However, with so many listings and so many staff members, it becomes an unmanageable database. I could just create filters so that staff members could simply filter out other employees; however, this would create issues. Instead, I have created a cell above the table (say C2) where staff members can enter their name via means of a data validation list (which is linked to a list of staff members on another sheet). I would then like all rows in the table to hide except for those where the name in column A = C2.

I have searched this on the net and I keep seeing similar responses that all say it's hard when there is data validation / formulas involved. Is there a way this can be done?

Cheers
 

Read other answers
RELEVANCY SCORE 56.8

In Word 2013 I am hooked on event DocumentBeforeSave. When user wants to save document, backstage view is displayed with possible locations and also recent folders. After user selected one of recent folders, event DocumentBeforeSave is triggered. Where is the information about selected path stored? I need to display Save dialog(Dialogs[WdWordDialog.wdDialogFileSaveAs]) directly in this event, but first I need to know which path user selected. Otherwise default path is selected and it could be counfusing for the user.

Read other answers
RELEVANCY SCORE 56

When I open my contacts they are sorted last name then first name which is the way I want them. But when I go to send an email and click on the "to" button, the names are sorted by first name. How do I get them to sort by last name.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 8.1, 64 bit
Processor: Intel(R) Core(TM) i7-4500U CPU @ 1.80GHz, Intel64 Family 6 Model 69 Stepping 1
Processor Count: 4
RAM: 8102 Mb
Graphics Card: Intel(R) HD Graphics Family, -2016 Mb
Hard Drives: C: Total - 230601 MB, Free - 150385 MB;
Motherboard: LENOVO, 20CDCTO1WW
Antivirus: AVG AntiVirus Business Edition, Updated and Enabled
 

A:Solved: Outlook 2013 Address Book - I want to sort by last name

Have you tried things shown at http://office.microsoft.com/en-us/o...-last-name-first-name-format-HA010355556.aspx
 

Read other 2 answers
RELEVANCY SCORE 54.8

Hi all,
I have a sheet sent over to me weekly that contains approximately 1450 rows. Of these rows I have to remove specific ones then manually recalculate all the info.
The way the sheet is downloaded means there are no formulas in it when I get it so as you can imagine it is a long and tedius task.

What I am looking for is...
Is there a way to run a macro that can search for specific instances and then calculate this for me?

This is how the file I get sent is laid out...what I am really looking for is maybe a macro that can run through the file, find where column F has text and if it does, total up the numbers below.
The paste below is filtered to show anyone below 100%.

Region 1
154 138 89.61%
123

30 26 86.67%

name 1 Full-time 10 6 60%
124

40 34 85%

name 2 Part-time 2 0 0%

name 3 Part-time 10 9 90%

name 4 Part-time 10 7 70%
125

48 45 93.75%

name 5 Part-time 8 7 87.5%

name 6 Part-time 2 0 0%
126

36 33 91.67%

name 7 Full-time 2 1 50%

name 8 Part-time 2 1 50%

name 9 Part-time 8 7 87.5% Region 2
234 219 93.59%
127

40 28 70%

name 10 Part-time 2 0 0%

name 11 Part-time 10 0 0%
128

64 61 95.31%

name 12 Part-time 10 9 90%

name 13 Part-time 10 8 80% Region 3
204 187 91.67%
As you can see, the 123, 124, 125 and so on are store numbers, all of the figures are correct at the moment however once I remove the specific lines they won't be, for example if I remove name 10 then store 127 and region 2's figures aren't ... Read more

A:Excel sum rows

I have attached a demo file as the copy and paste did not work. I have also unfiltered the results to show every line not just those below 100%. Hopefully that will make it a little more clear.
 

Read other 1 answers
RELEVANCY SCORE 54.8

Does anyone know if there is a way to exceed the default worksheet length of 65536 rows?? I have a very large amount of data that I am currently having to analyze in pieces but would really like to do all at once. Any leads would be greatly appreciated.
 

A:Excel: Want More Than 65,536 Rows

Read other 7 answers
RELEVANCY SCORE 54

I want my rows to automatically number beginning with #1, even though the data doesn't start until row 8. What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)
 

A:Number Rows in Excel

sbudd said:

What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)Click to expand...

=ROW()-7 (Yes)
 

Read other 2 answers
RELEVANCY SCORE 54

Hello, i find myself in great need for an excell formula or macro that is able to do the followings for the spreadsheet that i have...

this is what i got (it's a bit more random in reality)
jun | 3333 (uniqueID) | SOME NAME | 10 (value 1) | 3 (value 2)
may | 3333 (uniqueID) | SOME NAME | 14 (value 3) | 6 (value 4)
jan | 4444 (uniqueID) | OTHER NAME | value 5 | value 6
may | 4444 (uniqueID) | OTHER NAME | value 7 | value 8

what i need:
search and identify uniqueID then sum in the following manner, so i want to merge the 2 rows that have the same ID and sum there values.

jun+may | 3333 (uniqueID) | SOME NAME | 24 | 9
Thank You Very Much!
 

A:EXCEL Compare Rows And Sum Them

Read other 10 answers
RELEVANCY SCORE 54

Hi,

I have a large excel database wich one observation is spread in several rows. For statistical purposes i need to place all the information of one observation in one single row.

attached a file with sample of my data and the layout i need to have.

Can anyone give an hand with this?

Thanks in advance,
bmoita
 

A:Multiple Rows to One Row - MS Excel

Read other 6 answers
RELEVANCY SCORE 54

We need to combine a report for the past 8 years. Each year is composed of 5 columns:

A) Department
B) Expenditure
C) Account title
D) Cost center
E) Amount

We want to make a new file with these columns:

A) Department
B) Expenditure
C) Account title
D) Cost center
E) Amount 2000
F) Amount 1999
G) Amount 1998
H) Amount 1997
I) Amount 1996...

The main issue is that the files (years) do not have the same amount of rows. There are some account titles and cost centers that were present on other years that are not present this year, and vice versa.

Copy and paste of the Amount will post them on different cost centers, since they will not fall on the correct row.

Any idea on how to make things easier?

------------------
"There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
 

A:Excel - Merging rows

Could you possibly use Access and import these tables? You could then specify which field the column needs to go in to.
 

Read other 2 answers
RELEVANCY SCORE 54

Hi Everyone,

Iam having an issue with my Excel - 2007
in my excel sheet i have Rows = 6565 & Column = A-AZ.

Now you can image this is a big file.

my second column name is Project ID : it starts from 100191 and so on....

in the middle of 4634 row the,,, the sequence is not correct.. (the rows are jumbled / up and down..).

so i sort them..

after few days, some where in the middle the sequence again changed..

can any one suggest me solution and cause of this problem..
Thanks for your valuable time and considerations.
 

A:Excel Rows are Jumbling

can you post the data?
 

Read other 1 answers
RELEVANCY SCORE 54

How can I get the row numbers in an Excel worksheet to show and print?
 

A:Number Excel rows?

File > Page Setup > Sheet, put a check by Print-Row and Column Headings.
 

Read other 2 answers
RELEVANCY SCORE 54

I have a lot of time series data, which includes date, time, latitude, longitude. Each date (dd/mm/yy) should have 15 time cells next to it, 1700, 1800, 1900, 2000, 2100, 2200, 2300, 0000, 0100, 0200, 0300, 0400, 0500, 0600, 0700. However, when the data was entered if there was no latitude or longitude entered, the row was skipped, and as such there are "holes" in the data. I would like therefore to enter a line where each row is missing so that ever day records the times given above, and N/A is inputted where no latitude or longitude was recorded. Any ideas?
 

Read other answers
RELEVANCY SCORE 54

Hi,
I'm manipulating a large file and want to insert rows programatically within VBA so that I can include sub-totals and also some other formatting to make the output look better. I'm using the Range(Cells(1,1),Cells(r,1)).Select method elsewhere (where 'r' is the row number), but this doesn't work when I come to defining a row where I want to insert additional rows.

Any help on how I can insert at rows at variable points from within VBA would be greatly appreciated!

rsb
 

A:Inserting Rows in Excel using VBA

One way to learn is to record a macro of you inserting rows.
 

Read other 2 answers
RELEVANCY SCORE 54

I have an Excel spreadsheet that contains 2 rows for each record. For example, on row 1 in the person's name and the row underneath it is the project name. I want to use the autofilter and keep these 2 rows together when I filter. Can this be done? Or what is the best way to keep these 2 rows together?
Thanks:
 

A:Keeping Excel Rows Together

Read other 16 answers
RELEVANCY SCORE 54

So here I am again trying to do something with Excel for which I have zero qualification or knowledge. HELP!

I am copying an earlier entry on this subject as it is exactly what I need to do. There are solutions posted, but I am unable to make them work for me.

I have an excel sheet which has two columns A and B. Both the columns contain names and column B has more names than column A. I am looking for an excel formula that can compare names in A and B and list out names in column C that are in column B and missing in column A.

Thanks for looking!

~JJJ~
 

A:Excel Compare Two rows

Read other 12 answers
RELEVANCY SCORE 54

I have some code that pulls data from two different worksheets onto one worksheet. The data looks like the following:

WS1

123
123
852
9637
5789
5789
159

WS2

123
123
852
9637
5789
5789
159

WS3

123
123
852
9637
5789
5789
159
123
123
852
9637
5789
5789
159

I need to come up with some code that will go through the A Column to delete the rowa that contain duplicates. So, once the deletion code has ran, WS3 should look like this...

WS3 (After Deletion Code)

123
852
9637
5789
159
123
852
9637
5789
159

Does anyone have any ideas? I have the code below, but it works only if data is pulling from one worksheet.
Code:

LastRow = ws.Range("A65536").End(xlUp).Row
For x = LastRow To 1 Step -1
If Application.WorksheetFunction.CountIf(ws.Range("A2:A" & x), ws.Range("A" & x).Text) > 1 Then
ws.Range("A" & x).EntireRow.Delete
End If
Next x
 

A:Excel -> Delete Rows

Forgot to mention that the deletion code needs to be universal. There will not always be data from WS2, so the code I posted above will work. I just need help creating a code that will work if there is data in WS2.
 

Read other 1 answers
RELEVANCY SCORE 54

I was given a txt doc that I opened in excel. This is a transaction log, and one transaction will have multiple rows. I need one row per transaction. There is one row that has M1- INFOGEN3 Tender Post Response is ACCEPTED (or DECLINED). Then a couple rows down it has M1- Ready to Post Tender for Check ID 179909...

I am hoping to at least have those two rows on the same line so I can search for DECLINED and get the check ID number. There's like 1080 of these things and going through one by one would be difficult.

Thanks for any help!!!!!!!!
 

A:Combining rows in Excel?

Read other 6 answers
RELEVANCY SCORE 54

I have formulas that has the data setup in rows (input). The next sheet is formulas that are in columns referencing these individual rows (output). When column A's formulas are dragged to column B, the references change as expected but to Sheet1!B1 rather than Sheet1!A2 (back to the rows). I think I 've done this before, but can't for the life of me remember how. Help me please and I'll be your best friend! (hey, it's the best I can do).

thanks,

drew
 

A:Excel Columns to Rows

Select all the cells involved

Right click anywhere on your selection and from the menu that pops up choose Copy

Click in the cell where you want the list to begin then Right click and from the menu choose Paste special you will now see another menu.

At the bottom right hand side of this menu, Select Transpose.

That's it your list will now run across the page instead of down
 

Read other 3 answers
RELEVANCY SCORE 54

stupid question time:

I have about 63000 excess rows in excel 2000 that have just junk, but no matter if I delete them or clear them they stay in the worksheet. How do I make them go away?
 

A:excess rows in excel

Read other 16 answers
RELEVANCY SCORE 54

Hi again

Once again, I would like to thank all of you for your help in Excel programming. You guys are GREAT!!

I have another slight problem I need help with. I have a column, say column A, with text. Most of this text is repetitive in nature. I want to keep only the first 10 rows of the text that is repetitive and cut and paste the other repetitive text to sheet 2. Here is an example: Let us say that Column A has this text. I just used any text. The columns could have repetitive numbers as well. This is just an example.

qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
rty
rty
rty
rty
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio

Etc down the column. This list is extremely long. As you can see form my example, there are 12 qwe's, 4 rty's and 13 uio's. I would like to keep only ten or less of each groupings and cut and paste those groupings in excess of 10 into sheet 2. In other words, when the macro is run, I would like to have 10 qwe's, 4 rty's and 10 uio's in sheet 1. Sheet 2 would then have 2 qwe's and 3 uio's.

I have tried to create a macro by myself but this is beyond my prgramming expertise. Any help woud be appreciated.

Mario
 

A:Counting rows in Excel

Read other 16 answers
RELEVANCY SCORE 54

Hello, new to excel vba, having a hard time to multiply the rows, i know this is a basic question but its not working for me any ideas guys ? how do i get this going
 

A:how to multiply rows in excel vba

Read other 13 answers
RELEVANCY SCORE 54

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 54

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

A:Solved: Excel search does not work Excel 2013

Read other 7 answers
RELEVANCY SCORE 53.6

Hi!

I selected categories of Sort By and Group By context menu in one folder, like Vertical Resolution, Horizontal resolution etc.
It was applied only to one folder...
Is possible to apply these categories to all folders without selecting each folder?

Thank you for every help!

Miro

Read other answers
RELEVANCY SCORE 53.6

So I have 3 sheets, the first 2 with just text (people's names) in column A going down. Both sheets have the same data, just in different, specific orders going down the column. In the third sheet I want to be able to return the row number that each specified text (person's name) appears in within the other sheets.

For example, in sheet 1, the word "Matt" might appear in A2, but in sheet 2, it appears in A8. On sheet 3, I want to show which rows "Matt" appears in on the other sheets. (2 & 8, respectively) The "2" and "8" would be displayed in separate cells.

My first thought was to assign names to each row based on what the text is in column A, then do something like =ROW(Sheet1!Matt). This is easy for just doing a few, but I have over 500 rows I'd like to name and multiple sheets to do it for. I'd need a function that does RowName=TextInColumnA. Is there a way to streamline this naming process?

If there is a completely alternative solution that is fine also.
 

A:Naming/referencing many rows in Excel

I would use the match function, its nice and simple.
 

Read other 1 answers
RELEVANCY SCORE 53.6

I have spreadsheet that has a bunch of parts listed in separate categories. Column A is the quantity column. I want to be able to hide all rows (using a macro) that have a zero in column A. The workbook has several sheets that need the same functionality. The macro must not hide rows with nothing in them or nothing in column A. For example a row may have content in other columns but nothing in column A because that row is not used for a specific part (therefore there will never be a quantity entered).

The code below works great except that it hides all rows with that are zero or blank. I just need to figure out how to make it skip the blank rows (column A has no data). Any ideas? It doesn't have to be with my code just something that provides this function for all sheets in the workbook. Thanks.

Option Explicit
Sub HideRowsWithZeros()
Dim ws As Worksheet
Dim c As Range
Dim rngRange As Range

Application.ScreenUpdating = False

For Each ws In ActiveWorkbook.Worksheets

ws.Select
Set rngRange = Range(Cells(1, 1), Cells(65336, 1).End(xlUp))

For Each c In rngRange
If c.Value = 0 Then
c.EntireRow.Hidden = True
End If
Next c

Next ws

Application.ScreenUpdating = True

End Sub
 

A:Excel Macro to hide rows

Read other 6 answers
RELEVANCY SCORE 53.6

I want Excel to automatically hide rows that do not contain anything in them. It seems like I should be able to do that but I am not seeing how in the help files. I could use the auto-filter but that messes up the look of the form.
Maybe I am just doing this inefficiently. I have an exported query from Access to Excel and then from that query I am making monthly reports. For each month Excel looks at the start up date of each line in the query and if it is in the month it shows the row of data. However each month is a new worksheet but the query export is on one sheet. This means that in each progressive month there are an increasing amount of blank lines above the data. Going through each month and hiding them would remove the point of having an automatically generated report. I also can't make excel look to specific rows of the query because the number of start up's in a month fluctuates.
 

A:Solved: Autohide Rows in Excel

Try this:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=512
 

Read other 2 answers
RELEVANCY SCORE 53.6

Excel 2003 provides an option in page setup to repeat certain rows at the top of your screen as you scroll downward. This is really helpful for column headings.

I have selected row 1 to repeat at the top of the screen; however, rows 1 and 2 are repeating. The formula in the page setup for rows to repeat is "$1:$1". Isn't that correct? If so, why are rows 1 and 2 repeating?

Thank you.

A:Excel: Repeating Rows at the top of the screen

I dont do it in page setup unless you are talking about printing column headings on a report.
Thats different.

Click on where you want the slit to occur in the worksheet then click the window menu & split.

Read other 2 answers