Sorting And Copying Results Into New Work Sheets

Jun 3, 2009

I have a work sheet with about 35,000 lines of data. Every day I have to sort the list by product category (I use auto filter to separate) and then copy the results into a new worksheet, there are about 300 product catagories. I'm new to macros but I'm wondering if there is a macro that can automate this process.

View 6 Replies


Filtering Ranges And Copying Results To New Sheets?

Jul 5, 2014

I want the following script to:

1) Find and define a range ("DateRng") based on cell values. This is controlled by the first block and the script does this job correctly.

2) Find cells

View 1 Replies View Related

Copying VB To Multiple Sheets In Multiple Work Books

Mar 6, 2007

Ive put some sheet code together that i need copied to 12 sheets (jan to December) in 24 workbooks (each workbook has trhe same sheet names). I dont want to alter the actual content of the Excel sheets, I just need to copy VB code from a template (in VB editor) to the 12 sheets in each of the workbooks. Is this possible to do with VB or do i need some other utility since Im using the VB editor....

View 9 Replies View Related

Copying A Certain Range In A Work Sheet To Another Existing Work Sheet Using VBA

Dec 29, 2009

I have a range of cells in a work sheet "sheet 1 " my objective is to filter this range according to certain criteria (i ve succeeded to do this ) yet what i want to do now is copy this data to another existing worksheet in a certain range .

note :the existing worksheet to which i 'll copy the filtered data has some cells out of the range that i dont want to over write ..

Simply :how to copy a selected range of cells in a work sheet to already existing work sheet in a specific range aswell .

View 9 Replies View Related

Can't Get CONCATENATE To Work. No Results.

Oct 20, 2009

I have built a formula using CONCATENATE. (Built in G2) When I copy and paste it into a empty cell (E2), one that is formatted as General and is not locked, as text or value or a formula I get the same results. It always shows up as text. I can't get the formula to function and show the results in the cell (E2). Yet, when I singularly build the formula in the cell it works fine. But the moving (cut and paste) from one cell to the other doesn't work.
The concatenated formula is: =CONCATENATE("=LEFT(",G2,",",H2,")") The result is: =LEFT(B2,3) . These results look fine, yet only when built in the cell using Excel's Insert Function builder or doing it by hand it works fine. It returns the first 3 numbers/text from the left side of cell B2. But the data that should result from the concatenated formula and pasted in to the cell (E2) is not showing up as needed. Any help would be appreciated.

View 11 Replies View Related

Sorting Results With IF Statement

Dec 28, 2007

Here is a sample of my data in the column starting at I2:

1600 (I2)
57000 (I3)
256000 (I4)
5700000 (I5)

I want to sort results so that the adjacent column gives a ranking code of "A" , "B" , "C" or "F"

my requiremetns are:

iF I2 = less than 65,500 then "A"

IF I2 = 65001 - 250000 then "B"

If I2 = 250001 - 1,000,000 then "C"

If I2 > 1,000,000 then F

The folks at "A" are above average, "B" are average, "C" below aveage with significant concerns and "F" are Critical nonformance, immediate action required.

Of course I plan to copy the formula down the range.

View 9 Replies View Related

Sorting Results Of Subtotals

Jan 4, 2009

how to sort the results of a sheet that I have subtotaled twice by sum?

View 9 Replies View Related

Sorting Macro :: Assign Work Shifts

Jan 10, 2007

I need a macro that will take a list of 42 names and 27 locations. The names are broken down into group of shifts, 1 shift, 2nd shift and 3rd shift. We need to perform audits on the 27 locations in groups of 2 people at a time. What I'd like is a macro that would take all the names by shift and assign 2 random people to a location. All 27 locations have to be audited each week (safety), and a report filled out and turned into our safety committee. I would like to post the audit sheet with the macro on our shared drive. Can anyone help me with this.

View 9 Replies View Related

Sorting Sheet That References Data From Other Sheets (Google Sheets)

Jan 25, 2014

[URL] ....

I want to sort the Inventory Checklist sheet based on Column D but it gives me nothing but references errors.

View 1 Replies View Related

CUSTOM SORTING Will Not Work On Table With INDEX Formulas

Jan 28, 2014

Problem we are having with sorting a table.

The table (A1:E10) was created by pulling data from another worksheet using INDEX and ARRAY formulas.

We inserted 6 columns to move the table over to G1:K10 (used column F to space the two tables).

We then duplicated the table: cell A1=G1, B1=H1, ...., E1=K1 and dragged the formulas down. We now have a duplicate table that we want to sort.

We choose CUSTOM SORT and choose 2 levels of sorting ... column A and column C.

PROBLEM: The ARRAY formulation evidently overrides the sort function because the table remains as it was when the sorting command is executed.

Is there a way to bring the data from table G1:K10 over to table A1:E10 in a manner that will allow sorting??

View 9 Replies View Related

Best Way To Graphically Show Results Of Time / Work Study

Feb 23, 2012

