Copy Filtered Data (same Sheet)
I have 5 fields which contain 200 rows of information, I'd like to filter field 1 and have the filtered data copied to K2 of the same worksheet.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Copy Visible Cells From Filtered Sheet
I have data in one column that is the result of a formula, ie: =B2*B3. The result may display a decimal answer that goes out 4 places. My boss likes us to clean this up by using the = ROUND(B4,2). That is fine and easy enough, but the problem is that these numbers maybe spaced throughout a large sheet. I have to filter to make sure similar items are calculated the same way. The problem is that when I copy and paste, it copies and pastes all the data hidden between the displayed cells of the filtered sheet. How do I make it so I am only copying and pasting the data displayed and not the cells that are filtered out in between?
View Replies!
View Related
Copy Filtered Data
I have the code below which filters and copies columns. My issues is that this filters and copies all data. I would like to filter all this data from another column before running the macro. And for this code to only then filter and copy the already 'manually' filtered data. Does anyone know how I might go about doing this? Sub sortdescript2() Dim rngData As Range For Each rngData In Range("E4:CR258").Columns rngData.AutoFilter Field:=1, Criteria1:="<>" rngData.Copy rngData.EntireColumn.Cells(263, 1).PasteSpecial xlPasteValues rngData.AutoFilter Next
View Replies!
View Related
Code 'To Invoice' Copy The Filtered List, And Paste On Sheet
I have recorded a macro to filter data on sheet 'To Invoice' copy the filtered list, and paste on sheet 'Invoice' in C16. The code just keeps looping (not looping in a code sense, it just seems to keep flickering the screen like its going over & over) until it locks up 5-10 seconds-ish and then I have to re-start Excel. The range B2:E22 is not always populated, it could possibly be B2:E2 (one row), I dont know how to copy the exact data so I expanded the range to what I think would capture any eventuality....
View Replies!
View Related
Copy/paste Macros Will Not Copy Filtered Items
The following sub will look in the file ("FY09 SOF"), in column "A", search for the strings that begin with "2109", "3009", or ends in "-1", and copy the entire row. It will then paste these in the file ("FY09 PR Log Blank"). I have found that in the file ("FY09 SOF"), if things are filtered in any row, it will not copy those necessary items. The data filter is on row 13 of each sheet. Is there a way of fixing this? (i.e. having the macros select "all" on the filter before copying the sheet? There are 60 sheets so a macros will be necessary. Sub get_data() Dim wb As Workbook, wbDest As Workbook Dim ws As Worksheet, wsDest As Worksheet Dim lngCalc As Long Dim FoundCells As Range Dim FoundCell As Range Set wb = Workbooks("FY09 SOF") Set wbDest = Workbooks("FY09 PR Log Blank") Set wsDest = wbDest.Worksheets("Paste all here, then sort") With Application .ScreenUpdating = False lngCalc = .Calculation .Calculation = xlCalculationManual End With For Each ws In wb.Worksheets.............................
View Replies!
View Related
Copy Data From One Sheet (Fixed Cells And Sheet) To Another Sheet
I want to be able to copy a name from one sheet (Available Players), paste it to a cell in another sheet (Round 1 through Round 20). The cell that will be copied is fixed but the place where it will be pasted will be different and may be on a different sheet. also i would like to change the color of the copied cell to "greyed" out or cut if it can not be greyed out. I have created a button and put in a macro that i created but have been having problems with it, generic 1004 errors that i can not figure out. i am attaching the document.
View Replies!
View Related
Copy Row From Sheet 1 To Sheet 2 When Data Entered In Cell F
I have Worksheet 1, with columns A to E. I would like a row to be copied to Worksheet 2, as soon as cell F in Worksheet 1 is populated. Also the row to be deleted from Worksheet 1. So, as soon as F1 in worksheet 1 is populated and enter button pressed, row A1:F1 will be copied to the next empty row in worksheet 2, while being deleted from worksheet 1. So eventually all rows in worksheet 1 will be deleted and rows in worksheet 2 will be populated.
View Replies!
View Related
Copy Filtered Range
i have issue copying data from a filtered sheet to another sheet. i only want to copy visible cells....ie when there is no data or data after filtering i have: selection. currentregion.copy. this dosent work as when there is no data it still copies my column headings in row A1 across to row r1 and then to next sheet. how do i write code that will only pick up the filtered data starting in first cell...ie after filtering this could be any number. for example i only want to copy data if row 2 and downwards has data
View Replies!
View Related
Copy Filtered Rows To Another Worksheet
I have filtered data on Sheet1, which I need just columns A, B & C combined and placed on Sheet2. The below code works, but its defined to copy all rows. I'm unsure of what syntax to use for the loop to copy just the filtered data. Also is there a way to "cycle" through the filters? Example Autofilter "1984" copy ABC to Sheet 2, then AutoFilter "1985" copy to sheet 2 and so on? For Each Cell In Sheets("sheet1").Range("A:A") If Cell.Value <> Empty Then i = i + 1 b = Cell.Offset(0, 0).Value & ", " & Cell.Offset(0, 1).Value & " " & Cell.Offset(0, 2).Value Sheets("sheet2").Range("A1").Offset(i - 1, 0) = b End If Next Cell
View Replies!
View Related
Copy Portion Of Filtered List
I need the VB code to copy just a portion of a filtered list. I have completed the code to sort and filter the list. I'm having a problem determining how to define the region needed. I have searched the forums and found a few helpful threads but nothing specific. Most show selecting all the columns of the filtered list. My list is in columns A:AA and begins in row 4 (header row). In my test data, there are 5,900+ records and filtered list is approximately 4,900 records. Since I have sorted the data, the portion of the filtered data I need will always begin in cell D5, be columns D:K, and be the visible rows.
View Replies!
View Related
Copy 1st X From Filtered Range
how I can copy top 15 visible values from a specific column in an autofilter, without actually setting the "top 10" values in the macro for that column. So somehow copy the first 15 cells. The code should fit somehwere in this I guess: Sheets("A").Select Columns(5).Cells.SpecialCells(xlCellTypeVisible).Copy Sheets("B").Select Range("M6").Select ActiveSheet.Paste Could I put an extra variable by the .paste so it only pastes 15 values. Perhaps behind the copy??? I've tried to put .Cells(15) but that doesn't work either, which is a pitty. I'm clueless here, and couldn't find anything regarding this (without using fixed ranges, ...)
View Replies!
View Related
Copy A Filtered Range To Notepad
I would like to copy a column from a filtered range to notepad. The main steps of this method are these: 1.Copy the original range to a blank range(range1) as text and filter 2.Select the required rows and copy 3.paste the values to A1000 (range2) 4.open notepad and set the filename by a cell value 5.paste the range to notepad 6.delete range1 and range2 Unfortunately, I use macros and vb not so often, so I'm not expert in it. I have found two useful code, but I don't know how can I combine them. For step 1 Sub Copy_Filter_Range() ...
View Replies!
View Related
Copy Filtered Results To Another Workbook
I have a large data set (from columns A - I, with over 10,000 rows) of information located on Sheet1 that I need to be able to go through to find the criteria (which is text and is located in column B) I'm looking for. I know how to write the VBA code to use Excel's AutoFilter option .... what I don't know is how can I can identify and copy the results the AutoFilter pulls up, from Sheet1 into another sheet because the data is on a number of different rows. For example, I have to search column B three separate times for the following criteria: 1. xyz 2. acb 3. hij this is what I have for the autofilter: Range("A1:I1").AutoFilter Field:=3, Criteria1:="=xyz" Today, I may find the "xyz" information on rows 6-150, 755-787, 1021, and 8524-8999, whereas tomorrow "xyz" may be on rows 51-101, 8547, and 9989-9991.
View Replies!
View Related
Copy Auto Filtered Range
I'm trying to do is copy filtered data. I select my column and copy it, filtered, no problem. But then my code bugs out when it tries to copy the next column. If Sheets("CT Summary"). Cells(4, 6).Value = "P1264" Then Sheets("Mam Roll-up").Activate 'Copy CEID's. Range("L4:L134").Select Selection.SpecialCells (xlCellTypeVisible) "Selection.SpecialCells (xlCellTypeVisible)" works in the first block, but bugs out on the second.
View Replies!
View Related
Copy Filtered Range Excluding Headings
I need code to copy rows from a filtered list on one worksheet and insert at a specific point in another worksheet. What I would do if doing it manually is to "select the visible cells, copy, go to the other worksheet, select the point I wanted to insert the data and select Insert Copied Cells". When I try to record this with the macro recorder I don't see the option Insert Copied Cells.
View Replies!
View Related
VBA Macro To Copy Filtered Range
This code was provided this forum. It is so close to what I need. The only difference is that I need the copied lines inserted. Actually, I needed Destination to pick EndT2 (on Sheet2), then select one row down from it and then insert what was copied... -R- Sub CopyFilteredRangeNoHeaders() Dim rTable As Range Set rTable = Sheet1. AutoFilter.Range Set rTable = rTable.Resize(rTable.Rows.Count - 1) 'Move new range down to start at the fisrt data row. Set rTable = rTable.Offset(1) rTable.Copy Destination:=Range("EndT2")
View Replies!
View Related
Copy All Data From Data Sheet, Sequence Top Down By Spend, Manually Delete All After 50
I have two sheets, a data sheet with all our customers by ref, name and spend; and a presentation sheet. In the presentation sheet I want to display the ref, name and spend of the Top 50 customers by spend, price high to low. The workaround: Copy all data from data sheet, sequence top down by spend, manually delete all after 50. My only issue is that each month the data sheet will update and I want the Top 50 to auto update, without performing the workaround above. Is there a way to do this without VBA i.e. pivot tables etc
View Replies!
View Related
Copy Filtered Results & Transpose In Many Workbooks
I have a folder with 250 files. Each of the file has only one column. I need to search the rows starting with "Party Name" and copy them in any one row. I want a macro either to copy the filtered results in the same file or a fresh workbook. Column A row 1 ABCDE row 2 FGHI row 3 Party Name:Abcd row 4 JKLM row 5 nopq row 6 STUV row 7 Party Name:ryz row 8 Party Name:mno row 9 XYZ I want the results as below: Column A Column B Column C Column D row 1 ABCDE Party Name:Abcd Party Name:ryz Party Name:mno
View Replies!
View Related
Copy/Paste Filtered Results Less Header Row
Trying to paste filtered results except header row. My code below pastes the header row for "Details" 2x. I tried altering the row to row 2, but that caused incorrect results to be returned. Detail - Sales First I filter the data range for " Total Sales" Paste the results with header row to wsDetails Details - Details Then filter the data again for "N" I would like to paste these results to wsDetails w/o the header Option Explicit Sub comp_pl_ytd_Totals() Dim wbBook As Workbook Dim wsData As Worksheet Dim wsTotals As Worksheet Dim wsDetails As Worksheet Dim wsExtract As Worksheet Dim rngData As Range Dim rngCrit As Range Dim rngDest As Range Dim arrCrit Dim myRange As Range Dim C As Range Dim lngrows As Long Dim strFormula As String Dim rngCase As Range With Application . ScreenUpdating = False .DisplayAlerts = False .Calculation = xlCalculationManual End With................
View Replies!
View Related
Copy Data To Another Sheet
I have a sheet that contains multiple rows of information, i would like to copy the details of the last entry on each row to the corresponding row on the next sheet. Normally this would be the last 3 cells on each row to be copied, but some rows will also contain a couple of cells that may be coloured which would also be required. My question is - firstly - what is the best way of copying the last few cells on multiple rows to another sheet? secondly - is there a way of copying an extra cell or 2 if they are coloured?
View Replies!
View Related
Copy Data From One Sheet To Another
I got the following code from this forum to copy data from one sheet to another. Is it possible to use it with an input box code. So instead of always getting data from a specific range, it may be selected through an input box and copied on desired location with the help of also an input box.
View Replies!
View Related
Look Up Data And Copy Into Another Sheet
All data is organized by date, and to make comparisons easier, the different types of data is in it's own individual column, and different levels of analysis is on different worksheets. "Sheet1": This is the raw data. "Sheet2": What data is valid out of the raw data, (already have a script to only show valid results based on user's input) "Sheet3": 3 days before, and 3 days after each valid date out of sheet2. I'm having a problem figuring out how to make Sheet3 automated. I need some sort of look up function for Sheet2, and copy and paste the seven raw data points into Sheet3 (As in the screenshot above). I am currently doing it manually and it's very frustrating on thousands of data points.
View Replies!
View Related
How To Copy Selected Data From One Sheet To Another
Hi excel masters, I have questions on how to built a macro to copy selected the data from one sheet (contains data) to a summary sheet, I used excel 2007. The macro I want to run to achive those result: The data on the data sheet listed similar like below: in first column (contains name) as below, xx xx xx xx yy yy zz zz in the summary sheet, I want to copy one particular name from datasheet to cell A17 and below, based on the the selection criteria I enter in cell B1. For example, if I want to show xx in summary sheet, I input xx in cell B1, and run macro to list xx one by one from A17, A18, A19.... I need to macro to run to search entire list to include the value I selected.
View Replies!
View Related
Copy Only Data In Some Columns To Another Sheet
I am trying to copy rows that match a date range but I only want some of the columns to be copied to a pre-defined sheet. For example, if the row is selected as a match because it is within the desired date range, I want the data in columns 'A-F', 'I-J','N-O' to be copied to the sheet 'Report' starting in 'A3'.
View Replies!
View Related
On Value Change Copy Data To Another Sheet
I have a sheet in Excel (sheet 1)which reads in eleven values. If the data in the 11th value changes then I would like to copy the other 10 values to sheet 2 appending to previous values copied. Date and time on each copy would also be nice if possible. The values in sheet 1 are being read in via an OPC server from a machine and only change at the and of a batch which could take a few hours. We are trying to gather this information as a test just for stocking levels on a short term basis. We may look at a more sophisticated method after our trial period is completed.
View Replies!
View Related
Filter Data On One Sheet And Copy To Another
Is there a way to easily filter the data according to the products' "index %" of a given month and then copying all data (including name, price, index%, and index value for the whole year) of those deviating from 100,0% to a new sheet? I tried this myself with auto filters but the layout presented some problems. The sheet is created automatically by another programme, so the layout is what it is. I really hope someone might have a solution for this since I need to sort through these sheets, with thousands of products, every month by hand!
View Replies!
View Related
Autofilter Copy Data To Other Sheet
Trying to filter list and copy filtered data to another sheet in the same workbook. I'm receiving this error: Run-time error '438' Object doesn't support this property or method Worksheets("Data"). CurrentRegion.Copy _ Worksheets(" Totals"). Range("A1") Sub GetTotals() ..............
View Replies!
View Related
Auto Copy Data From One Sheet To Another
So im setting up a big list of stuff, and basically i have multiple sheets. One of them is a "master sheet" so to speak, and the rest are sub-sets of data. Is it possible to have the Master sheet updated automatically every time data is entered on one of the sub sheets? Basically its an alphabetical list of names, and my sheets are "Master sheet" "sheet A, Sheet B" etc .... so If I enter a name on Sheet B, or format the cells on sheet B, is it possible to have that automatically copied to the master sheet? its becoming a pain to have to enter the same name on two sheets manually.
View Replies!
View Related
Compare And Copy Data From One Sheet To Another.
SalesImport contains sales data, and one column of that sheet is a unique reference number to identify the agent responsible for those sales. Main contains much more data, and I need to transfer sales data from SalesImport to Main in the most efficient, automated way possible - on a monthly basis most likely... but possibly weekly or even ad-hoc at a later date... so it really does need to be quite quick. At the moment I have come up with an idea to loop through each row on the SalesImport page, and for each row, compare the unique reference number (Column I) with the unique reference numbers on the Main sheet, (Column C). If they match, set the value of the sales column on Main to the same value as the sales column on the SalesImport sheet. However, this is not working as i would hope, and doesn't copy anywhere near all the rows I know are found in both sheets. Sub SalesDataImport_Main() Dim c As Long, d As Long, Limit1 As Long, Limit2 As Long, Limit3 As Long, sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet Set sh1 = Sheets("Main") Set sh2 = Sheets("SalesImport") Limit1 = sh1.Cells(Rows.Count, 3).End(xlUp).Row Limit2 = sh2.Cells(Rows.Count, 9).End(xlUp).Row For c = 2 To Limit2 sh2.Cells(c, 9).Select For d = 3 To Limit3 If sh1.Cells(d, 3).Value = sh2.Cells(c, 9).Value Then sh2.Cells(c, 27).Value = "In Main List" Else: sh2.Cells(c, 27).Value = "Not in Main List" End If Next d Next c End Sub
View Replies!
View Related
Get The Data From Sheeet And Copy To Other Sheet
I have 3 workbooks, I have a sheet that will have a button on it that will run the code, when the button is pushed, data from another workbook will then copy to a 3rd workbook. Control.xls - Has the button, which will run the vba code. Source.xls - Has the data to be copied. Dest.xls - Were the data will be copied too.
View Replies!
View Related
Copy All Data And Paste To Other Sheet
I have a workbook with multiple sheets. Within the workbook there is 1 mastersheet and 30 other sheets. On a daily basis, I need to copy all the data from the 30 sheets to one single sheet. For each sheet being copied, I want to copy all data with the exception of the first row. Some of the sheets may contain blank lines. I am have trouble getting my code to copy all the data.
View Replies!
View Related
Copy Selected Data Onto New Sheet...
I have a button the brings a dialog box with a list box. on selecting a figure in the listbox and clicking 'OK' the figure is transferred to a cell in a worksheet. The column under this cell has a formula with the result True/False. The autofilter then selects only 'True', and then should copy the active range to a new sheet, preferably named according to the value first selected. It must be possible for the user to have several of these ranges copied to different sheets for printing purposes, which is not a problem as this already works with the code.
View Replies!
View Related
Copy All Data From Different Files Into One Sheet
Here is my problem: Every month I have *.xls files containing one sheet with different data. I tried to make a macro whose job was to copy all data from different files into one sheet but i failed. Please tell me is there some kind of macros which will copy all data sheet from all files into one sheet and to detect every next empty row to paste the information there?
View Replies!
View Related
Copy Data From Hidden Sheet
I have a hidden holding sheet where I copy data into col A as follows: Sheets("April_June"). Range("a10:A110").Copy Destination:=Sheets("Staff_Import").Range("a1") This works fine but what I also need to do is delete the blank rows in the holding sheet "Staff_Import" and copy back to another sheet "July_Sept" without removing the formatting in "July_Sept" sheet ie cell fill & borders.
View Replies!
View Related
Printing Filtered Data
I'm attaching a sample workbook which contains two sheets. The 1st sheet is titled "2008" which contains sample data in various columns & rows. The 2nd sheet is titled "print data", which at this time just has a similar, but less titles than on the sheet "2008". What I'm trying to accomplish (if possible) is when data is filtered on the "2008" worksheet, that the data will appear just as it is viewed on the "Print Data" worksheet. In a sense I want it to mirror the data on "2008". The "Print Data" sheet contains a lot less columns of information, which typically is not needed for written summary reports. I'm trying to minimize the amount of paper when printing, etc. I'm just not sure how I can accomplish this task without some type of macro or vba code.
View Replies!
View Related
Copying Filtered Data
I would like to change the code below so instead of copying the whole column it only copies the items visible (i.e. they have been filtered in a couple of different columns). For Each rngData In Range("E4:CR258").Columns rngData.AutoFilter Field:=1, Criteria1:="<>" rngData.Copy rngData.EntireColumn.Cells(263, 1).PasteSpecial xlPasteValues rngData.AutoFilter Next
View Replies!
View Related
Group Filtered Data ..
I created a complex spreadsheet with AutoFilter. For each transaction recorded, the info consist of 4 rows per transaction. When I click the the filtering drop down, the result return with the single line. Is there a way that I can have the results return in group 4 rows? I merge the 4 cells in the first column but it doesn't work the way I want it to.
View Replies!
View Related
SUMIF On Filtered Data
I need assistance to create a formula that combines SUMIF and SUBTOTAL. I have created a SUMIF function for a long list of data for approximately 45 staff based on a type of errors.What I would like to do is use the filter by staff id. For example, when I use the filter to choose John, the SUMIF function does not calculate only for John but it still shows for the entire staff. Is there any way I could combine SUMIF and SUBTOTAL so that when I choose a certain staff from that long list, it will calculate accordingly.I have attached a simplified list of the spreadheet. What I need is when I filter by staff ID, the summary for error type and summary for errors by step to change automotically.
View Replies!
View Related
When Data File Close Sheet To Sheet Range To Range Copy
i have a main.xls file and two data file dat1.xls and dat2.xls mail named file have ar - br- cr- dr- er -fr sheets dat1 named file have ar-br-cr sheets dat2 named file have dr-er-fr sheets and all this files data source is colomn source a - fd row source 29-4000 i want to make two commandbutton to main file first for dat1 second for dat2 file and i need a code to use at this buttons to make when dat1 and dat2 close main file user when click first button copy dat1 file ar sheet colomn source a - fd row source 29-4000 cells to main file ar sheet colomn source a - fd row source 29-4000 cells copy dat1 file br sheet colomn source a - fd row source 29-4000 cells to main file br sheet colomn source a - fd row source 29-4000 cells copy dat1 file cr sheet colomn source a - fd row source 29-4000 cells to main file cr sheet colomn source a - fd row source 29-4000 cells
View Replies!
View Related
Copy Data From One Sheet To Another Depending On Date.
"Sheet1" of Book1.xls contains the daily efforts of each members in the team. The detail changes automatically everyday like: Date Name Task1 Task2 Total 1/1/08 Mark Design-2 Analysis-2 4 1/1/08 James Design-3 Analysis-2 5 1/1/08 Paul Implement-4 4 On the very next day the details will be automatically changed as: Date Name Task1 Task2 Total 1/2/08 Mark Design-2 Analysis-4 6 1/2/08 James Design-3 Analysis-2 5 1/2/08 Paul Analysis--8 8 i.e. "Sheet1" will contain only the details of current date. I have managed to do it in "Sheet1"... Here I need to add all the details automatically for each and every day in a separate worksheet ("Sheet2") from "Sheet1" of the same excel. As soon as the date changed, then it will be reflected automatically in "Sheet2" in the next blank row for each member of the team... The details of "Sheet2" will be: Date Name Task1 Task2 Total 1/1/08 Mark Design-2 Analysis-2 4 1/1/08 James Design-3 Analysis-2 5 1/1/08 Paul Implement-4 4 1/2/08 Mark Design-2 Analysis-4 6 1/2/08 James Design-3 Analysis-2 5 1/2/08 Paul Analysis--8 8
View Replies!
View Related
Formula (copy Data From One Sheet To Another When Value Matches)
I have two sheets (sheet 1 and sheet 2). Sheet 2 has a range of data about employees. Column A contains a unique reference number with the rest of the row (Column B - Column X) containing corresponding data about that empoyee. When I enter that unique reference number in Sheet 1, Column A, and matches the value in Sheet 2, Column A; I would like the rest of the corresponding row data (Column B - Column X) from Sheet 2 to populate 'automatically' (copied) in Sheet 1.
View Replies!
View Related
Copy Data According To Criteria To Another Sheet Within The Workbook
i need a macro that will copy data according to criteria to another sheet within the workbook, Raw data is in Sheet "Workings" from range A1:L,???? (not fixed), i need the macro to filter Col b and look for string CBA, CITIAIMS, MIR ASIA, STATE STREET, CITIBANK, REG then copy all data relating to these string to Sheet- " Cash_To_External_Custodian" Workings Account CodeCustodianSourceValue DateBreak DateAgeSideCCYLedger AmountStatement AmountAmount DifferenceError TypeQLGACITIAIMSDES21-Oct-0821-Oct-08-6SCRAUD0.0063,115.1163,115.115647366QLGSBQLGACITIAIMSDES22-Oct-0822-Oct-08-7SCRAUD0.0011,665.0311,665.035649060QLGSBQLGACITIAIMSDERIV28-Oct-0828-Oct-08-13LCRAUD100,000.000.00-100,000.005661452QLGACITIAIMSDES28-Oct-0828-Oct-08-13LCRAUD18,274.880.00-18,274.885655105 When pasting data to "Cash_To_External_Custodian", i would like the macro to paste to the required columns as per my screen dump below, as you can see i want the macro to skip Col b ,Starting Range is A6 Cash_To_External_CustodianAccount Code Case RefCustodianSourceValue DateBreak DateAgeSideCCYLedger AmountStatement AmountAmount DifferenceError TypeQLGACITIAIMSDES21-Oct-0821-Oct-08-6SCRAUD0.0063,115.1163115.115647366QLGSBQLGACITIAIMSDES22-Oct-0822-Oct-08-7SCRAUD0.0011,665.0311665.035649060QLGSBQLGACITIAIMSDERIV28-Oct-0828-Oct-08-13LCRAUD100,000.000.00-1000005661452QLGACITIAIMSDES28-Oct-0828-Oct-08-13LCRAUD18,274.880.00-18274.885655105
View Replies!
View Related
Auto Copy Specific Data From One Sheet To Other
I just want to check that if it is possible to copy specific cells from one row to another sheet by using macro or any other script. Attached is a sheet which explains what exectly I want The sheet one is having Source data Sheet three is the result sheet If I put some code numbers (in number form) it should search the data from source sheet and update the same in result sheet in different rows
View Replies!
View Related
|
TRACKER
