Macro To Copy To Specific Sheet Depending On Cell Value
This is the code I have:
Sub Auto_Open()
Sheets("Data").Select
Range("A2:E32").Select
Selection.Copy
Sheets("May").Select
ActiveWindow.SmallScroll Down:=-9
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Sheets("Data").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
Sheets("Sheet1").Select
Range("A2:E32").Select
Selection.ClearContents
Range("A1").Select
End Sub
1) How do I set this up so that if the cell Z1 reads 1, it will paste the data to the "January" Sheet, if Z1 reads 2, it will paste to "February" Sheet, if Z1 is 3 it will paste to "March"......
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Macro To Copy Specific Data From One Sheet And Paste Into Two Sheets
There's one sheet that has a list of customers (this is updated very frequently). These customers are either ‘New’ or ‘Existing (as listed in a corresponding column) - would it be possible to have a macro that, when run, will place a copy of existing customers into a second worksheet (“view list – new”), and a copy of new customers into a third worksheet (“view list – existing”), with the main worksheet still listing both existing and new customers. As the main sheet that lists all customers is updated very frequently (with customers being added and removed throughout the day), would it be possible to clear all contents of the other two sheets that each list of 'existing' and 'new' customers will be copied into, before the two lists are copied into each of the two sheets (just to ensure there isn’t any data in there from the previous time each list was copied in). I’ve given this a go via the ‘record macro’ function - some users of this WB use excel 2000, and others use excel 2007, but it only seems to work on excel 2007 (which is what it was recorded on)…
View Replies!
View Related
Find Specific Cell, Copy Row And Paste Into New Sheet
I have a excel file with two worksheets. I need to find a specific row in column g, cut the entire row, and paste it into sheet2. I have started off by using this code, that I got off of some site. It works wonderfully in finding the specific cell, but just copys and moves the specific cell into sheet2. Whereas I need it to cut and paste the entire row where it finds the cell that begins with a 3 in column G. Sub Copy_To_Another_Sheet_1() Dim FirstAddress As String Dim myArr As Variant Dim Rng As Range Dim Rcount As Long Dim i As Long
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
Hide/Unhide Columns Depending On A Specific Cell Value
I am looking or a code, (Or formula if one exists) to hide or un-hide columns depending on what is entered into a cell. I have attached an example to help clarify what i mean. Basically i want: If A2 is empty, hide columns C, D, E & F If A2 = Apple, Unhide columns C & D, but keep E & F hidden If A2 then becomes Banana, rehide C & D and unhide D&F
View Replies!
View Related
Macro To Copy Specific Cells From Row From Source & Stop When Next Row Cell = Specific Value
I have a protected template and unprotected source worksheets - - - what I would like to happen is for the macro to start and if the source worksheet cell B3 equals "Report Total" then stop - otherwise copy template worksheet then copy 6 specific cells from the source to paste values to specific cells on the newly created worksheet (B_ to C7, D_ to I7, E_ to C9, F_ to K9, A_ to C11, M_ to K11 and then K13=F13-30) After that then start all over again unless the next row’s cell (B4, B5, B6, . . .) is "Report Total" then stop - - - the row count could be from one to a couple hundred. Here is what I have so far but I know that with each copy the name will change and as it goes down the source file each row will change and I also need help with that. Sheets("ee template").Copy After:=Sheets(3) ActiveSheet.Unprotect Selection.ClearContents Range("I7").Select Selection.ClearContents Range("C7").Select Sheets("source").Select ActiveCell.Offset(0, -11).Range("A1").Select
View Replies!
View Related
Macro To Find Required Data Than Copy/paste In Specific Cell Address
I want to copy some data from internet and paste it in to worksheet location Range A1:A30. the data look like following information. LocationKuwaitP.O.Box:4819 SafatAddress:ShuwaikhTel:-22253580Fax:-24343645Category:CONSTRUCTION COMPANIES the above information have following header ie. Location, P.O.Box, Address, Tel, Fax and Category. every time one of the header inforamtion is missing ie. Address or P.O.Box, Or Fax, due to this problem every time cell address of information aganist header is change. supose in first copy/paste Tel inforamtion is in A15, but second time it may be on A13, and 3rd time it may be on A17 and so on. I want to make a macro which search header ("Location", "P.O.Box", "Address", "Tel", "Fax", "Category" ) from a Range A1:A30. than down two steps to copy header information (75325412) and paste in fixed cell location C1:C5 (C1=Name, C2=Location, C3: P.O.Box, C4=Address, C5=Tel, C6=Fax, C7=Category) in same sheet. and repeat the steps to copy information aganist header from all header in Range A1:A30.
View Replies!
View Related
Macro To Lock Cells In Protected Sheet Depending On Criteria
I have a Workbook that I use to log invoices and credit notes and it is password protected so that the cells that contain formulas are locked and therefore not selectable. What I wanted to know is. Is it possible to lock other cells depending on what values are in certain cells? Let me explain. I have Columns G & H which contain the heading 'Credit Note Number' & 'Credit Note Amount'. Now in columns I & J I have the heading 'Invoice Number' & 'Invoice Amount' respectively. What I have done is to make a condional formatting so that If I put a value in cells in column G it will change the colour of the adjacent cells in columns I & J, likewise If I fill in cells in column I the conditional formatting will change the colour of adjacent cells in coulumn G & H. This helps me to see whether a row contains a credit note or an invoice. What I would ideally like is for a Macro that would automatically locks cells G & H in a particular row that I am currently working on if I enter data into the cell in column I. Likewise if I am entering data in column G in the row I am currently working on for a credit note, then lock columns I & J in the row I am currently in. Any Ideas how this can be done? Also can locking and unlocking of cells be done in VBA while the sheet is protected or would the macro need to temporarily unprotect sheet, lock the cells then protect sheet again? PS: I have uploaded a Jpeg of what my conditional formatting does to try and illustrate what it is I need.
View Replies!
View Related
Macro: Copy Cell To Another Sheet
I dont now, but the code for copy info between sheets dont work Sheets("SalGrpLibro"). Cells(1, 5).value = Sheets("Formato Permanentes").Cells(2, 2).value and show error Range property. and this code is ok but is so many lines Sheets("SalGrpLibro").Select Cells(1, 5).Select Selection.Copy Sheets("Formato Permanentes").Select Cells(2, 2).Select selection.pastespecial
View Replies!
View Related
Sheet Population Depending On Cell Data
I currently written the following formula, but always have issues when adding additional depending on selection. D8 is the selection ( Validation ) on PERF EXP FORM Tab, Once you enter the selection... you then go to the Accounts per hour Worksheet =IF('Perf Exp Form'!$D$8="Test1 14-18 station",IF(('10220DBHE'!B9=A6),IF('10220DBHE'!C9 > 11000,11000,'10220DBHE'!C9),"N/A"),"N/A") Perf Exp Form Perf Exp Form *ABCDEFGHIJKLMNOPQ4 *1. GENERAL INFORMATION****************5Customer***Date / Name(s)*6ApplicationSheet Size1UP/2UPOrientationSOG/EOGFold TypeFold Plate# CH***78 1/2 x 142 UPPortraitSOGLetter/ZHeavy1***8Machine / model**Enduro 4-6 station9ConfigurationCHANNEL 1CHANNEL 2CHANNEL 310590-4720-4910 Dual DeckNONENONE11Date / Name(s)*** Excel tables to the web >> Excel Jeanie HTML 4 ......
View Replies!
View Related
Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell Of Specific Column
I have rather large Excel file that spans around 245 columns & has multiple users responsible for certain columns. Columns are chunked to provide data about a specific group. Every 72 hours, I need to provide to managers what’s currently on this file in a specific summary format. I’ve recorded a macro that gets me half way there. Here’s where I’m clueless. After my macro deletes unnecessary columns, what remains are the columns for “Main Data” group + each of the 5 “Business” groups (Investors, Lawyers, Credit, Finance, and Support) which would have identical column headings. (1) Name (2) Address (3) ID# (4) Control# Furthermore, for each of the 5 “Business” groups, there are 9 slots (ie- a user can enter up to 9 unique entries for a particular group.) Example- The Investor group contains 9 slots. Each slot will contain the 4 columns mentioned above. So there are 46 slots in total – 1 for Main Data, 45 (5 groups x 9 slots) for Business groups. MAIN DATA (columns A-D) Investor1 (columns E-H)… Investor2 (columns I-L)… Investor9 (columns AK-AN) Lawyer1… Lawyer9 Compliance1… Compliance9 Finance1… Finance9 Support1… Support9 MY PROBLEM: I need a macro to now cut & paste all data from each of the 45 Business groups slots & then paste at the bottom of the MAIN DATA slot. The final file would be 4 columns (as listed above) wide. Data from each of the 45 business group slots would be one below the other- all of it underneath the data in the Main Data group. I attempted to record a macro where I’m copying a section’s data range starting from row2 to row4000 (I know there will never be 4000 entries. I did this just to ensure that all future data would be captured) then pasting that after the last entry in the Main Data. Example- I’d copy data from Investor1 slot(starting at column E2-H2) & go about 4000 rows down. Then I’d press CTRL+Down Arrow key in column A & then click the down arrow one time to take me into 1st empty cell where I would paste my copied data. I was going to repeat this process for the remaining 44 slots. I’ve added some extra entries to test the macro & the problem is that the recorded macro is pasting data in specific cell location in column A instead for looking for the 1st empty cell in column A & then pasting the copied data. So far I've gone thought the net & tried to paste in a few VBA posts/tips that I thought would work. Here's what I have so far from tinkering around. I need someone to tell me what to replace the xxxxxxx line with. This would be the language to tell Excel to paste copied data range into the first blank cell in column A. I've gone thought the net & tried to paste in a few VBA posts/tips that I thought would work. Here's what I have so far from tinkering around. I need someone to tell me what to replace the xxxxxxx line with. This would be the language to tell Excel to paste copied data range into the first blank cell in column A. Sub transposedata() Sheets("ConsolidatedYTDReport").Select Range("E2:H4202").Select Selection.Copy XXXXXXXXXXXX ActiveSheet.Paste End Sub
View Replies!
View Related
Macro To "go To" Specific Cell In A Different Sheet
I have a seriew of drop-down combon boxes that ultimately "drill-down" to a resulting sheet & cell reference in cell F7. Based on the criteria selected in these drop-downs the resulting sheet & cell reference (cell F7) will change. I am looking for help with a macro that, when run, will take me to the sheet & cell referenced in cell F7. When I do a goto function it always remember the last place I went to and never goes to the latest data in cell F7.
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
Range Copy: Differ Depending On The Active Cell That's Selected
The rows will differ depending on the Active Cell that's selected and I don't know how to specify this. The range I want to copy is from Column B to DA on the worksheet ("Staff") which I want to paste to another worksheet ("Leavers"). This is as far as I got 'FindRemove = lstRemove.Value 'If FindRemove = "" Then End ' Goes to the start of the Data column 'Sheets("Staff").Select 'Range("B4").Select ' Tests current cell against FindRemove 'Do 'If ActiveCell.Value = FindRemove Then 'Call CopyPerson 'Exit Sub 'Else: ActiveCell.Offset(1, 0).Select 'End If 'Loop Until ActiveCell.Value = "" 'End Sub
View Replies!
View Related
Macro Disabled Depending On Cell Value
I was wondering if it is possible to prevent a macro from running depending on what value is in a specified cell. I have a huge excel sheet and a commandbutton that runs a bunch of macros in order to generate a report. I want to force the user to select a specific project before all the macros are run. Just making the report for a specific project only takes a few seconds but if no project is selected then it runs throught the whole database and it takes forever. I have set up a cell that changes value depending on wether a project is selected or not. I have placed the cell in the -ForMacros- sheet. Now is it possible to write some code into the commandbutton that halts the report generation + displays a warning box telling the user to select a project first? What values used to determine wether the macro runs or not doesnt matter to me. Whatever is easier for you I have attached a sample workbook for you to work on.
View Replies!
View Related
Cell Shading Macro Depending On Text
I will have a spreadsheet similar to the image provided. Basically, I need the macro to go row by row down column I. If the cell in column I contains the word "Tech" I need the cells from column B to P to be shaded color1; if it contains "Update," color 2; if the cell is blank; leave the cell as is. Once the macro has done this, it will continue to the next row and to the same check. The number of rows in the spreadsheet will change on a day-to-day basis depending on the data that's pulled, but the columns should remain the same. So I think I have the shading part. This is what I have so far. I'm not sure if this is the most efficient way of coding it, but it kinda works. I guess another problem would be if in the future the column with this info (column I) changes and shifts.
View Replies!
View Related
Macro Allow To Total The Data On The Total Sheet Depending On What Unit Number Is Selected
This may not be the best way to do this, but I don't know Macros or Pivot Tables. I am looking for a way with formulas to do the following: Within a workbook the 1st sheet is the data entry. In another sheet that will total data from the data sheet is where I want to be able to total columns of data, depending on what is entered in one specific column: Example: Data Sheet, E2:E2999 is a unit number selcted by pull down tab entry. G2:G2999 in the same sheet is where the data is. Q: What formula would allow to total the data on the Total Sheet depending on what unit number is selected in column E on the Data Sheet and the data amount in column D from Data Sheet?
View Replies!
View Related
Macro Showing Only A Specific Sheet
Writing a macro that when runned will show only two specific sheets in a work book. If i run macro 1 the sheet "xxx" and "start" should be the only visible sheets in the work book. If i run macro 2 after having runned macro 1 sheet "yyy" and "start" should be the only sheets appearing.
View Replies!
View Related
Assigning Macro/Module To Specific Sheet
I have a workbook that has 2 similar worksheets. One called "Wood Shafts" and the other called "Iron Shafts" I have the macros worked out for the sheet called "Wood Shafts" and I just realised I need to apply similar Macros to the sheet called "Iron Shafts" (same functions but different values from different columns). Some how I need the code to be able to tell the difference between the two sheets. I am at a loss.
View Replies!
View Related
Disallow Specific Format Of Sheet Name From Macro
The below piece of code is from a macro that creates a summary sheet based upon the name of the worksheet. My problem is as follows: I have another macro which copies the summary sheet and renames it in the format dd-mm-yy and I want to exclude this from the macro that constructs the summary sheet. How do I modify line 4 to capture the exclusion of all sheets with format ##-##-##? Note: The current line is my poor attempt at doing it. If (A$ = "Template") Then Goto 10 If (A$ = "Create New Sheet") Then Goto 10 If (A$ = "Summary") Then Goto 10 If (A$ = Like "00-00-00") Then Goto 10 ' Process the current sheet Range("A" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C15" Range("B" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C16" Range("C" + Format(j)).FormulaR1C1 = "" Range("D" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C18" Range("E" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C19" Range("F" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C20" Range("G" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C21" Range("H" + Format(j)).FormulaR1C1 = "='" + A$ + "'!R4C22" j = j + 1 10 Next i
View Replies!
View Related
Macro To Go To Specific Sheet Upon Choosing Option
Im looking to create a macro that goes to a specific sheet on my workbook upon selecting an option. Example being I open the spreadsheet and a list of options come up such as: BRIAN JOHN JAMES PAUL STEVEN Upon selecting one of those names you are transferred to the sheet named "BRIAN", "JOHN", "JAMES" etc etc etc
View Replies!
View Related
Macro For Filtering Spread Sheet By Date And Specific Person
I am fairly new to macros and I am currently working on a project where I would like to create a 2 buttons which will filter by date and by owner. The spread sheet I have is fairly large and is added to weekly. I have two objectives that I am trying to reach: First I need to filter for all past due task items from the Thursday of the week I am working in back and for a specific person (owner) by the finish date Second I need to filter for upcoming tasks one week out for a specific person (owner). The objective of this is so that on any given day a user can find any upcoming tasks that are due one week out. If this is not an option. My thought was to create an input box where the user can input the date and the information on the spread sheet will pull all past due items or upcoming tasks. These two items need to pull seperatly not together. I know I can create a macro by autofiltering by columns however I am trying to avoid having to go in and change the date each week. Start date is column E Finish date is column F Owner is column L
View Replies!
View Related
Macro Copy Of The Active Sheet And Then Rename The New Copied Sheet
I'm trying to create a copy of the active sheet and then rename the new copied sheet to what's in cell O4, which is a formula (see below) and then paste value cell O4 in B3 of the copied sheet. However, when I run this macro it doesn't seem to like the second line where I am renaming the sheet (run time error '1004'). "O4" =DATE(YEAR($B$3),MONTH($B$3)+1,DAY($B$3)) Sub NewMonth() ActiveSheet.Copy Before:=Sheets(Sheets.Count) ActiveSheet.Name = Range("O4").Value ActiveSheet.Range("O4").Copy ActiveSheet.Range("B3").PasteSpecial Paste:=xlPasteValues End Sub
View Replies!
View Related
Macro To Copy/paste Specific Rows (and Formulas) Based On Drop Down
I have about 10 rows of data that have columns of information describing computer hardware and pricing. There are 10 rows, because each row represents a different country and different tax rates and pricing changes per country. So each column of a row has a specific formula to calculate information for that row's country information. All these 10 rows of formulas are kept as a reference at the bottom of the sheet. At the top of the sheet I need to have a drop down menu to choose a country and then it will automatically copy and paste the row of that country to the current row at the top. Is there any easy copy/paste macro for such a thing?
View Replies!
View Related
Macro To Open Specific Files And Copy Data From Week Number Sheets
What im trying to do is have a macro that will open a file called Blue 1.xls in location "I:SchedulesBlue" and then copy data from cells N13:034. Then paste it into another excel file (Press.xls)on worksheet "Press Break" cell G14. The data that is copied not always fills up the cells N13:O34 so I need it to go to the next blank cell in column N and paste the information from file Blue 2, and so on for Yellow 1, Yellow 2, YellNR, and Green. So to summarise I need a macro to open 6 files copy data from the same location on each of the files(N13:O34) then close and paste it into a master document(Press.xls) worksheet "Press Break".
View Replies!
View Related
Conditional Copy Routine: Macro To Search A Column For A Specific Text String
I am trying to write a macro to search a column for a specific text string which when found, will copy the whole row the string is in. Once this row has been copied, I then want the macro to activate a new sheet and search for the next available empty row to paste the data. Once this has been done, go back to the original sheet and find the next cell in the original column with the specified text string and repeat until the range has been satisfied. Below is the script I have that sort of works.
View Replies!
View Related
Macro To Copy A Number From One Sheet To Other Sheet
I have a report generated from an application and am looking to format it into a specific format in order to import it into access to be used in a query. Does anyone know how to write a macro which will:- 1. look for a particular word and delete 1 row above it and 16 rows below it, for every time that word appears on the sheet. 2. Look for a specific number (which can be identified by the total number of digits in it and/or the starting series of numbers) from it’s location to another newly inserted column 4.Finally, count the number of rows between the number moved in step 2 and the next similar number and copy the first number in to number of rows = the number of rows between it and the next similar number.
View Replies!
View Related
Automatically Re-name Sheet To Cell Value & Create Copy Of Hidden Sheet
I have a workbook with a hidden sheet ("Template") and a visible sheet("New Job"). I need code so when cell F1 in "New Job" is populated: 1-the sheet is renamed to the value of F1, 2-a new tab is made (a carbon copy of the hidden sheet "Template") 3-the new tab is named "New Tab" and marked as unhidden. Public Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Name = Range("F1").Value End Sub Function WorksheetExists(SheetName As String, _ Optional WhichBook As Workbook) As Boolean Dim WB As Workbook Set WB = IIf(WhichBook Is Nothing, ThisWorkbook, WhichBook) On Error Resume Next WorksheetExists = CBool(Len(WB.Worksheets(SheetName).Name) > 0) End Function..................
View Replies!
View Related
Copy Specific Cell From Worksheet Chosen In A Listbox
I have sheets named exactly the same as the entries of a listbox. Now I want excel to copy the value located in e35 in the worksheet previously chosen. I tried th efollowing, but this doesn't seem to work. I simply recorded a macro doing what I wanted it to do (orange) but replaced the reference to the sheet with what I thought would be the choice the user made (green) Do While continue = vbYes UserFormware.Show Cells(16, 4) = UserFormware.ListBox1.Text Cells(18, 4) = UserFormware.TextBox1.Value Sheets("UserFormware.TextBox1.Value").Select Range("E35").Select Selection.Copy Sheets("Calculator").Select Range("E35").Select Selection.Paste If UserFormware.ListBox1.ListIndex = -1 Then MsgBox "You must select an item" End If Unload UserFormware continue = MsgBox("Do you want to add another warehouse?", 4) Loop
View Replies!
View Related
Copy & Paste Specific Text From Cell
I have a cell that contains various data but in the cell there will be a string of characters that will begin with either ON or TN followed by numbers. What I would like to do is have the sheet look at that cell and if there's a TN12345 (or any combination of numbers) or an ON123456 (same idea as the TN) I would like the sheet to pull just the ON or TN number out and paste it in a specific cell. The ON would have it's own cell to be placed in as would the TN. Here's an example. C5 contains various data, a mix of text and numbers but it will have either an ON or a TN or both. I would like the sheet to automatically pull the TN number out and place it in A5 and the ON in B5. I would like this process to repeat all the way through the sheet to the max amount of rows since I have no way of knowing how many rows I'll need. Can this be done with a simple IF formula or does it have to be done in VBA or is it not possible at all.
View Replies!
View Related
Copy Rows From Selected Sheet To New Sheet Based On Cell Value
i have a workbook that has a lot of sheets but i need to pull information from the one sheet "Veneer Log" i Need it to make new sheets with the same heading as on the "Veneer Log" (Rows 1 & 2) Sheet but it needs to be filtered by the "Product" Column (H) with a new sheet made for all the diffrent products i.e. Dimensional, Drywall, Corners - Thin V., Accents,..... so each product will have a new sheet with i am hoping someone can help me with this. This log changes Daily and it would be nice to have a sheet with only the same product on it to compare new orders so we can batch run. i hope i have given you enough information so someone can help me with this. i have attached a sample log the real log has about 10 worksheet for diffrent departments but i only need info from the Veneer Log Sheet.
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
Too Much Data Per Cell, Search/copy/paste Specific Values?
From mySQL database, i am getting a ton of data that is all being inputted into a single excel cell. Within this cell, there are certain data points that i wish to obtain (Bank #, SSN #, Routing #). There are multiple difficulties in obtaining this information. 1. these cells contain the same fields, but different number of total characters (differing in names, addresses, etc.) 2. some of the data points (like SSN) are inputted incorrectly, so even though a SSN is only 9 digits/characters, I may have to output all 11 that the SQL database placed within the cell. Can I get some help? I'm thinking of a search function/macro within excel, because all of the fields show up correctly. something like (i know this doesn't work) = or("cellA1" contains/finds/function SSN,return the 9 characters after "SSN ") um...yeah. difficult to explain, i'm sorry! edit: not sure what is wrong the file. I have attached a new one.
View Replies!
View Related
|
TRACKER