I am trying to determine the best way to graphically show the results of a time/work study. Basically i have a list of tasks and each list has 2 sets of numbers assigned to it. One for how much time it takes on a scale of 1-3 and a second for how much value is added for the task, again on a scale of 1-3. I want to show some sort of graph/visual that shows the number of tasks as clusters (not name of task) in maybe quadrants. With the time on X axis and value on Y axis. I am envisioning something like a 9 box that would have low/low to high/high. I can only think to create a 9 box in excel and physically put circles(clusters) in each quadrant.

View 2 Replies View Related

Sorting A Column, But Placing Results In A Different Worksheet

Jan 2, 2008

I have a simple one-column section (column A) of values in Sheet1:


I would like to sort this, but have the sorted results displayed in Column-A of Sheet2.

How can I do this?

Note: I need to be able build flexibility into this such that I can add names to the bottom of the list in Sheet1, knowing that the results in Sheet2 will be able to accomodate the additions.

View 9 Replies View Related

Table Sort Results In 1 Column Sorting

Jan 30, 2008

In my example file are 4 columns. I placed auto filter to columns B and C. If column B sorted to ascending then this changes formulas in column D. I attached workbook also to understand my problem. If you try to sort column B to ascending you will see the problem in column D

View 4 Replies View Related

Sorting Of Results Using Index / Match / Large And Other Formulas?

Jul 16, 2012

how to return the top 5 results in a set of data.

In a nutshell, I have data that needs to be sorted but some intermediate to advanced (to me) excel formula needs to be used to sort the ranking properly. I've already used index, match and large but it does not suffice.

View 1 Replies View Related

Copying Dates Into New Spreadsheet Does Not Seem To Work?

Jun 10, 2014

When I copy the dates from this spreadsheet into a new one, in the new spreadsheet the copied dates are different. Looks crazy. Why does this happen?

View 14 Replies View Related

Copying Only Values With VBA Below Other Results?

Apr 25, 2014

I have a file where I have few sheets (link to file below). Sheet zrzut is dropdown from other system - updated daily. Sheet Productivity is filled with data supporting to group data and add conditions (for example column "I" in "zrzut" sheet). Sheet "Vena" has data from "zrzut" based on condition in column "I". Sheet "VENA_PLAN" has the same data as "Vena" but only values - I need only values for other actions. The thing is my current code replaces old data with new, but what I would like to achieve is to have new data stored below old. For now code looks like

Sub PlanVENA()
Application.ScreenUpdating = False
Worksheets("VENA_PLAN").Range("A3:H300").Value =


View 4 Replies View Related

Cannot Work Out The Debug With Copying Static Date

Nov 20, 2009

I'm trying to create vehicle maintenance inspection program for a mechanic at work. The trouble is the he's not fond of computer and I'm trying to make it as simple as possible. There's a debug in the line

View 2 Replies View Related

Copying Work Sheet Into Multiple Times

Nov 2, 2008

I have one Excell Book with two work sheets. The 1st sheet (Sheet Name : Data ) contains the data... and in the 2nd sheet (Sheet Name : Rekey) i have a specific form in Rekey sheet and some data in Data sheet. Now i have to copy Rekey sheet into multiple times .... with different sheet names... and the sheet name are in Data sheet from cell A2 to end.....

For e.g. in Data Sheet cell A2 contins work1 and cell A3 contains work2 and A4 contains work3..... and so on....

Rekey sheet contains some form....

I need to paste Rekey sheet multiple times with sheet name work1, work2, work3..... and so on....

View 9 Replies View Related

Linking Filters And Copying Results

May 27, 2008

what i have is a workbook with 4 worksheets. each is a list of tapes that i use for back ups.

each worksheet has a auto filter so that i can filter by the day i need to use the tape. i.e. when i select monday it displays mondays tapes only.

what i want to do is take the result from this and copy it into another sheet so when i select tuesday it copys onto a 5th sheet in a specific area.

i would also like it to change the day on all sheets filters from a single drop down. i cant put everything on one sheet as there are duplicate tapes and days.

View 10 Replies View Related

Copying Results From An Autofilter To A New Worksheet

Aug 27, 2009

I'm working on a quote template that has 600+ products with descriptions and prices that gets autofiltered down to one product. After it has been filtered down to that one product how do I link that to a new worksheet?

View 9 Replies View Related

Comparing Two Worksheets And Copying Results To Another

Feb 27, 2007

In my attached example you can see I have Sheet "Computer" & Sheet "RHN" both have a number of columns, but all I want is to compare Column A of "Computer" with Column A of "RHN" and copy all entires found in A "Computer" and not found in A "RHN" to a new sheet!

View 4 Replies View Related

Merging Sheets / Copying Cells From X Sheets Into 1 Sheet

Feb 22, 2013

I have merged 336 individual spreadsheets into one book, now I want to merge the data in all the sheets into 1 individual sheet. All the sheets have the same size and range, I need to copy a constant range(row,column) from all the different sheets into one.

What VBA functions to use???

View 4 Replies View Related

Numerically Sorting Columns And Copying To Separate Page

Dec 19, 2012

