We keep spreadsheets that have several columns of data, one being "comments" which contains quite a bit of text. I needed to copy some rows off the one workbook into another. Everything copied fine except it cut off part of the comments when I pasted to the new workbook.
View 2 RepliesI want to transfer certain data from one workbook to another. The problem is that I want to copy certain rows from my main workbook which has 3026 rows to a smaller workbook which has 1545 rows, both workbooks have the same product numbers in column A - except my smaller workbook has 1481 products omitted
These are the first 3 rows in both sheets:
Main Workbook
ABA19
Dar ABACUS Spare Glass Dropper For ABA4750/5050/5250
ABACUS Spare Glass Dropper For ABA4750/5050/5250
ABA191
Dar ABACUS Spare String Accessory For ABA5240
ABACUS Spare String Accessory For ABA5240
ABA4750
Dar ABACUS 800mm G9 Square Flush Polished Chrome
ABACUS 800mm G9 Square Flush Polished Chrome
Second Workbook
ABA4750
ABA5050
ABA5240
As you can see both 'ABA19' and 'ABA191' are not included in my second workbook but 'ABA4750' is, therefore I want to only copy the row of data for that product in my main workbook to my second workbook.
I am using Windows 7, with Excel 2010.
I have one Worksheet Short Course - PB's Which contains all swimmer information and searches through all previous swims and reports back the swimmers current Personal best times (PB)
I am creating a work sheet to calculate percentage increases over a set date period. I have managed the calculations but can not get the autofill to function as I was hoping.
In my short course sheet 1 Row = a Swimmer and there details
In my new sheet, I have 3 rows for the same swimmer
Row 1= Swimmer and PB's before a set date
Row 2 = Swimmer and PB's After set date and upto Todays date
Row 3 = Percentage calculation of difference between the two rows to enable track performance increase
I have all of this working and in place and want to copy the formula's down now to cover all swimmers in the club.
When I copy the 3 lines down, Autofill adds 3 to the row reference for the first line and I just want it to add 1.
ROW3) =IF('Short Course - PB''S'!A3="","",'Short Course - PB''S'!A3)
ROW4) =A3
ROW5) = A3
[Code].....
with a macro. I am looking to copy row 2 to the last row and past the copied rows directly below the copied contents.
View 9 Replies View RelatedSo I basically have a template workbook that the code is stored in. I need it to pull an entire row if Column C in workbook "rawdata" contains specific text, in this case "PRCH - Purchase".I have never had to do anything like this before, it has always been working in the same workbook. It's failing at the 'mp = ...' line every time. There might be other errors in the code too, I just cannot resolve the first one!
[Code] .....
I have a workbook into which a number of rows will be imported (a variable number). These will be edited then I want all the rows to be stored in a ever growing database. At the moment I simply copy these rows open a second workbook and paste the rows into the first blank row in the second sheet.
Is there a way to do this automatically.
1) select and copy all rows containing data
2) open second workbook & find first blank row
3) Paste data into second workbook
4) Save and close second workbook
I think with some effort I could manage the copying and pasting but I have no idea how to open and close the second sheet automatically.
I have two workbooks say 'MASTER' & 'REVISED' in D:Office. The REVISED workbook contains certain rows colored in Yellow which contain the rectified data. How to copy those rows (rectified data rows of workbook REVISED) to the workbook MASTER in the same row number.
View 7 Replies View RelatedI am using a Pivot Table to search for keywords in a subject line and it will display results if that keyword appears in the Pivot Table.
What I want to be able to do is copy 30 cells of that Pivot Table at a time into a new Workbook. All that I want to copy is Column A(Case Number) and Column B(Subject Line) of the Pivot Table.
Example:
Total Pivot Table data is 1000
I search for "Crashing", this will display 100 records
I want to grab the first 30 records and copy them into a new workbook
I want to grab the next 30 records and copy them into a new workbook
I want to grab the next 30 records and copy them into a new workbook
I want to grab the remaining 10 records and copy them into a new workbook
I have a spreadsheet (see attached) that has city names, accessories sku number and quantity sold for each week. I run this report every week and when the spreadsheet has empty rows which I delete, but there are some rows that also have partial data that can be deleted. Anyway, I would like to copy name of first store (los Angeles) in this sample and copy down till the next city comes up (San Diego) and do the same all the way down. I have total of 20 stores and I wondering if you guys know of a formula or vba code that could help me with this.
View 9 Replies View RelatedI have to fill out forms for work and some of the info is the same and isd put on seperate sheets. On sheet one I have cells with the information that is the same on the different forms on shhets 2 and 3 i have the forms.
here is what i have having problems doing.
12-47136569
13x129077
How can i do a formula that copies the above values exactually to a cell ona another sheet
In my excel I'm copying rows upon specific criteria to another tab.
The question is how I can delete copied rows and update the original tab without empty rows? (N of rows is always changing)
I have a Workbook on a shared drive, with a button that runs a macro.
Is there a way to disable this if anyone makes a copy of this workbook, or does Save As? (If it is not the original workbook).
I have a workbook, 'MyWb.xls' and a sheet with buttons to which I attach some sheet macros. When I assign a macro to a button I pick the appropriate reference, e.g. Sheet2.MyMacro, and this gets recorded by default as MyWb.xls!Sheet2.MyMacro
When I create a new single sheet workbook with the instruction ActiveSheet.Copy, I end up with a new workbook, say 'Book2' along with the buttons as expected. However the macros attached to the buttons still refer to the MyWB.xls file and not the new 'Book2.xls'. As part of the process of creating the new book I've tried redefining the macro with the instruction
I have a workbook from which i copy data and paste in another sheet, then close first excel. But copied data which is stored in memory gives a warning before closing the excel file.
The code i use is:
Sub Macro1()
Worksheets("Output").Range("A7:e1500").ClearContents
Sheets("Sheet1").Select
ChDir (Range("D3").Text)
Workbooks.Open Filename:=(Range("J4").Text)
Sheets("Final output").Select
Range(Range("P5").Text).Select
Selection.Copy
ThisWorkbook.Activate
[code]....
I have a spread sheet with tabs that are for each week of the year. Each tab shows the date on top and times (broken into 30 minute intervals) on the side; the inside has information like an event on the inside.
My goal is to keep that information there and to have a "master sheet" that holds all this information in a list format so I can filter out some information.
I have this bit of code which is working perfectly. Now I need it to delete the rows it just copied. How would I go about doing this?
Sub TESTMonthEndReport()
Dim x As Long, y As Long
y = 2
Application.ScreenUpdating = False
For x = 1 To Worksheets("January 2013").Range("K276").End(xlUp).Row
If Worksheets("January 2013").Range("K" & x) = "Waiting" Then
Worksheets("January 2013").Range("K" & x).EntireRow.Copy
Sheets("February 2013").Range("A" & y).PasteSpecial
Application.CutCopyMode = False
y = y + 1
End If
Next x
End Sub
I have a spreadsheet that is controlled solely by userforms. I have a search button that finds all cells that match the query and copies the whole row into another sheet, often about 10 rows appear. What I now would like to happen is that these rows are then copied into a list box for viewing in the form apposed to in the spread sheet.
I have a sample spreadsheet to show how the data would be set out.
I've created a custom toolbar and populated it with a custom button. I have created a macro and it resides in ThisWorkbook. The macro is assigned to the custom button and the toolbar attached to the workbook. So far, so good. If I copy the workbook and rename it, when I click the button to run the macro it launches the original workbook and runs the macro. The macro effects changes on the renamed workbook copy. The macro name found in the assign macro dialogue starts with the original workbook name. The same effect if the macro resides in a module or sheet. Any known way to have the macro name change along with the renaming of the workbook such taht it refers to the currently opened workbook macros? Regards.
View 5 Replies View RelatedI have a workbook within which i have a worksheet that contains a lots of macro code (coded by me). As the workbook gets used by various people, i need to copy the worksheet and the macros across to the updated workbook, which doesnt contain the macro worksheet at all.
I have tried to copy it across by clicking on its tab and using the move or copy facility. This copies the sheet across as required. But for some reason, the macros all reference the old workbook. A small bit here for example for some reason opens up the old workbook and then performs the code in the old worksheet:
Sub SelectAll()
For i = 12 To 20
Set curcell = Worksheets("Form Generator").Cells(i, 3)
If curcell = False Then
Cells(i, 3).Value = True
End If
Next i
End Sub
As curcell is equal to worksheets...() i would have expected it to use the local worksheet, ie the one that the macro is attached to. So why is excel proactively hunting out the old workbook and sheet? is the method i used to copy across the sheet with the macros incorrect? If so, how should i go about it?
I am looking for a formula that reads down when drug to the right.
One of the sheets in my workbook has 5 rows (Rows 1 - 5) that I need to copy and insert at the top of all but 3 of the other worksheets. I can specify the names of the 3 worksheets that I want to avoid changing. The other worksheets will be named differently each time I use the macro.
View 2 Replies View RelatedI have a simple list of data (Name, Room, etc.) in a spreadsheet. Each day I click on the spreadsheet tab and create a "copy" and (move to end). This creates a spreadsheet for the next day's data.
My problem is that the macro I use to sort this data never works in the newly created spreadsheet within the same workbook. As usual, I'm sure it is something relatively simple that I am overlooking.
I have this micro enabled workbook and I want to protect it from being copied on other sources.
View 1 Replies View RelatedI'm trying to perform a copy & paste operation by hand which to me should be easy in theory. I have a worksheet whose formulas have been corrupted. I have a backup of this sheet- I'd like to copy the backup sheet into the workbook. The problem is that the formulas, which reference other worksheets within the workbook, are copied over as links to the backup workbook instead of the new workbook they are being copied too. This seems simple, but how do I copy the worksheet and the references without having to go through all of the references by hand to only apply to the local book.
View 4 Replies View RelatedMy boss sends me emails with people's information, which I then reformat to put in invoices in word, save as PDF, record in excel, and send out with an email from Outlook. I would love to find an easier way. I'm wondering about putting the info in an excel table so that I can then use a mail merge to create an invoice with the address--unless it turns out to be more work than to format each one (I'm newish to Excel).
The info I get is listed in the following way:
First Name: Mia
Last Name: Kant
Email Address: mika@gmail.com
Country: Afghanistan
[code]....
I need to use some but not all of the info, but if I could get it to format into a table, I assume I could then pick and choose.
I am trying to write a macro that will allow me to copy the text of a cell, and then insert text around that previously copied string. I am having a problem adding the copied text into my formula. Here is my code below:
Sub Bid()
'
Selection.Copy
ActiveCell.Value = "inventory levels are " & ActiveCell.PasteSpecial(xlPasteValues) & " and oversold by"
ActiveCell.Offset(1, 0).Select
End Sub
When i push a button how could i get the buttons text copied to cell? For Example:
If i have button and it's text is TestButton. I push the button and the text TestButton is copied to cell(1,1). How can i do this?
I want cell B4 on sheet 3, to show the value of cell B4 on sheet one ... only if there is a value in B4 on sheet one then i want the rest of row 4 to be copied to sheet 3 also.
HOWEVER if the value in cell B4 sheet 1 is BLANK/EMPTY then i want the full row to be over looked and the next row to be checked (B5 all the way to B30)
Once B4-30 on Sheet 1 has been checked and only the rows showing a data/value have been copied to sheet 3, i then want the same process to start again on sheet 2 - Again only the rows showing data/values to be copied.
I have a spreadsheet with 27 Columns and 439 rows of data. I need to copy each row of data that has a certain criteria and paste the same data 141 times below it and then manipulate the data. In the same spreadsheet I need to copy a row of data that has other criteria in it and past it 30 times below it, and then manipulate the data.
I have been using the copy and insert copied cells function, but I have to scroll down 141 or 30 rows each time to ensure I add in the correct amount of rows. Is there a more productive way to do this? I have about 10 workbooks with approximately 47 tabs/worksheets each that I will need to update in a similar fashion.
I have this export containing HTML content in each cell. I need to filter out a specific code from the links included in the HTML.
HTML Code:
<some HTML>
<a href="http://site.com/content/GE6053" class="button"><span>Text</span></a>
<a href="http://site.com/content/GE123" class="button"><span>Text</span></a>
<some HTML>
I need to get the string GE#### before each " class="button"> and copy it on a cell on the right. There are other links of this format [URL] ..... in the cell, but I am interested only the ones that have " class="button"> after it.
The length of the ID after GE can be 2, 3, 4 or 6 characters long. But I am ok with getting GE + 6 characters following it as that means I would get something like GE12" cl and I will delete the extra character by doing a find/replace.