Excel copy and paste

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Worksheet
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - VB routine to print to PDF? I'm trying to write a routine that will print a pdf page. I need to make this a routine because I have to loop through a large set of data and print a pdf page for each row of the data. My typical method for writing a routine is to record a macro and then modify the module I created. Unfortunately, when I print to pdf using acrobat distiller, the macro does not record all the steps. In particular is does not collect the filename or location. Here is the macro I created when I recorded my keystrokes: Sub pdfPrint() ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub I need to specify the filename and location in the macro (different for each row). Maybe I should be using another tool for creating the pdf files? Any help would be appreciated. Ecxel 2003/Acrobat Distiller 5 Tag: Excel copy and paste Tag: 497569
  - 2
    - Keep sheet from deleting contents Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100") Is there a way to keep the contents on the "Parts Sent to Assembly" sheet once the "Sent to Assembly" sheet contents are deleted. Thanks in advance. Tag: Excel copy and paste Tag: 497562
  - 3
    - Right clicking to summon Format Cells. In cells A1 I have Name-in cell B1 Location C1Title E1 Hire Date F1 Salary. I then have inserted A new Collumn D1 which is called Service. In cell E2 I have a Hire Date of 11/24/98 and in cell F2 Salary is $29,500. In the newly formed Collumn D in D2 I have a Formula =(Today()-E2)/365. I should be getting the Value 4.9, But I come up with 9.306849315. When right clicking on the Hire Date collumn to format cells and choosing the Number Tab and then clicking Date I need the sample area in the format dialog box to specifically say "Date" to correctly come to the right value. How could a beginner trouble shoot this problem in formatimg cells to come to the correct value? Tag: Excel copy and paste Tag: 497561
  - 4
    - Vlookup w/multiple lookups Value 1 Value 2 Value 3 1 1 A 1 2 B 2 1 C 2 2 D I want to lookup value 3, but I want use both value 1 & 2 before. What's the best way to accomplish this. Tag: Excel copy and paste Tag: 497555
  - 5
    - How stop Excel default display of pasted number as scientific equa How do I stop excel from displaying stings of numbers pasted or imported into excel as a scientific equation? Like 5.73E+08 when the real part number is 549575667. The data displayed in the formula bar is the correct full number but Excel displays the data with the decimal and "+", it does this with imported data from Monarch as well as just a cut and paste from another program. If it is one or two number s I can retype directly and it will not happen but I am pulling data lists with thousands of part numbers. This problems seems worse now that I have Office 2007. Any suggestions? Tag: Excel copy and paste Tag: 497549
  - 6
    - Vlookup referring to External Workbook or Spreadsheet I'm trying to use a vlookup formula and refer to a range name located in an external spreadsheet but it is not working. Formula is as follows: =IF(ISERROR(VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories.xls]fata',8,FALSE)),"",VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories.xls]fata',8,FALSE)) The formula is 1st checking to see if the text in cell B13 is within the "fata" range in the external spreadsheet. If the text in B13 is not found, there would be an error. If there is an error, my IF statement should return a blank cell indicated by the double quotes (""). If the formula finds the text in cell B13, the value should be picked up from column 8 within the "fata" range. Somehow this formula is not valid but I'm not sure where? I feel very stupid right now so any help would be great. Thanks Tag: Excel copy and paste Tag: 497542
  - 7
    - End Down goes to infinity If column 1 has data in each of the, say, first 100 rows, and Iinsert an adjacent column 2 and ensure that column 2 is empty, then I enter data in the first cell of column 2, then I try to copy the new cell down all the way down to the bottom of the row that is the same as the last row of column 1, how can I take advantage of column 1? I sort of would like to press copy A2 then move left to column 1, then do End Down, then move back to column 2, then press Enter. But I always end up down at infinity at the bottom of Excel. Any clues? Thanks. Tag: Excel copy and paste Tag: 497539
  - 8
    - Can you use multiple operators in a single formula? I am trying to write a formula that returns the results of 90 Days, 60 Days, 30 Days and Current based on outstanding invoices. I have an age of invoice cell that tells me the age of the invoice and i want to write a formula from that cell telling me from the current date which category they fall into. Any help would be appreciated. Tag: Excel copy and paste Tag: 497536
  - 9
    - Count a Range, but only those cells with Black font Q I have the formula below that counts the number of instances of the value held in A43 that appears in the range D9:AG35, but how could I also include the qualifier thatonly count the number of these values that are in Black font? Is this possible? =COUNTIF($D$9:$AG$35,A43) Tag: Excel copy and paste Tag: 497535
  - 10
    - Lookup formula I have 2 worsheets (sheet 1 & sheet 2). Column B of sheet 2 (Product Name) needs data from sheet 1. Data in Sheet 1 is column A=Vendor Name , column B = Product Name. I need to sort through sheet 1 to create a list in sheet 2 that specifies product name per vendor (i.e. all the products from Pepsi). I tried the following formula, but it only works if there is 1 product from Pepsi. The formula in B2 is =VLOOKUP(A1,Sheet1!B$2:C$1000,2,FALSE). What formula should I use to sort through sheet 1 to get all the products from Pepsi? Thank you in advance. Tag: Excel copy and paste Tag: 497531
  - 11
    - Modify Code I did some searching on the code I need and this one is close! Can anyone help me modify it. All I need for it to do is copy sheet2 entire row and send it to sheet1. Then when I delete the contents in sheet 2 it will remain in sheet1. Each time something is added to sheet2 copy that entire row to sheet1. Then move down to next row and so on. Thanks in advance! Dim MyRange, MyRange1 As Range Sheets("Sent to Assembly").Select LastRow = Sheets("Sent to Assembly").Range("C65536").End(xlUp).Row Set MyRange = Sheets("Sent to Assembly").Range("C1:C" & LastRow) For Each C In MyRange If C.Value <> 0 Then If MyRange1 Is Nothing Then Set MyRange1 = C.EntireRow Else Set MyRange1 = Union(MyRange1, C.EntireRow) End If End If Next MyRange1.Select Selection.Copy Sheets("Sheet1").Select Range("A3").Select ActiveSheet.Paste Tag: Excel copy and paste Tag: 497529
  - 12
    - Using Lookup Function based on Font Color Hello! I have several rows of data currently in which I would like to pull data from. I could very easily use the LOOKUP function to do this. However, both the lookup range and vector range are all numbers. I only want the LOOKUP function to search for LOOKUP Values that are in a certain font color (red). To my knowledge, the LOOKUP Value can only be a number, text, logical value, or name or reference to a cell. Font Color is not one of my options. Does anyone have any ideas? Am I missing an easy step? Thanks for your time! Tag: Excel copy and paste Tag: 497528
  - 13
    - How to multiply hours by a dollar amount Thanks to Biff for helping me get the first of my timesheet problems figured out. Now I am hoping to be able to take the amount of hours and multiply it by a dollar amount to get a total. So I want to take 25:30 (column a) and multiply that by $5 hour (column c) to get a grand total. So I put in: =a28*c28 and it gives me $3.92 which is obviously not right. Column a is formatted as [h:mm] and column c is formatted as currency which I think is where my problem is but don't know what I need to do to fix it. Thanks for any insight. Tag: Excel copy and paste Tag: 497520
  - 14
    - Grabbing data from a specific cell Hello all, Iâ??m trying to get Excel to grab data from a specific cell on an external spreadsheet through a pastlink and populate that data to 2nd spreadsheet that will be tag as a read-only document (for view purposes only). The data in the first sheet will change when new lines are inserted above or are placed at the original cell location. example: First spreadsheet cell A5 has the number 5 in it, that data is pastelinked to a second (read only) spreadsheet where it is displayed. Now at row A4 I insert 4 new rows to allow room for the new data that will be copied here. The new data in the same A5 cell is 10 and needs to display 10 on the second spreadsheet. How do I stop excel from following the first A5 and populating that data on the second external spreadsheet. I only want it too give me the data that will be in the A5 cell even after the lines are inserted above. I have tried using the =$A$5 but when the lines are adding the cell that carries the formula adjust to the new lines add and the calculated cell reads =$A$9. So is there away to lock-in on a specified cell and it not adjust to the new inserted lines. Thanks In need of help Tag: Excel copy and paste Tag: 497517
  - 15
    - Formula with sum/avg I have numbers in columns A1:A100 and B1:B100. I need the result for MAX(Ai / (Ai + Bi)). Is there a way to write a worksheet formula and avoid populating an intermediate column for Ai + Bi? Also, I'm trying to avoid writing a macro. Thank you. Tag: Excel copy and paste Tag: 497515
  - 16
    - HOW I USE MACRO FOR ONE WORKSHEET TO ANOTHER WORKSHEET i like to create one worksheet which link to other 4 worksheet.after that i would like to change file name.i need your help.please my be you can. Tag: Excel copy and paste Tag: 497511
  - 17
    - Moving data from one worksheet to another I have one worksheets with multiple account codes listed in Col A, description in Col B and amounts listed in Col C, D, E & F. Each account code does not necessary have an amount assoicated with it, however some accounts have amounts in multiple columns. I would like to have a summary sheet which moves only lines with amounts and has a separate line for each amount. I'm not sure I'm explaining correctly, how do you enter a sample worksheet without the spacing going haywire so I can give a better example? Tag: Excel copy and paste Tag: 497506
  - 18
    - conditional formatting Thanks to Conan for answering my first similar question! I now have a follow-up question. Consider this data: Col A Col B Col C Col D Row 1 family_b bob family_b art Row 2 jim family_b bob Row 3 kirk family_d will Row 4 greg family_e sam 1) If "bob" in Col B is found in Col D AND "family_b" ($A$1 a constant) is NOT found in Col C, then "bob" in Col B turns blue. OR 2) If "bob" in Col B is found in Col D AND "family_b" ($A$1 a constant) IS found in Col C then "bob" in Col B turns red. I can accomplish either #1 or #2 separately. But i can't seem to put both together. ("bob" in Col B will turn red in above data. If I remove "family_b" from Col C then "bob" in Col B would turn blue. $A$1 will change with manual input to a different "family_x".) Thanks, casey Tag: Excel copy and paste Tag: 497503
  - 19
    - if then else if nested functions in excel I need code to give the following result: (I've tried and failed, tho I think I'm close) if A=0 then " " else if B="Y" then (H8-(H8*O8)) else if B="N" then H8 here's what I have now: =IF(H8=0," ",(IF D8="Y",(H8-(H8*O8)),(IF D8="N",H8))) Tag: Excel copy and paste Tag: 497501
  - 20
    - SPSS DATA FILE Does anyone know how to access or open a SPSS data file. Tag: Excel copy and paste Tag: 497500
  - 21
    - Managing columns How do I cause a certain column to be always to the right no matter what else may be entered in? Stated differently, can I set up a column to shift over to the right so that it is always the last one on the sheet? Tag: Excel copy and paste Tag: 497499
  - 22
    - Auto Refresh of Pivot Tables not working I've created a pivot table based on a worksheet that repopulates each time the file is opened in Excel. I've marked the Pivot Table to automatically refresh upon open. The underlying data refreshes just fine, the pivot table does not. Any suggestions? Excel 2003 Tag: Excel copy and paste Tag: 497495
  - 23
    - how do I stop scrolling from column to column ? Somehow (in Excel) I inadvertantly turned off the left-right, up-down directionals and started scrolling instead from column to column. How do I get back to the cells? Tag: Excel copy and paste Tag: 497494
  - 24
    - Conditional Formatting in ref to active cell I would like to apply conditional formatting in column B to highlight the cell in the same row as the active/selected cell. Is there a way to reference the active cell in a function/formula? I'm using 2003 pro. Tag: Excel copy and paste Tag: 497487
  - 25
    - Moving data from one worksheet to another I am trying to move data from one worksheet to another - Data Sheet CC Description M S O L 010000 Labor Summary 5,000 011700 Burden 1000 020000 Site Work 2000 3000 030000 Concrete 5000 500 040000 Masonry 160000 Electrical 10000 This is how I want the result to look - Summary Sheet Cost Code CT Description Amount 010000 L Labor Summary 5000 011700 O Burden 1000 020000 M Site Work 2000 020000 S Site Work 3000 030000 M Concrete 5000 030000 O Concrete 500 160000 S Electrical 10000 Basically it moves only lines with data (040000 Masonry does not have an amount on the data sheet so it does not move to the summary sheet). If a cost code (row) has multiple entries it moves to the summary sheet on two rows with the associated description (Site Work, Concrete). Hope I have explained my problem ok. This is my first post, I have looked at several posts and nothing quite fits what I need. Any help would be greatly appreciated. Tag: Excel copy and paste Tag: 497486