I am working on an excel spreadsheet that has multiple "sheets" to it. On the first sheet I have multiple columns worth of info and on the second sheet I am trying to copy some of the info from the first sheet.

For example:

Sheet 1, Column A2 has the number 1 in it.

On sheet 2 I have entered the command "=SHEET1A2" and it copies the info as I had hoped.

However, here is where my issue comes into place.

When I sort Column A on sheet 1 numerically, my answer on sheet 2 changes to whatever the new number is in box A2 on sheet 1.

Is there a way I can copy the info so that it changes as I sort the column numerically or alphabetically?

View 1 Replies View Related

Copying 2 Columns In One Sheet To All Other Sheets (except 2 Sheets)

May 25, 2014

i wanna copy C and D columns in Sheet1 and insert these 2 columns (copy + insert copy cells function, not copy + paste) to all other sheets except Infopage sheet

View 14 Replies View Related

Copy Cells So That Copying Formula Results In References As Shifting Horizontally

May 4, 2014

I began to ponder a way to copy down cells so that the copying of the formulas results in references as shifting horizontally instead of vertically. One particular reason that this occurred to me had to do with my attempting to use Excel to make more orderly text copied from Adobe.

So, for example, if I copied text from Adobe, I would paste it in Excel. Thirty lines of text would past vertically into a column, from Row A1 to Row A30, with each line of text in its own row. I wanted to figure out a way so that in adjacent columns, I could put it so that I would have a set of formulas reading in =A1 in Column C cell/row 1, =A2 in Column D cell 1, =A3 in Column E cell/row 1, =A4 in Column F cell/row 1, =A5 in Column G cell/row 1, and so forth. I realized that if I copied this down, in the second row, the result would entail references to A2, A3, A4, A5, A6. I would prefer that the references update to A6, A7, A8, A9, and A10.

View 5 Replies View Related

Work Book About 20 Sheets In It

Mar 19, 2005

got work book that has about 20 sheets in it.....there are links throught the workbook. sheet in particular when i go to it, it freezes up...and i get the dreaded "Send Error Report to Microsoft" window"...and we all know what happens next.....excel shuts right down.

I can open the workbook and click on ANY sheet....but when i click on this one particular sheet in the book i get the error message

This work book is a template....its the estimating work book i use at work...and whenever i get a new job to estimate i open up this template.....put in my data and save the workbook as the job basically i have about 50 of these workbooks......and it doenst matter which one i open.......whenever i go to this one same sheet in any workbook i get the freeze

and the freaky thing about this is it does it randomly....I make save this template (as a new work book) when i get a new job to estimate.....and i never have any problems.......but today for some crazy reason its doing what i mentioned did this about a month ago too.......same exact problem.

when it happened the first time i tried all kinds of stuff, and the only thing that worked was i had to go to windows all the files to a memory chip.......go to a different pc with my version of windows (XP) each file it.......go back to my pc...reload it

View 9 Replies View Related

Sorting Sheets By Name

Oct 7, 2011

I need to sort my sheets by name, A-Z but as the worksheet names are things like Door 1, Door D67, Door 100 etc, I don't think I can use a simple code like the below, Because i'd end up with Door 1, Door 100, Door 101, Door 2, Door 200......


Sub Sort_Active_Book()
Application.ScreenUpdating = False
Dim i As Integer
Dim j As Integer

[Code] .......

I have this code, which sorts a list of data in cell C17 down to CXXX (the list will keep growing as I add more doors) It works by pasting a formula stored in F17, in Col D, next to my list of doors, and picks out the numbers so that I can sort.


Sub ListSorter()
Dim LastRow As Long
LastRow = Range("C" & Rows.Count).End(xlUp).row
Range("F17").Copy Range("D17")
Application.CutCopyMode = False

[Code] .......

Perhaps I could add some code to the bottom of this, that will sort my worksheet names as per the order of my list in col C?

View 1 Replies View Related

Macro Combining Work Sheets Into One

Mar 14, 2008

I have the below macro in a workbook that I need to combine the two sheets into one, (sheet1 and sheet2). Both sheets in use column "A" for id, but for some reason it is only copying over sheet one? One sheet has 12 columns and the other has 13, not sure if that is making the difference?

View 13 Replies View Related

Code To Work On Some Sheets Only Across All The Books

Nov 14, 2006

I use a code to work on all the sheets across all the files. But now I want the code work only on sheet named Paid across all the files.

Sub PP()
Dim wb As Workbook
Dim ws As Worksheet
Dim varWBnames As Variant
Dim varItem As Variant

varWBnames = Array("Book4.xls", "Book5.xls", "Book6.xls")

For Each varItem In varWBnames
Set wb = Workbooks(varItem)

For Each ws In wb.Worksheets
ws.Range("A1").Formula = "=A2+A3"
Next ws
Next varItem
End Sub

View 9 Replies View Related

Apply Macro To All Work Sheets

Dec 20, 2006

How do I apply 1 Macro to all the sheets in a Work book. That is one Macro should execute the function in all the worksheets of the Workbook.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved