paste values

I have this code and I am wanting to loop through all the sheets in my workbook. I want it to unhide all rows/columns, delete all comments and copy/paste the entire sheet as values, then proceed to the next sheet. Sub xCheck() Dim ws As Worksheet For Each ws In Worksheets...

I have two list of inputs one column for postcodes (=input!A1) and one column for quantities (=input!B1). I want to take the first postcode, enter it into a specific cell (START HERE'!$E$11),then enter the first quantity into a specific cell (=SITE COMPOSITION'!$D$33), calculate the workbook and...

Hey all, Very novice when it comes to VBA, but I'm pretty good at copy/paste and brute forcing until something works! I managed to come up with this code that allows multiple values to be selected from drop downs (target.column section) as well as copying and pasting a row from an "Open" tab to...

I can't figure out how to edit this code to paste values. I've search so many forums. Can anyone help? Sub SUBMIT() ' ' SUBMIT Macro ' ' Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As Long Set ws1 = Sheets("Entry Form") Set ws2 = Sheets("Reconcile") DestRow =...

I am trying to copy and paste rows from a 18MB .xlsb protected and heavily filtered -- from column N to column EZ. I want it to paste into a 998kb .xls file. I can't remove the formatting otherwise certain cells, (based off of dates generated from an external application) -- or It will...

Wondering if anyone can help. I need help to create a macro for putting an "x" value into the visible cells i've filtered on a column. Since the column may not be the same on each sheet I'd like a pop up message to ask Yes or No to ask if the correct cell is selected at the top of the column...

I'm trying to force users to paste as values to preserve conditional formatting in the workbook. The following works for numbers but can someone please assist me in how to modify the code for pasting unformatted text (ie. from the internet) - at the moment this is returning an error because i...

hi all, I want vba code for following activity. Sample data is provided below. Copy each value in 'Find value' column and find all in column 'For Topic 1'. Paste the find all values in the column 'Topic 1'. Repeat this activity for all column Topic 1 to 4. <tbody> Find Value Topic 1 Topic 2...

Hi, I'm looking for some vba help. I have an excel forecasting file that I'm working one - on one sheet (bulk) I have data for about 200 products on which I generate different forecasts. The other sheet (single) provides a graphical view for one product - the user selects which product they...

I have come across a system that requires a significant amount of work hours that I am trying to improve. I have automated the process to now only require the copy and paste of one cell (from an adjacent sheet titled 'Input') to autofill a form. In this case it is being copied to cell A13 of...

Hi, I have some code where its picking data from one sheet and dropping it into another. However i just have a small issue with one piece as its pasting the actual formula rather than just the values. can someone advise with what I am missing or what I need here to do it? Sub Copyover...

I'm trying to create a master spreadsheet that collates worker timesheets from 100+ workers, onto a single master spreadsheet(pasted to 1 sheet, not to separate sheets). I've managed to get it to the point(with a jigsaw of borrowed code), where the timesheets do paste in to the one master...

On the tab "Instructions" I would like to have a module button. When you click the module button, I would like the following to happen on the tab called "LPA Database Scores Raw Data": There are two scenarios: First scenario: If F5 = "1" on the "Instructions" tab Copy B126:BO126 Paste as...

Hello, I am using the following macro to paste values on all worksheets that begin with "Labor BOE". Loop through worksheets and find those that start with "Labor BOE..." Select all cells Paste values (Alt+E+S+V) Unfortunately, it is not looping through my worksheets and doing this action to...

Hello, I am trying to find a better way to accomplish this task. I have a template worksheet that is copied multiple times (renames copies "Labor BOE X of N), then a "template table" is copied/pasted to each new sheet multiple times. There are array formulas in the first row of this "template...

Hello, I am looking for a macro to search column C and insert an array formula one row below every occurrence of "Resource Description." Then, in column A of each row that a formula will be inserted, there is a number - which calculates how many rows to drag this array formula down. After the...

Hello everyone... I am attempting to come up with a code to do the following . Any thoughts/guidance would be much appreciated! On Source_Sh ("SOURCE"): In column E (from row 9+)...I have a list that the user will input values - which will become column headings In cell $I$23 I have a count...

I need to take the formats from one sheet and copy to another sheet and the values of the original sheet and post to a separate sheet. All my info is on sheet 2. I need to post the formats to Sheet 1 and the values to Sheet 3. This is what I have but it doesn't work...

Hello, I am having a bit of trouble getting my code to copy/paste everything (formula and formatting) from the "Template Tasks" worksheet - opposed to just values. I think it should be a quick/easy adjustment, but I haven't been able to figure out how to modify. Any assistance would be...

Hi Can I change the below to paste values only as links are being copied. ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2) Thanks