Auto Populating Columns In One Sheet From Another Based On Criteria
I've been trying for some time now to figure out how to have one sheet automatically fill in another based on a larger data sheet. I'm trying to find a way to take a monthly calendar which contains a row for each employee and column for each day and use that to create smaller lists on another sheet. Basically if someone puts in for a day off, or has a medical appointment etc, that person has a coded single letter for that day for tracking and planning purposes. I want to have a second sheet that references those codes and makes individual lists (the following people are on vacation, these people have a medical appointment etc.)
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Populating Data From One Sheet To Another Based On Selection
I need help to create a formula that would grab data from one sheet and populate another sheet based on the employee that is selected from a drop down list. Attached is a draft of what I am looking to do. Basically this would allow us to enter employee variances from several employees on one sheet and get a detailed break down of their history on another sheet.
View Replies!
View Related
Auto-enter Data Based On Criteria
Here's a sample of a completed table I would like to have. Sheet2 *ABCDEFGHIJKL68*# ofSTART*wk #wk #wk #wk #wk #wk #wk #wk #69ACCTWEEKSWKRATE1234567870110181 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 71110242 $ * * * *10.00 * $ *10.00 $ *10.00 $ *10.00 $ *10.00 ***72120143 $ * * * *10.00 ** $ *10.00 $ *10.00 $ *10.00 $ *10.00 **73120272 $ * * * *10.00 * $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 74120381 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 75130151 $ * * * *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 $ *10.00 *** Excel tables to the web >> Excel Jeanie HTML 4 If given columns B and C, is there a VBA code that will look to those columns and auto-enter the payments across the week matrix based on that criteria?
View Replies!
View Related
Auto-Populating Calendar
I am looking for an excel calendar that will auto-populate content into it based on a spreadsheet that I fill in. Maybe I would just need the formula that would be inserted into each calendar day? I'm not sure how you would set this up, but I'm open to suggestions! I have attached the .xls file for your reference. For example: The comment "Client 1 - KOM" would populate in a blank calendar in excel on the date 3/23/2009.
View Replies!
View Related
Cell Auto Populating
I need column B to self populate cells with "1" if a specific range of room numbers are entered in column A. Is this possible? Column A, room numbers from all over hospital. Column B auto populate "1" if rooms ranging from M570 to M590 in Column A
View Replies!
View Related
Auto Populating A Field In A Spreadsheet
I have a spreadsheet where I keep track of sales that I make in ebay. The spreadsheet has the following columns: Name, Product, Prod Cost, Shipping Cost, Payment Received, Total. I have made a list way off the the right of the spreadsheet with all the products that I sell, so in the "Product" column I can use a pulldown menu and choose the item from the list. However, I was wondering if I could create it in such a way that when I chose the item from the list, it would automatically put the cost in the "Product Cost" field. Is this possible?
View Replies!
View Related
Auto Populating A Text Box
i have a form that in excel using the Active X Controls thanks from the help on this board the form is working a great and praised by peers for the simplicity and design. Anyway i would now like to add some code that will auto populate certain text boxes with information held on the PC? The information is held on the PC so info like Environ$("USERNAME") etc.... what i would like is when the user opens the form these fields are populated with this information.. I have had a go but still cannot get it to work... Here is my attempt Private Sub staffno_Change() staffno.Text = Environ$("USERNAME") 'Users Staff ID End Sub
View Replies!
View Related
Auto Populating Cells From A Date Range
Basically i am trying to auto populate cells using two dates as the parameters, set up is A1 - Start Date B1 - Finish Date C1 - Jan 07 D1 - Feb 07 E1 - Mar 07....and this carries on across till the end of the year. What i am wanting excel to do is to be able to put in a start date and finish date in to the relevant cells.....this then populates a fixed figure across in to the correct month. Eg start date 05/07/07 finish date 17/10/07 This then puts in the figure 0.2 in to each cell that correspond with each month....July 07/Aug 07/Sep 07/Oct 07. So in effect it is giving a gantt chart but with data in it. One more thing....the start and finish dates could well be out of the range..... eg so start could be 07/08/06 and end could be 18/04/07 which would mean that all of the fields would need populating.
View Replies!
View Related
Look Up Value From Master Sheet Based On Criteria In Current Sheet
I'm trying to create a function in a template invioce that will look up a value in another spread sheet (fees).The data will be based off three values entered in the invioce from drop down boxes. I've attached the workbook with the master sheet and the invioce (sheet 5) The three criteria that can be selected is the project, month and name and I want the amount of hours to be returned based on that information in column e. The projects are seperated and billed by month.
View Replies!
View Related
Auto-populating Starting Times From 1 Format To The Other -VBA Required
If you look at schedule.jpg you will see a how our work schedules are formatted. Then if you look at schedule2.jpg, you will see what I wish to convert it to. Now I'm looking for a way to search by the name of our employee (2 seperate sheets) and then by the time which corresponds to the first "1" in the chart under that name and the last "1" in the chart under that name. So once I fill out our schedule.jpg, it will auto-populate the times on schedule2.jpg. Is this even possible? If necessary, I will be able to put both schedule and schedule 2 on one sheet. On schedule.jpg time starts at 7:00 - Column C and ends at 8:00 - Column AC
View Replies!
View Related
Hiding Columns Based On Criteria
I need to run this funtion from the starting column (N) to the last column ( dynamic). Sub HideUnits() Dim rngData As Range, rngHide As Range Application. ScreenUpdating = False With Sheet1 .Rows(1).Insert .Range("B1").Value = "Temp" Set rngData = .Range("N1:N" & .Cells(Rows.Count, "N").End(xlUp).Row) rngData. AutoFilter field:=1, Criteria1:="*Units" Set rngHide = rngData.SpecialCells(xlCellTypeVisible) rngData.AutoFilter rngHide.EntireRow.Hidden = True .Rows(1).Delete End With Application.ScreenUpdating = True End Sub As you might be able to tell I need to hide all the columns with a specific word in the heading. I'm pretty sure I'd need to loop this somehow, but I'm not good with VBA.
View Replies!
View Related
Replace Text In X Columns Based On X Criteria
I've attatched the workbook here with some dummy values in place of financial figures (We don't base our profit on RAND() formula's ) Essentially, I would like to search for CAN in A and SER in B and if they're found, to alter them to SYD (A) and CAN (2). It's essentially an automatic find and replace, but based on 2 criterias rather than one.
View Replies!
View Related
Find A Value Based On Criteria In Columns And Rows
I have a workbook in which I have two sheets. One sheet is a report and the other is a data dump. The data dump has headers in in column A starting in cell A6 and headers in row 5 starting in cell B5. There is then data going from B6:J20. In my report I then I have same setup with headers in column A and row 5. The difference is that the headers are not in the same order as the dump. What formula could I use that would look for the two headers in my report sheet and then match it with the value in the data dump that uses the same two headers?
View Replies!
View Related
Match Two Columns Across Sheets And Based On Criteria Of Another Column
This is driving me nuts. What I have is: Sheet1: ColumnB - number stored as text (Work ID) Remaining Columns: - mixed data, some columsn numbers, some text Sheet 2 ColumnA - number stored as text (Work ID) ColumnB:ColumnAW - mixed data, some columsn numbers, some text CollumnAX - Dollar Values What I want is in Column F (Sheet1) a formula to: if workID in Sheet1!ColumnB is present in Sheet2!ColumnA AND Sheet2!ColumnAX>1 then return True
View Replies!
View Related
Transpose Multiple Columns To Rows Based On Criteria
I am stumped on how to transpose multiple columns to rows based on specific criteria. Here is an example of the data I am working with: Acct #Rev CodeUnitsCharges10094537034503$0.0010094537034501$605.0010094537037101$0.0010096359034503$0.0010096359034501$355.0010096359037101$0.00 I want it to look like the following: Acct #Rev CodeUnitsChargesRev CodeUnitsChargesRev CodeUnitsCharges10094537034503$0.004501$605.007101$0.0010096359034503$0.004501$355.007101$0.00 I should note that there is oftentimes more than three rows for the same account number, sometimes it could be as many as 20 rows for the same account.
View Replies!
View Related
Populating Multiple Cells By Entering In Criteria
I am adding a sheet with a graph I made. There are two sheets, the first with the graph, the second with tables. What I would like to do is populate the graph based off what is entered into the tables. My main goal is to get the cells in the cells in the graph for each day to fill in color between the given time frame entered in on the table. Obviously I would be rounding up or down to make the time end in ":00." The color I would like to fill the graph with is shown on the graph sheet. Also, if anyone can actually get this to work (I honestly wouldn't know where to start) Is there a way to have multiple colors and a possible overlay of colors? Lets say on tuesday I have 10:00-15:00, and 12:00-18:00. Can I have two colors populate the cells and a thirs color populate the cells in the overlay which would be 12:00-15:00?
View Replies!
View Related
Populating Cell Only If Multiple Criteria Matches ...
I have two worksheets. The first contains a list of software (some having duplicate listings) in column A and a list of comments in column B. None of the software titles that have duplicates will have comments. The second worksheet contains a condensed list of software (the previous list without the duplicates) and a column for the comments. I need to have a formula that populates the second worksheet comments cells with the corresponding comments from worksheet one only if: (1) The software title in worksheet two matches the software title in worksheet one (2) The comment cell in worksheet one contains a comment (or text) I have had only partial success; my obstacle being the duplicate software titles in worksheet one.
View Replies!
View Related
Return Multiple Values Across Columns And Rows Based On Criteria
I have a table with column headings of product ID Numbers (eg.1111) and row headings of Store number (Eg.1) with data showing the time each product was last sold at that store, I need something to consolidate for each store which Product ID's were sold prior to 5pm and what time they were sold. EG Store 1 1111 16:40 2222 13:00 Store 2 1111 15:05 3333 16:50
View Replies!
View Related
Auto Copy Part Of Row In A Worksheet To Another Worksheet Based On Criteria
I'm a novice Excel 2007 user and appreciate all the help I can get. I have a workbook with monthly worksheets in it. When a certain data Type is selected from a drop down menu in that monthly worksheet than I would like to have it automatically enter specific data (Name, Date, Eval, Type) copied to another worksheet (CC) in the same workbook. I have been manually entering the data so far. Another thing, some of the data will be entered into the Monthly worksheets and some will only be manually entered into the CC worksheet so it would need to accomodate both methods of data entry. Please let me know if I need to clarify. I have attached the workbood, too.
View Replies!
View Related
Return Data To Another Sheet Based On Criteria
Sheet 1 Column A = Dates Row 1 = Filenames I enter a Y in the intersecting cells of the Filenames & Dates to show which files were downloaded. I need is a formula that will rearrange this layout onto Sheet 2 so that each ‘Y’ (downloaded) filename is inserted in a cell corresponding to the Date. (see attached sample)
View Replies!
View Related
Display Values Of Another Sheet Based On Criteria
I need to display values from cells of sheet1 and sheet2 as comment in Corresponding cells of sheet3 whose value in sheet3 is FALSE Sub try() Dim Sheet1cellval As String, Sheet2cellval As String Worksheets("Sheet3").Range("A1:D4").Select Dim cell As Range For Each cell In Selection If Worksheets("Sheet3").cell.Value = False Then cell.AddComment cell.Comment.Visible = False 'Getting the value of Cell in Sheet1 for the corresponding cell in Sheet3 whose value is FALSE Sheet1cellval= Worksheets("Sheet1").cell.value 'Getting the value of Cell in Sheet2 for the corresponding cell in Sheet3 whose value is FALSE Sheet2cellval = Worksheets("Sheet2").cell.value 'Displaying the values of cells in Sheet1 and 2 as comment for the corresponding cells in Sheet3 Worksheets("Sheet3").cell.Comment.Text Text:="Difference" & Chr(10) & Chr(10) & "Sheet1: " & Reportcellval & Chr(10) & Sheet2cellval & Chr(10) & ""
View Replies!
View Related
Macro To Copy Data To Other Sheet Based On Criteria...
We're working with a large workbook with data from A5:P20000 on sheet1. I need to be able to pull data from sheet1 to sheet2 based on the invoice number in column A on sheet2. Sheet2 will have different invoice numbers in column A, some of these invoices numbers are in column H on sheet1. I need excel to find these invoice numbers and copy the data from that row on sheet2 to the row with that invoice number on column2. Example: Sheet2 A5 has invoice number 1234457 This same invoice number is located on sheet1 H3400 Need to copy to sheet2 (starting in cell B5) the following cells from sheet1 (B3400, C3400, E3400, G3400, H3400, I3400, J3400, K3400, M3400, N3400).
View Replies!
View Related
Copy Paste Multiple Criteria Based Rows To New Sheet
I need to copy specific rows that have a specific value in colum B and Colum M to new worksheets. So from attached screenshot , say for an example macro shud filter rows that have "BigPond" in coloum B ,"RG2" in column M & "INT" in column W and i dont want all cells in these rows , i only want copy cells under column C,AK,AL,AM (in this order) to my other excel sheet that is named "BigPond" and it should paste it starting from Row5? I want to avoid recording a macro as it selects a range and i am expecting more new rows every week so if a record a macro the cell range for selection changes and i get incorrect result.
View Replies!
View Related
Copy Based On Column Criteria & Append To Another Sheet
I have a spreadsheet that is used to store statistical information on a monthly basis, some of this information may be incomplete and so will need to be acted upon month by month, What I need to do using VBA is: At the close of the spreadsheet check sheet1 and if there is any data (text) in cells N – Q on any line If there is move to sheet3 check for the next blank line then paste the data from only certain fields i.e. A,B, N-Q,R,S Here is another problem As the sheet will be used on and off during the month I don’t want data that is already been moved across to sheet3 to be copied again so there needs to be someway of checking if the info is already there? I have code now for the find last cell part of the problem. Sub FindLastCell() Dim LastCell As Range With ActiveSheet Set LastCell = .Cells(.Rows.Count, "A").End(xlUp) If IsEmpty(LastCell) Then 'do nothing Else Set LastCell = LastCell.Offset(1, 0) End If End With LastCell.Select End Sub
View Replies!
View Related
Copy Data On New Lines From A Source Sheet Based On Criteria
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
View Replies!
View Related
Populating From One Sheet To Another, By Date
I am trying to total up by a Range of Dates some information from one page to another through VBA. I am having a tough time with this one, I can't seem to get the correct information over to the other page. I have successfully been able to transfer the data via a series of SUMIF statements, but it really is very inefficient and takes a while when the data repopulated by another program. So I am trying to do it via VBA.
View Replies!
View Related
Populating Combobox Based On Selection Of Another
I have a problem involving two combo boxes in a user form. I need to populate different “lists” to combo 2, based on a selection in combo 1. I browsed through the forum but could not find any solution that made sense to me. Here are the specifics: Combo 1 (called Cbo_Act) is populated with a list based on a named range in one of the sheets. The range is named “activity” and holds 2 records (“Income” & “Expense”). This list is loaded as part of the form initialization. If the user select “Income”, I need combo 2 (called Cbo_Act_Type) to show a list of various income types (derived from a dynamic named range called “Income_type”) and if the user selects “Expense”, I need the same combo box (Cbo_Act_Type) to show a different list, specifically – a list of various expense types (derived from a dynamic named range called “Expense_type”). I know that this should be with a Cbo_Act_Change () routine, but for the life of me, I can’t figure out how to do it.
View Replies!
View Related
Copy Rows Based On Criteria, Paste As Values To New Sheet & Sort
I have spent a few days searching through forums but cannot find examples that i have been able to successfully adapt ( because they are to complicated for my limited knowledge). I have a workbook with 5 sheets, sheet1 (current), and sheet 4 (archive) are the important ones. I need a macro to A) copy rows from "current" to "archive" ( to the 1st empty row) if column S of "current" contains "Closed" ( the word is generated by formula). B) The paste needs to paste special values and number formats ( want to lose formula but not conditional formatting). C) data sort "archives" based on col A - this puts the newly archived data into correct sequence.Data sort lowest number 1st D) delete the copied rows from "current". e) give me a count of how many rows it deleted, (I have a macro to insert rows so will run that manually to recreate the correct number of emtpy rows (with formula and formatting) to bring the current sheet back to usual size. I tried modifying a macro by RPaulson (based on cells on one sheet to cells on another), to work with entire rows but couldn't get it to work. Found that paste special uses PasteSpecial xlPasteValues, but , and thats about it.
View Replies!
View Related
Summarize Columns, Based On Unique Value, Into 1 Sheet With Cell Addresses
I have the following code always throwing this error message: "subscript out of range". When i run the macro with worksheets that only have 10 rows each, it's running fine. I suspect some issues on the line: a = Range("a1"). CurrentRegion.Resize(, 3) - the debug always throws the error before entering the loop. This macro is supposed to find the lowest price among 3 spreadsheets by matching the "Code" column and sending the final result into a new spreadsheet. But since im trying to run the macro on spreadsheets holding over 6000 lines each, this error is appearing. Sub kTest_v2() Dim a, w(), i As Long, z, dic As Object Dim MySheets, ws As Worksheet, MinPrice MySheets = Array("Sheet1", "Sheet2", "Sheet3") 'change to suit Set dic = CreateObject("scripting.dictionary") dic.comparemode = vbTextCompare For Each ws In Sheets(MySheets) With ws .Activate 'assume Col A Country, Col B Code and Col C Price a = Range("a1").CurrentRegion.Resize(, 3) End With For i = 2 To UBound(a, 1) 'assume column heading. if not replace 2 with 1 If Not IsEmpty(a(i, 1)) Then If Not dic.exists(a(i, 2)) Then Redim w(1 To 4): w(1) = a(i, 1) 'Country w(2) = a(i, 2) 'Code w(3) = a(i, 3) 'Price w(4) = Cells(i, 1).Address(external:=True) 'cell address dic.Add a(i, 2), w Else.............................
View Replies!
View Related
Populating A Data Validation List Based On...
I want to populate a Data Validation based on values in another cell on another worksheet--but, I want to populate it with the values stored in the cell right next to the cell. http://i32.photobucket.com/albums/d3...n/untitled.jpg. would be an example.... What I want my Data Validation List to do is to look at column B and wherever it sees a certain color--for example, red, I want it to put the corresponding value in column A in the list.
View Replies!
View Related
Populating A List Based On Four Toher Lists
I have Columns A:D with a heading at the top. the user can then type organisation names under the correct column. There is a maximum of 30 entries (rows 2:32). Problem One: Column E is a hidden column and I need cells E2 and downwards to be a list which gets populated by ALL the organisation names inserted into $A$2:$D$32. I don't want there to be any blank cells until the last entry in column E (if that makes sense). how to populate this list? Problem Two: At another part of the worksheet, I have five cell where the user has to select from a list. The five cells correspond to the lists in columns A:E. Is there any way to avoid having blank options in a list using data validation (say if the user has not entered 30 organisations into one of the columns)?
View Replies!
View Related
Populating Two Listboxes With Sheets Based On Cell Value; Printing Their Selection
I would like to do is have 2 listboxes. In the first listbox I would like the name of all the worksheets which contain the words "elective class: " in cell C7. In the second listbox I would like the name of all the worksheets which do not contain the words "elective class: " in C7. I need this only to source from worksheet 7 onwards however. The listboxes are called ListBox1 and ListBox2 respectively. Also I am using this to print and I have a button which currently selects all the data in the first listbox and another button which prints all the selected data. The code being used for this is:
View Replies!
View Related
Populating Combobox 2 With Items That Match Criteria From Combobox 1
Am trying to get dynamic population of 2nd combobox based on match from criteria in combobox 1. if column a = bears and column b = colours of bears then when I select bears in combobox one, combobox 2 would populate with colors of bear. I am think of having a combobox 1 change event that evaluates each row in a specific range (does it match the criteria?) if so, then add 2nd cell (column b) of that row to the combobox 2. I know it would probably involve match and offset, add item and loop, but I am not sure what the syntax is.
View Replies!
View Related
Auto Duplicate Row Contents From One Sheet To 2nd Sheet If Column Contains Set Words
I want to end up with is when I type text in any row of the 'Master' sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (referred to by text entered in column O). For example row 5's contents from the Master sheet would duplicate into the sheet named 'Accommodation' as O5 contains the word Accommodation. In addition, should the details ever change in the Master, this would also need to be reflected in the individual sheets. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie if row 5 had the first occurrence of the word Accommodation in column O, the contents of that row would be placed into the next available first blank row of the Accommodation sheet, which in this case would be row 2 as the headings are on row 1.
View Replies!
View Related
Auto Duplicate Row Contents From 1 Sheet To 2nd Sheet If Column Contains Set Words
I want to end up with is when I type text in any row of the Master sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (as per column O). For example row 5's contents from the Master sheet would duplicate into the sheet named Accommodation. In addition, should the details ever change in the Master, this would need to be reflected in the individual sheets also. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie row 5's contents to be placed into row 2 of the Accommodation sheet seeing as it's the first occurrence, and row 6's would go into row 3 etc.
View Replies!
View Related
Create New Sheet For Each Row Of Another Sheet Auto Populate Data.
i have a sheet called 'sample database'. it consists of 56 columns, each with a specific title in row 1. i.e. name, surname, mobile_number, and so on. from row 2 onwards the data has been populated for roughly 200 rows. i have another 'Capture Sheet' which has the same titles as 'Sample database' except it's in a different format. its a printable form that is given to new employees when they start. once they have completed it it gets captured into the 'Sample Database' sheet. my wifes boss now wants 1 new sheet for each row in the 'sample database' sheet based on the format/layout of the 'capture form'. how can i get the 'capture form' to auto populate the data from the 'sample database' sheet and create a new sheet for each row? i know this is possible i just dont know how to do it.
View Replies!
View Related
Sum Range Based On 1 Criteria Of Column & 2 Criteria Of Another
i m trying to use the sumproduct formula, and OR but i cannot seem to get this right! =Sumproduct(--(A1:A10="Yes"),--(OR(B1:B10="Yes",B1:B10="Mayby")),C1:C10) I have also tried Array Formula as follows; {=SUM(IF(A1:A10="Yes",IF(OR(B1:B10="Yes",B1:B10="Mayby"),C1:C10)))} I have also used UDF to for the sumproduct, but cannot make that work! keep giving me value message Function Function Customer(Service as Range, Outcome as String, Service2 as Range, Outcome2 as String) Customer = Sumproduct(--(Service = Outcome),--(Service2 = Outcome2), Result) -Didnt get thru this bit to start building on the Function! keep giving me #Value!
View Replies!
View Related
Populating "band" Based On Value In Another Column
I am trying to populate Column BB based on data in BA. Explanation: If BA2 is less than 1, BB2 should equal "00-01". This should run until BA is blank. Sample value in BA: 6.68. I'll paste in my code which is causing a run time error 13 type mismatch error starting with the line in red below. I wonder if I am even close? Dim m As Long For m = 2 To Range("BA65536").End(xlUp).Row Select Case Cells(m, 53).Value Case Is < 1 'line where error starts Cells(m, 54) = "00 - 01" Case 1.1 To 2 Cells(m, 54) = "01 - 02" Case 2.1 To 3 Cells(m, 54) = "02 - 03" Case 3.1 To 4 Cells(m, 54) = "03 - 04" Case 4.1 To 5 Cells(m, 54) = "04 - 05" Case Else Cells(m, 54) = ">5" End Select Next m
View Replies!
View Related
Auto-Sort Columns
I am trying to create a VBA macro that autosorts a selection of columns by column A. I currently have the below already written which gives the desired effect. I was just wondering if there was a way i could have this script constantly running on the sheet so it is always sorted correctly without me having to click Run Macro everytime. Sub Macro1() Columns("A:F").Select Selection.Sort Key1:= Range("A1"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub
View Replies!
View Related
|
TRACKER