- Next
  - 1
    - Default Shading Darkness on Cells Selected is there a way to make the default shading darker when you CTRL click random cells. I can't see the cells that I've clicked on because the shade is so light. I hope I'm explaining this clearly. thanks, patryse Tag: Excel copy and paste Tag: 497484
  - 2
    - Please help with report output! I have 2 workbooks. One consist of a report cover page created with textboxes, shading, etc. The second workbook has all of my data. I would like to merge the two workbooks without losing any of my formatting. I have a macro that creates the data portion of my report and just want additional code to produce the report with an attached coversheet. Sub make_report2() ' ' ' Make_Report Macro ' Macro recorded 3/5/2008 by Someone ' ' Sheets("ENLDATA").Copy Before:=Sheets(2) Sheets("ENLDATA (2)").Select Sheets("ENLDATA (2)").Name = "ENLREPORT2" Cells.Select Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("B2") _ , Order2:=xlAscending, Key3:=Range("C2"), Order3:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub -- 53214920 Tag: Excel copy and paste Tag: 497475
  - 3
    - if statement to change color of text I need an if statement in cell a1 to change the text to red if cell f1 is equal to zero. Can you help me? Thanks, Mike Tag: Excel copy and paste Tag: 497474
  - 4
    - Basic question - how to do an average I need to average a set of figures in column A. my formulas not working - i get the name error. the figures are in A2 to A22. Stupid question but how do I calculate the average for this figures in a formula any help would be great tx suzanne Tag: Excel copy and paste Tag: 497473
  - 5
    - copy if...or transfer if Dear all i have in sheet 1 a list of 3500 acounts where i have make clear of important and non important acounts that i need, by give them a simple color to the specific cell. Because there nothing to short them by color, at least i have not found anything yet, there is any way to use a formula or a vlookup to copy let say all the cells with yellow colour to sheet 2? I want to split the accounts by the color i have provide to the cells. Any ideas? Thanks in advance Manos Tag: Excel copy and paste Tag: 497468
  - 6
    - How do I convert from a julian date to a standard date mm/dd/yyy can someone give me the formula for converting from a julian date to a standard mm/dd/yy year formt Tag: Excel copy and paste Tag: 497450
  - 7
    - Extract a text string based on character I am trying to extract a model number from the title. Brand New D-Link AirPlus G DI-524 Wireless Router; I need to extract the DI-524. All of the model numbers have the - charcter, but are different lengths. How would I use the mid function, not knowing the length and exact position? For instance, here is another title: **New** Acer TravelMate TM4720-6218, 2.2GHz Core 2 Duo; I need the TM4720-6218 extracted from the text string. Thank you for your help! Tag: Excel copy and paste Tag: 497445
  - 8
    - Vlookup? populate 3 columns of data when match a common value, I have a worksheet with 35,000 row accros 10 colums with 1 column of phy-care giver number (text but it think I can convert it to a number) and in a separate table I have 3 columns of a list of 2,000 phy with the same caregiver number. I would like to match to the lareger data sheet with 3 columns of data on the same row containing Division, subspecialty, and name. I think rather that vlookup I would like to make a formula to reference the caregiver# in the larger data set to the same caregiver number of the smaller phy list then if match populate the next 3 colums of division, subspecialty, and name to the larger sheet. Thanks Tom. Tag: Excel copy and paste Tag: 497443
  - 9
    - 'Flash' random numbers Is it possible to have numbers from a predetermined list, appear in a specified cell at a specified time interval? IE from a list in (A1:A30) containing numbers from 1-30, I would like a random number to appear in F10 every 4 seconds. What do you think? -- Traa Dy Liooar Jock Tag: Excel copy and paste Tag: 497442
  - 10
    - IF THEN in cell? I am taking over a spreadsheet that has a list of options that is specific to one name in it. Currently when you choose this guy's name, the user has to hunt and peck for the choices that are specific to him. Is there a way that I can force Excel to display just those choices when his name is chosen? Tag: Excel copy and paste Tag: 497436
  - 11
    - COUNTIF question With =COUNTIF(A1:A700,A1) in cell B1 and copied down, entries which have a space after the final letter are, quite correctly, treated as a different word and therefore not included in the total for a particular word. IE: [testing] and [testing ] are treated as different words. (brackets to show the space) How can I adapt the formula to ignore any space after the final letter in the cell? Thanks, -- Traa Dy Liooar Jock Tag: Excel copy and paste Tag: 497435
  - 12
    - How do I enter degrees-minutes-seconds in a cell? I need to add several angle measurements in dd-mm-ss format. How do I enter these into excel cells and have them work? I saw postings from a year ago but couldn't get it to work. Office excel 2003 Tag: Excel copy and paste Tag: 497428
  - 13
    - Active Cell Border Color I know this can be done, I just can remember how or seem to be able to find it under help. I would like the border around my active cell to be a different color so it stands out easier than the now black border on an all black text document. I know how to add borders to cells, but I need the active cell border than moves to change color. Please help if you know how to do this! Thanks. Tag: Excel copy and paste Tag: 497408
  - 14
    - Can I randomize numbers ALREADY in a column? I have three columns of numbers Column A = 9101-9120, Column B = 9121-9140, and Column C = 9141-9160. I need to randomize columns B & C seperately, but with the numbers that are already in the columns. Can I do this somehow? Tag: Excel copy and paste Tag: 497405
  - 15
    - Formula Why do I have to click the formula line every time to get the cell to update. I put in the numbers and the cell with the formula does not update until I click on the formula line. How do I fix this so it updates automatically? Tag: Excel copy and paste Tag: 497402
  - 16
    - Sorting in a Spreadsheet with Filter I have a spreadsheet for work orders. The columns are WO#, Date, Planner, Vendor, Bldg, Room, Equip#, Date Entered, PO#. Each Planner uses the automatic filter to see the line items that belong to them. They then would like to be able to sort by vendor alphabetically. This is the part that's not working. It seems to be mixing up the lines. Can someone please help? Thanks. Tag: Excel copy and paste Tag: 497400
  - 17
    - Using A Function in a Macro Good Afternoon All, I have a function built that takes a character based coded cell value and reformats into a number with a formula. The function works fine manually using it example =BigBookingNumber(cell value) However is it easy to create a macro that read sa specific column and runs the function where there is a value (And also replace the original value) So in a sense it take each value and puts =BigBookingNumber() around it Thanks in Advance Jai Tag: Excel copy and paste Tag: 497399
  - 18
    - set up macro to goto cell with "today" in I have mutiple worksheets with daily information covering 6 months. I have set up formula that highlights column with "today" realting to current date. I would like to set up macro on each worksheet that I can run to take me to "todays" date Tag: Excel copy and paste Tag: 497397
  - 19
    - extract identical rows from 2 excel file While it may be quite easy to achieve in SQL to extract identical rows from 2 files, is it possible to do that in Excel (The last thing to do is to merge them and sort?) Tag: Excel copy and paste Tag: 497396
  - 20
    - How to create a macro in excel to use in different workbookks? Need to create macro in excel to use in different workbooks and it seems that when I recorded the macro it was only looking at the current workbook. How do I create it so that it run on all workbooks? Tag: Excel copy and paste Tag: 497392
  - 21
    - How To Detect A Negative Number In A Cell Greetings, I am trying to detect whether the value in cell M for each row has a negative number. If it does I need to change the text color for that row to red. Any help, insights or links would be greatly appreciated. -Minitman Tag: Excel copy and paste Tag: 497390
  - 22
    - Character Search a cell In Excel I need to character search a cell and determine if one of 3 text strings, 01-08, 08-07, 27B can be found anywhere in the cell, if one of them are found I need UPDATED to show in the results cell, if none of then are found the results cell will be blank. -- JPS Tag: Excel copy and paste Tag: 497388
  - 23
    - sorting a column I have four columns on my sheet but I only want to sort one of them. When I clicked that column's header to sort it but the "sort warning" pops up, saying that there's data next to my selection. I tried to "continue with the current selection," but everything turns into zero in that column! Please help! It'll be greatly appreciated! Tag: Excel copy and paste Tag: 497387
  - 24
    - Why does Excel always crash when I try to change to font colour? Font color of some numbers are currently defaulted to Red. When I highlight this cell, then right-click the button that gives the drop down menu to change the color of the font, Excel crashes. I have Windows Vista and am using Office 2007. Tag: Excel copy and paste Tag: 497381
  - 25
    - SUMIF with Multiple Conditions I'm new to the community here so bare with me if my lingo isn't up to par just yet. I'm in Excel 2003. My workbook has 2 sheets; 'Inventory' and 'Source'. 'Inventory' has: Month SKU# Beginning Inventory Ending Inventory Jan '08 555 50,000 444 35,000 333 40,000 'Source' has: Order Date SKU# Quantity 01/13/08 555 25,000 01/22/08 444 10,000 01/22/08 444 3,000 01/22/08 333 5,000 01/31/2008 555 3,000 02/13/08 555 2,000 02/22/08 333 1,500 I'm needing to provide the 'Ending Inventory' to the "Inventory" worksheet, using the beginning quantity (in 'Inventory'), subtracting the total quantity for each month (In 'Source'), by SKU #. In my terms, the Ending Inventory for Jan '08, for SKU # 555 above would be: Beginning Inventory shows 50,000 If SKU = 555 & Date is between 01/01/2008:01/31/2008 = 28,000 If SKU = 444 & Date is between 01/01/2008:01/31/2008 = 13,000 It's the 'between this date range' that is throwing me off and then coupling it with the SKU #s. Any direction is much appreciated. Truly! thnx! Tag: Excel copy and paste Tag: 497379

I did something dumb. When i copy and paste a formula, the correct formula
copies but the original copied number is displayed.

ie cell g4 (8) - cell g5 (4) = cell g6 is, g4-g5, displays 4.00

typical copy and paste

ie cell h4 (25) - cell h5 (4) = cell h6 is, h4-h5, BUT displays 4.00 AGAIN
!!!
help please

Top

Re: Excel copy and paste by demechanik

demechanik
Thu Mar 13 21:42:01 CDT 2008

Suspect it's just a case of the calc mode being inadvertently at manual
Click Tools > Options > Calculation tab > Check "Automatic" > OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"beejj" wrote:
> I did something dumb. When i copy and paste a formula, the correct formula
> copies but the original copied number is displayed.
>
> ie cell g4 (8) - cell g5 (4) = cell g6 is, g4-g5, displays 4.00
>
> typical copy and paste
>
> ie cell h4 (25) - cell h5 (4) = cell h6 is, h4-h5, BUT displays 4.00 AGAIN
> !!!
> help please

Top