I just copied a table from the web which contains numbers in the last column.
I pasted the data into Excel, but when I try to run any type of calculation i receive a #VALUE! error.
The annoying 'workaround' is to re-type the same numerical text into it's own cell, which allows for calculation.
I've tried changing the cell formatting to 'general', and 'text', but I still receive the #VALUE! error, when trying to calculate.
I have tried using the below mentioned macro. However, it only work on one cell. I need to copy and paste a range from A1:Q200.
Sub retrievedata()
Dim wbResult As Workbook, wbSource As Workbook, CopyRng As Range, Dest As Range
Dim FileName As String, Filt As String
Set wbResult = ThisWorkbook
Set Dest = wbResult. Sheets("Data").Range("A1:Q200")
Application. ScreenUpdating = False
Application.DisplayAlerts = False
Filt = "All Files (*.*),*.*"
FileName = Application. GetOpenFilename(Filt)
Set wbSource = Workbooks.Open(FileName)
Set CopyRng = wbSource.Sheets("Summary").Range("A1:Q200")
Dest = CopyRng
Application.ScreenUpdating = True
Application.DisplayAlerts = True
wbResult.Activate
wbSource.Close
End Sub
I am unable to copy and paste on a particular worksheet. It is not protected nor are the cells locked. I can copy one or more cell's contents, but as soon as I click into the cell I wish to copy to, the paste icon greys out. Using VBA code to do the same fails at the same point.
View 4 Replies View RelatedBasically all I want to do is paste some odds data in to excel and then get it to just calculate the odds for me example below
9/4 Exotic Isle, 5/2 Greenery, 5/2 Port Alfred, 6/1 Reqaaba, 12/1 Somoud
I know I can use text to columns using the deliminator to split them in cells however I just want to take the odds
So Exotic Isle would be 2.25 (9/4) Greenery would be 2.5 (5/2) and so on
I've tried using the left function basically all sorts.
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?
One of my workbooks contains 6 worksheets. Quite often I need to copy a row of data from sheet 5 to sheet 1. I right click, copy, select sheet 1, right click and find that the paste options are greyed out and so unavailable. If I wanted to, all the other sheets would allow me to paste the data into them but not sheet 1. It did work until recently so I suspect that it is something that I have inadvertantly done. I have checked things like security, protection and the like but find myself now going around in circles.
View 3 Replies View RelatedCopy and paste the data from different excel sheets to one main sheet.
I will get a file which may contain 10 sheets or 15 sheets depends on data and rows also not sure it varies from sheet to sheet. Now, I would like to consolidate all the sheet data except first row (heading) for first instance I need heading and second sheet onwards not required the headings hence, macro should copy from second row onwards.
The data should get paste one by one if first sheet contains rows till A100 then in main sheet for second sheet data paste should happen from A101.
I have an excel which creates PPT from the excel. but the graph pasted in PPT are not aligned and formatted.
By aligned, i mean re-size the graph and paste in a formatted fashion (currently they are overlapping each other)
My entire PPT created is off alignment and formatting. E.g heading are not properly aligned (they are touching the line below) and so on.
I have a chart and a data table (please see attached file named "delete_1.xls).
I need to present these 2 items in a single slide of PowerPoint.
I have done like this.
-First copied the chart from Excel.
-Then pasted it in PowerPoint using "Paste special".
-Then clicked "picture (windows metafile)" this is to reduce memory consumption
Then repeated the above steps for the excel table too.
The PowerPoint slide that I got cannot be attached as system doesn't allow me.
Question: I wanted to a give a paper copy of the PowerPoint slide to my Director who needs a PowerPoint slide and not an Excel chart. But in the slide, the numbers of the table look much juggled and as if the numbers are too closely typed.
I tried with various different fonts in Excel and then copy and pasted in PowerPoint but the problem persists.
What things I should do in Excel table so that cell values are clear in the Table presented in PowerPoint ?
Attached File : Delete_1.xls‎
I would like to have a macro, to copy the cells and paste it 6 times in a column. below are the format required.
Column A
Input
abc
ert
uty
Column B
Output
abc
ert
uty
abc
ert
uty
[Code] ......
I’m simply trying to copy all the data on one sheet, open up a new excel application:
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Add
and then paste all the information to the new workbook. When I try, the charts don’t paste, only the values and formats.
I am trying to graph the amount of calls that come in on each day and at what hour. I am trying to put the days of the month along the x axis and hours along the y axis. I then want the number of calls to show as a scatter at certain times on each day. Is this possible? I have attached a sample of a table I will be working with that has made up data on it. I have tried using the select data function to try and change the axis, but I do not think I am writing the correct things in.
View 4 Replies View RelatedVery simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...
She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it highlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenly stopped!
Excel 2013 on a surface tablet and attempting to create a data form. I've followed the necessary steps to try and add the "Form" button to the quick access toolbar, but "Form" is simply not a listed command. Have looked in "All Commands", "Commands not listed in the ribbon" and "Data Tab" and it's nowhere to be found. Not greyed out, just not there.
Frustrating because it's so easy to create a form on past versions of excel. All the tutorials I've seen online explain how to add "Form" to the quick access toolbar
I'm stuck on the final piece of my macro project. I've attached a workbook with two sheets: sheet 1 is what I currently have, and sheet 2 is what I'd like my report to look like when complete.
On Sheet 1:
- column B is called Supervisor Name
- Columns D-O are months of the year, with either a Yes or No in each cell.
I'd like to write a macro that will:
- Take all unique values in Supervisor Name column, and paste these Above the current table.
- For each Supervisor, and each month, I'd like it to calculate, as a %, the number of Yes mentions in each month divided by the total cells (Yes/(Yes+No)).
Sheet 2 contains the output, in the format I'd like to see it.
Sheet 2:
Supervisor Name
October
November
December
Supervisor 1
8.3%
[Code] .......
I want to calculate the TAT between multiple date: For example: I have a request I received on 1/2/2014 and I sent to Abhi on 1/2/2014(Same day) and I got a reply on 1/3/2014 from Abhi. I forwarded the same request on 1/3/2014 to Prasad and got a reply on 1/5/2014. And I closed the request on 1/5/2014. How do I calculate TAT on this ? I want the Tat to be shown as 3 days because I just took three days on the request to complete that is 1/2/2014, 1/3/2014 and 1/5/2014..
View 4 Replies View RelatedHTML Code:
Range Apple
A B C D E
1 2 2 4 3
2 1 3 5
3 4 6 9
4 5 3 1 3
5 7 7 7 6
Range Pear
A B C D E
4 1 3 5
5 1 1 1
6 2
7 2 2
8 5 7
Range Apple
A B C D E
1 2 2 4 3
2 1 3 5
3 4 6 9
4 5 3 1 3
5 7 7 7 6
This is a column I have in Sheet1 ( the sheet is not named) In this sheet I have or will have 10,000 records of names of clients and the status they hold with company
What i would like to have done is a everytime Reg.feed Set up is found in the Column O is that column A-W is copied and moved to sheet 2 (which is also not named). The promblem that i am having with the current code is that is does not skip blank cells data as to be in every cell of that column in order for it to keep moving down the column.
Here is the code
Sub Feed_set_up()
'Let's start at row 2. Row 1 has headers
x = 3
'Start the loop
Do While Cells(x, 15) ""
'Look for data with 'Feed set up'
[Code] ..........
With a macro to copy from the last entire row with data and immediately insert and paste to the row below in the active worksheet. I am using Office 2007.
View 9 Replies View RelatedI have an email with body in tabular form. I need to copy this into excel in the as is condition.
When I do it manually, I see that the table nicely fits in different cells and looks good, but when I use a macro , I see that everything gets copied to a single cell.
I was wondering if it's possible to copy and paste formulas to a brand new excel sheet. I created an excel sheet with some forumlas but when I try to copy and paste it to a new page it only pastes the values and not the formulas.
Is there any way to transfer the formulas as well?
I am wondering if I copy a list from a pdf file and paste it all into column A1...is there a way to paste the list going down in rows like A2 A3 A4?
View 1 Replies View RelatedI have about 600 Word Documents that contains information about clients. Each Word document file name is the name of the client. Example. Tom Smith. I wanted to be able to highlight all 600 word documents and paste them into Excel, so that I can press Ctrl-F to find what ever name it is I'm looking for, then click the name and the word document open. Is this possible?
View 2 Replies View RelatedI Have a spreadsheet in which data is spreading into column A-Z. I would like to disable copy, paste, ^V,^R,^C, ^D for certain columns (Q-U) of the workbook so that user is forced to enter data manually on these columns.
Is there any simple of doing this using VBA.
I'm trying to use a VBA Macro to copy and paste a row of cells from 14 worksheets into in another worksheet in a Colum. The worksheets are entitled Data 1, Data 2, Data 3 and so on until Data 14 and the worksheet that I want to paste the data to is entitled sheet 1. The row of data that I want to copy and paste is in the same place on each worksheet C4 - IR4. I can do this using the Macro recorder but there is a lot of code and ultimately I want this to be part of a much bigger Macro once I get better at figuring this stuff out.
I have read that this can be done by using a Do Until and then using a loop. By the way I am using Excel 2003 with XP.
The problem is that whenever I have any browser open, IE, Chrome, Firefox, etc... the Cut & Paste, Copy & Paste function does not work correctly in Excel 2010.
When I Cut or Copy the blinking marquee around my selection briefly appears and then disappears. When I try to paste, I only have two options under the paste special function: Unicode Text and Text, same with cut and paste, however, the text doesn't actually cut, it only copies.
As soon as I close down any of the mentioned browsers, the full functionality of the cut/copy & paste functions are restored, no need to restart excel.
I need to have open a browser most of the time for work as our system is web based, so closing and re-opening is more than just an annoyance.
Suddenly realized that I can't paste formulas. When I copy/paste, it only pastes as values. When I copy and Paste Special, the only option is "Unicode Text". No option for formulas, formatting, or anything else. Excel 2007.
View 4 Replies View RelatedI have a workbook, in which from sheet1, I have to copy first row and paste it in another workbook in sheet1 This I have to do for all the rows present in first workbook. I have written code for one single row, but for all rows,
below is the code :
Option Explicit
Dim wbIP As Workbook
Dim wbJT As Workbook
Dim wbET As Workbook
Dim mypathET As String
Dim mypathJT As String
Dim mypathIP As String
Dim vals As Variant
[Code]...
How do you copy and paste an entire row from and to another excel sheet, with control of where to copy and where to paste.
I have this paste sh_CIF.Cells(sh_CIF_X, "a").EntireRow.Paste
but it is wrong.
copy or cut then paste - paste grayed out in excel 07 tried several popular fixes from the web without luck.
Tried: the Excel repair and diagnose tool
Tried: uninstall / reinstall Excel program as well
Tried: go into Hikey - user - software - Microsoft - excel - new - 32 binary and tried adding new rule
Tried: Close Excel.2. Go to C:Documents and Settings[userID]Application DataMicrosoftExcel3. Delete the XLB file.4. Open Excel (the XLB file will be recreated - like the normal.dot) ------> This one - I could not find the XLB file - looked everywhere.
Tried: Open excel hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: application .command bars ("cell").reset Then back to excel to test it."