Copy And Paste The Data And Remove All Those Question Marks
Apr 23, 2009
I imported data in to column A and it looks like it inserted a question mark (which I think represents a space or tab )before about half the names.
So when I import the data in my contact manager it inserts a square and throws off the import.
I know it is a simple question but have not been successful.
I am using Excel 2007.
All I want to do is copy and paste the data and remove all those question marks. I would assume it is simple as pasting with "remove formatting" but I am not seeing that option.Plus they are names so I want to keep capitalization etc.
I also tried pasting in a text file to remove formatting and paste in the text file.. (the names ended up indented) and then "paste special" back in to excel with no formatting .which I was able to do in 2000 but with no luck with 2007.
I am looking to see if is possible to copy and paste a worksheet and then remove data( only values not Text) and also not removing formatting and formulas
I have an excel program that reads a file and prints it to the work sheet, but I can't figure out why it puts quotation marks around the line of text. I would like to remove the quotation marks from column A and column D.
I would like to query your knowledge database (too much VBA I guess ) as I have a predicament that I cannot seem to solve.
Here is the thing: I am trying to write a sub that would enable me to automatically put in place extensible name ranges (the Offset worksheet function).
The problem is that, despite everything seems to go well, the reference in the name box displays : ="DECALER($C$2;0;0;5-1;1)" (the string comes from a variable and Decaler is Offset in French). These quotation marks are the culprits for sure, as taken off the formula works beautifully.
I've tried everything I've found on the internet, that is to say: Replace(String, Chr$(34), "") so on and so forth, but these marks are not recognized a part of the string so they escape the replacement.
After using Copy/Pastespecial in my macro, when it completes I have the flashing border around the range that was copied, (like you do when you do it manually). What line of code do I need in my macro to make this go away?
I have been using excel for years but have always managed to resolve issues using formula's etc but now i have had to step into the realms of macro's. I am slowly learning but urgently need help with the below problem which is bound to be a simple solution.
I have compiled a workbook for users to administrate on a daily basis. (each worksheet is a different day of the month but the same template) There are a few hidden worksheets as the info is extracted from these to run reports.
The issue/s i have is that administrators use cut, copy and paste to repeat data opposed to retyping, this messes formats, formulas and validation up. I have used a macro from the net to remove this option and it works fine. Problem is that if they do not enable macro's this will cease to be an option.
I understand that you cannot remove the option of enabling macro's but you can force. Again used a macro from the web that if you don't enable it only shows a welcome page saying that macro's need to be enabled to use. (all others are hidden) if macro's are enabled the welcome page disappears and the worksheets 1-31 reappear. Again this worked fine.
I tried putting both macro's into the same workbook but kept coming up with errors, each one i resolved led to another.
So short of it i need a instructions/macro to force macros and remove cut copy and paste.
I need a macro that will take the values that are in the far right cells and move them to an area on the left. the columns they will be pulling from are the IU & IV column starting with row 2 down to row 460. from there I need the values to be pasted into the D & E Columns starting at row 6. The two columns IU & IV are a date and a task for that date. When they are pasted into the columns D&E they will need to be sorted by dates (or just all of the blanks removed), with the soonest occurrence at the top. The reason for pasting values is because I have formulas pulling the tasks and dates off of another sheet. The last thing is that the macro needs to be triggered by the information in cell c2, when that cell is changed the formulas go to work and everything in cells IU & IV update. That is when I would like the macro to kick in and work the miracle.
I have been trying to build a colony of formulas that could do it, but I have given up, then I tried to make an array index it for me, but that wasn't working for me either.
I would like to implement specific cell ranges from two specific worksheets each within 33 workbooks (which all have several tabs) into a summary page in a separate workbook.
The cell ranges are going across my spreadsheet in rows and I would like for them to transpose into a columns depending on the data which I have separated by catergory on the summary page. They are all on the same location in each workbook which is separated by country. The cell ranges are E26:P37 and I would like to transpose them and have them put below eachother without overwriting for my format on the summary page, how I can put this together in a macro?
As a data download I got a block ** text with each item enclosed in "" "" and comma delimited. I converted to a table and copied the column I want to a 2003 excel file. How can I remove " " and treat column as simple numeric? I will then have to convert large application to 2007 as I am in that now.
I have a workbook that includes 4 seperate sheets that are used to record time and expenses for 4 members of staff. I want to write a macro to select the data I need from each sheet and colaberate together in a 'data' sheet so I can combine all the info to run time and expense reports per client showing combination of all time and expense incurred from all 4 staff.
I have named cell ranges in each of the 4 time-sheets. I proceed to record a macro, select the first named range, copy and paste into my data sheet, do a control home then control down arrow, then one more down arrow to get to the first blank cell and repeat the process for all four time-sheets.
This works until I add a new line and then the data will only appear for the last time-sheet (last row of data).
I am trying to create a macro to copy a set of datas in a row , paste into another workbook (specific sheet),then save it as one of the datas that was copied over.
Workbook1
Ticket# Description Name
12345 Test 1 David
32145 Test 2 Steve
Workbook2 - sheet (ABC)
Copy row 2 from Workbook1, paste to row 1 in Workbook2 sheet(ABC)12345 Test 1 David
Saveas Workbook2 - ABC - "12345" - Ticket #
Copy row 3 from Workbook1, paste to row 1 in Workbook2 sheet(ABC)
And so on. I will have a set of data to trasfer to Workbook2, each row different workbook.
I have been working on a macro that compares a existing list of data to an updated list of data and then either moves any data not on the new list over to a completed tab (followed by deleting the record on the existing sheet), and then adds any items not on the existing sheet, but which appear on the new list, to the existing list.
I have come across a stumbling block, i have managed to identify on the existing list the rows of data that have been removed from the new list and therefore need to be moved over to the completed tab, but when i select the data it selects the header row aswell (which will always remain the same row). Obviously this then pastes the header row aswell, and also i can't seem to get it to paste in the new sheet to the next available row (i.e this will be used daily and i don't won't to overwrite the infor already in the completed tab). the next issue i have is then when i go back to existing sheet to delete the data i just copied across, as the header was initially select this also gets deleted.
The code below, is the complete code, including filtering, copying some forumals etc. The area i am getting stuck on is highlighted in red:
Sub Update() Dim bottomrow As Long Dim My_Range As Range bottomrow = Cells(Rows.Count, "C").End(xlUp).Row Set My_Range = Range("A1:Y" & bottomrow)
1. Copy cells B5 to V-First blank row in Strength Tests worksheet 2. Paste cells into Racks worksheet in cell C5 3. Change font size to 6 4. Sort by Column T descending then by Column C ascending 5. Copy one row (A5-W5 (1Rx23C)) from Racks worksheet 6. Paste row into M1 worksheet in cell D4 7. Print M1 8. Drop down one row on the Racks worksheet 9. Repeat steps 5-8 until there's a blank row.
I have a time card report which will record the time spent on work for each employee. Each month, i have to generate the time card report and copy the data to my master file. Is there any code that can auto copy the time card entry directly to the master file? I only need some of the entry on the time card report, some of the column can be ignored.
I was thinking of creating a macro that will prompt me to choose the file to import as there are different file for different individual. Attach here with the master list (Demo.xls) & the time card for one individual (Nov-KTTHAM.xls) for reference.
I want to copy the data on column B of the time card to the column A of the master list, column C to column B, column D to column C, column E to column D, column F to column E and column G to column G.
I have some code that opens a different (source) workbook, copies over some data via cut and paste (to destination workbook), closes the source workbook, and then does lots of work on the copied data in the destination workbook.
If I let the code run it is painfully slow after the source workbook has been closed. I can solve this by manually closing the destination workbook and then reopening. Is there a way I can clear the memory (or whatever it is making it run slow) without closing and reopening the book?
I have copied Row no. 2,4,6 fro this GREEN table and want to paste same date in J and K column (in same row numbers)then how can I do this ?
It should Show like this if I 1 First I filter only Yellow cells 2 then I copy that Filtered cells 3 after that copying that filter cells I did Paste in same rows in J and K column
I am making an excel sheet that will graph many monthly results based on data extracted from a company's custom software. My objective is to minimize manual input, so I am trying to find ways for the excel sheet to read info that is copy pasted and appropriately place it in a graphable format.
I attached an example of a data extract that would basically be copy/pasted to the excel sheet.
My current idea is using VLIST and MATCH to find the column number of the VLIST needed. However, I don't know how to identify the data of the extract by date because the year and month are divided between cells, and some cells are merged, etc.
How would you make it so that the data that is copy pasted into a sheet falls nicely into the table in the excel sheet?
I am trying to copy data from one workbook to another. I have an excel Database (Sheet1) with a macro that prompts the user to select an excel workbook which has the data I'm trying to copy.... I got this part down....From this opened workbook, I want to copy the Range("C2:C12") and paste into my database(Sheet1) workbook.
However, I need a dialog box to pop up for a user input to designate which row the data must be pasted into. The dialog box will search column H in the database (Sheet1) workbook to designate the appropriate Row # in which the data will be pasted.
Now the ranged that I copied earlier will need to be pasted selectively if possible. Range C2:C8 will be pasted from Column HG:HM and C9:C12 will be pasted from HO:HR. Is it possible to selectively paste a range in such a manner or should I just split it up? I'm not really sure the order in which I should do these commands or how to go back & forth from one workbook to another. I would like for the workbook filename to not be a factor.
I am really amazed that I can't find a workable example for what I am trying to accomplish here... For the most part, I can read and decipher VBA code...but when it comes to constructing my own code...I am deluged with syntax errors and run-time errors...
Here, specifically, is what I am trying to do:
I have a column...(Let's say Column A)...that contains 1300 items to start with. Once an item is selected by the user, a new list is created in Column B that mirrors Column A with the "selected" items "removed"...(the cell is blank).
As each item is selected, (and "removed"), I want a third list created in Column C that lists all of the items in Column B, but skips the "blanks". ("Blanks" is in quotes to stress that these cells are NOT EMPTY. They each contain a formula).
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.
I have this code, but it doesnt paste the data, its only left empty. I want it to paste in columns C and D from row 15 and down as far as there is data to paste, aprox 5-7 rows...
I have a workbook with two spreadsheets. Sheet 1 is "working data" and sheet 2 is "Solution" As the title suggests, in sheet 1 is where all my calculations are performed, then it is pasted into sheet 2 and formatted. My issue is I need the information from "working data" to be copied and pasted into "Solution" but the information from "working data" will have a variable amount of rows (currently there are over 10,000, but their could be a few thousand more in any given month. The copied range from "working data" will always start in cell A1 and then should select all rows down until it finds a cell in column A empty, then the data should be pasted into "Solution" starting with cell A40.
