All Questions
16
questions
0
votes
1
answer
261
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
1
vote
1
answer
113
views
Making the VBA code affect a specific range of pages
I have this very simple code
Sub SortByTime()
'
' SortByTime Macro
' Sort by Time
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Range("C4:J43").Select
ActiveWindow.SmallScroll Down:=-36
...
0
votes
0
answers
30
views
Sort Value & Description Together Horizontally
I have a set of data listed horizontally where two cells work together with the value and description.
A1 B1 C1 D1 E1 F1
300 Description3 100 Description1 200 ...
2
votes
3
answers
2k
views
Does excel provide a method for sorting columns based on numbers and phrases contained within one cell?
I receive a packet of data in the form of a .csv file from our database manager. I import this data into excel for formatting and sorting. However, one column contains three pieces of info that I want ...
0
votes
1
answer
406
views
Excel - Find unique values in one column and corresponding values from another
I have a database export of components and labels in two columns. Column A contains a component and column B contains the labels associated with the component. The same component can show up multiple ...
0
votes
1
answer
1k
views
Dynamic Auto Sorting in Excel
I have a list that is dynamic and can change depending what the user selects. The Event types will never change but the Count will. The items in B1 and B2 are what the user can select that will change ...
0
votes
1
answer
78
views
Sort Sheets Alphabetically VBA
I'm struggling on how will I sort the sheets after combining all workbooks into 1.
here's my code:
Dim wbDst As Workbook
Dim wbSrc As Workbook
Dim wsSrc As Worksheet
Dim mypath As String
Dim ...
0
votes
1
answer
365
views
Excel -- Comparing 2 lists with several columns
I have 2 lists with several columns. Each list has 5 columns, and 4/5 columns will have different values from both lists, but the remaining column is for dates. Both lists' 'Dates' Column are of ...
0
votes
1
answer
922
views
"Application Defined or Object Defined" error '1004"
I get the 1004 runtime error for "Application Defined ... Defined"
and with some formatting adjustments
I get the 1004 runtime error "The sort reference is not valid. Make sure that it's within ...
1
vote
1
answer
966
views
How do you sort in Excel using two pairs of cells?
I am working on a spreadsheet where I have certain data organised in this format:
Row 1: [Train Origin]
Row 2: [Train Destination]
Row 3: [Train Code]
The items are organised in ...
3
votes
2
answers
1k
views
How do I reorder sheets in specific order, then alphabetically?
I need to reorder my sheets in a specific order, then if there are any left, do it alphabetically. I have the macro below to reorder them alphabetically.
If i have sheets ""METALS", "SVOC", "GENCHEM"...
2
votes
3
answers
2k
views
Sorting data without mixing rows
I have three sheets. First sheet renamed General:
Dave Henderson 21/05/2014
Elton Rus 22/06/2014
John Smith 20/05/2015
Second sheet renamed Licence:...
0
votes
0
answers
1k
views
Excel 2010 VBA AutoFilter and AutoFilter.Sort criterion not applying
I'm having a heck of a time getting AutoFilter criteria to apply, both the filtering and sorting. I'm trying to get rid of blank rows and filter over multiple criteria - simple, right? Except it doesn'...
0
votes
1
answer
743
views
Excel: Copy all cell values from an entire sheet to a new sheet, sort and deduplicate into a single list of unique values
The data (all text values) I have is scattered across the sheet (multiple rows and columns with gaps inbetween) and it is all calculated using formulas
now I would like to make sure that I know what ...
1
vote
1
answer
832
views
Office 2007: How to sort an Excel Table from within a Word macro
I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines:
Dim Oxl_Sheet As Object
Set Oxl_Sheet = ...