copy paste as values

Hello, I have a data analysis project to roll up multiple individual, macro-enabled Excel workbooks with tables and formulas. Each workbook contains 31 individual sheets (one for each day of the month). The 31 individual day worksheets each contain nested Excel tables with formulas and are...

I have 2 dropdowns and would like to copy/paste different ranges based on selected values from the dropdowns (I know how to copy/paste but not based on dropdowns). First dropdown values: -BD -AO -LM Second dropdown values: -UFH -PEX -MLC Ranges: BD UFH = Sheet10 B2:C10 BD PEX = Sheet10 D2:E10...

Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...

Good day, Hi, I am newbie here, I found this forum might will help me with my limited skills on excel. I am using Microsoft 2010. The problem: The worker will fill in/update the column Daily (C/S & KG) everyday. and I need to make formula in the column Running Total (C/S & KG), it will be...

Hello friends.. I want to use Range("Sheet1").value property instead of copy paste method in VBA to transfer values from one complete row to next blank row below. can someone please help in coding. My range is from (A1:J1) Regards..

Hello Everyone I am attempting to copy a specific region's contents and copy the Current Region back to a summary page. I have unfortunately run into a bit of an issue with pasting the data back to the summary sheet. Desired Outcome: Maintain Merged Cells Maintain Cell Highlight Colors Cell...

Hey guys, I'm in somewhat of a pickle. I have two workbooks, the first lets call "tool.xlsm" and the other "hours.xlsx", what i am trying to do is within "tool" the user will input a value in cell Q9 and from there I need to run a macro to take that value and search that value in "hours" by...

Hi- I am new to learning VBA and I need some help! I am looking for a VBA code that will loop through all 50 tabs within an excel workbook and search for any named range that starts with EQUITY and copy and paste all named ranges into one single tab within the workbook. In this case we can name...

Dear All, I am using a formula to extract the word from phrase which is as below =REPT("Relay",--ISNUMBER(SEARCH("Relay",$T64)*SEARCH("replaced",$T64))) The formula is applied on AA:BB colums and on Excel 2007. The formula works awesomely well. But file is getting havy and slower. I need a...

Hi members, I searched among many forum and everytime I found a partial answer to my issue. I have a spreadsheet that users will have to populate. My objective is to keep the formatting as it is. i would like them to be unable to change the format when they copy paste (keep value only). I...

Hi, Please could you help with the code below, I am very new to VBA I want to open a file whose filepath and name are determined in A1 of Sheet1. Then I want to copy the entire sheet "S1" from the newly opened workbook back to the original workbook, and paste values to a Sheet called "dump"...

I need some help: I try to select all the sheets in workbook except the ones in the array, and make copy paste as values (make values, not formulas in all the sheets in workbook except the ones in the array) what is wrong? thx Sub CopyAsValuesSheets() Application.ScreenUpdating = False Dim sh...