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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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)...

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...

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...