copy & paste values

  1. M

    VBA Copy & Paste Values

    Hello! I have poked around the forums and found variations of what I need, but I can't find or correctly piece together exactly what I need. This portion is part of a larger code, so manually copying and pasting values is not an option for me. I have a range of cells starting at F92 and ends...
  2. S

    Select cells based on colour, copy and paste as values

    Hi Everyone, I am creating P&L's that pull out numbers on OLE functions from my finance system. The end users of the P&L's do not have the permissions for this and values must be copied and pasted to hard code them. I am looking for some code that will select multiple ranges of OLE cells, copy...
  3. D

    Copy Visible Cells Only

    Hi guys, I have a simple operation which is driving me nuts! I have the following code (below) to copy my active worksheet and paste it at the end of my excel file in order to keep an archive of the report. The code works, however, this is an 8000 row report, with an auto filter - and when i...
  4. C

    If Value is Entered, opy paste into other column

    Hi guys, I have two columns and I am trying to find the best way to write a change driven code that will accomplish my goal. If a value is entered into column A, then that value is copy/pasted into column D in the same row if that cell in column D is empty. Column D should be able to be...
  5. K

    VBA to copy and paste cell from row above

    I have a sheet of raw data and column J has departments and Column C has SKUs due to a couple of the lines being split at the POS 50% in one dept and 50% in another I need to write VBA which when it comes across SKU 4321 in cell C6 will copy the contents of cell J5 into J6. I can do this fine...
  6. M

    Copy paste code into 1 cell

    Hello Can anyone help me paste code into a single excel sheet? I have googled and found various options but none that works for me. I am using excel for mac 2015. Here is the piece of code for example that should appear in a single cell and with the formatting preserved if possible. For some...
  7. T

    Using If statement to pull data from adjacent cell in a range of cells then copying to another seet

    Hello, I am working with a report where i need to sort through associates names/different job positions/titles in a table in columns 2&3 THEN copy column twos values and add it to its designated spot(next empty row) based on that associates job title. the vba that i have pieced together does...
  8. N

    VBA - Open workbook, Copy all sheets, paste as values, save as new workbook

    Hello Long time user, first time poster. I am using Excel 2010. I am currently trying to create a Macro that will do the following. Open a workbook based on text written in cell Copy all tabs from the opened workbook Paste as values Then save as a new workbook, also if possible from a...
  9. R

    Excel 2010 Visual Basic Code for looping through files copying required data and then copying results of formulae

    Hi All, I am currently trying to Loop through a selected list of files, insert 2 rows at the top of each file then copying columns A to O out, then pasting those columns in A to O in a sheet called TK of my main work book, this sheet has a lot of complicated formulae in columns P to AV, and...
  10. C

    Auto updating dependent cell validation source

    So I may not be explaining my issue in the clearest way possible, and this may have been asked and answered before, but here goes. I'll try to use images to communicate better. Basically, I'm trying to create a time card for my company in Excel. Employees will need to first select a category in...
  11. A

    if cell is contains value then copy row to next free row onto another sheet

    Hi, I have a multiple tables on multiple sheets that are upadated through a sql query. I then search these sheets for cretain text and copy these rows to a spearate sheet called other tickets using a vba macro. Sub OtherTickets() 'ActiveSheet.Unprotect Dim r As Range, c As Range, j As Integer...
  12. A

    Finding Yes and No valves and pasting them

    The first column in my spreadsheet has four different types of values "yes" , "no" , "see above" & "" (blank values) I would like excel to look at the first column and find values that say "see above". Then I want it to look at the cells above it and copy the first "yes" or "no" that it finds...
  13. D

    Need to Import Data Into Excel Only If It Matches Header Row

    Objective: From within an Excel sheet I want a user to select another file to import. However, I only want it to import the source data if the header matches exactly what is located in the dashboard file. Dashboard File: Field1,...,Field9 (row1) - worksheet name: Data Data Source File...
  14. A

    Copy formula paste value

    Hi, I'm pretty new in the VBA World and was hoping somebody could help me with this problem. I have two worksheets: "worksheet1" containing the current data (e.g. today's progress) I want to copy and "worksheet2" containing historical data (e.g. historical progress) in which I would like to...
  15. R

    VBA code to Remove Formulas based on Date

    Hi, I'm hoping I can get some helping with adding VBA code to my sheet that will remove the formulas if a certain date criteria is met. Basically what I'm looking for is: If B2>B4 then Copy and Paste Values from B5:B100 If B2>C4 then Copy and Paste Values from C5:C100 If B2>D4 then Copy and...
  16. E

    copy find then paste

    my front work sheet looks like this or something like it <tbody> today's work day 2/21/2014 total bills total people bar sales food sales 10211 1020 205.22 320.95 </tbody> and my work sheet is named "master" then i have 7 other sheets there names are monday,tues,wed,thur,fri,sat,sun...
  17. J

    Edit this code to continuously run Macro? : )

    Current, what i'm doing is i want Cell A6 in Worksheet("Compensation") to be show up looking like "less Items # 1,5,4,6." Those numbers actually correspond to cell values in Column A in another worksheet known as "Cap. Rec." when Column E holds value R. What I actually got was the formula only...
  18. N

    Copy Excel active worksheet and paste into new Workbook as values

    Hi everyone As a newbie I have run into the following VBA problem - I'd greatly appreciate any help you may have with this: I am trying to use a macro to copy the active worksheet into a new workbook, then save that new workbook and close it. This is triggered by clicking on a form (button)...
  19. J

    Custom Excel Search Bar Macro- Struggling

    Hi, this is my first post on this site so please bear with me if I don't seem to make much sense, or sound like I have no idea what I'm talking about (cos I don't)- this and vba are all very new to me and I've come to this site out of desperation so please help if you can! I'm essentially...
  20. J

    Macro for copying rows to another sheet

    Hi, I'm trying to create a macro that looks at my source data, and if the data in a certain column (column B) contains either A,B, or C then it would copy the entire row over to another sheet. If it contained a blank or D,E, F, etc,etc then it would just ignore that and move to the next row. I...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top