copy paste

Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

Hello Team, am ready reach to a point that am stuck, cant find the proper solution, so i want some help from your expertise. basically i have 2 sheet, current employee (sheet1) and leaver employee (sheet2), to move the employee from sheet1 to 2 very simple, i use ActiveCell.EntireRow.Cut...

Hi, Sorry to bother vba experts. I have a code that it grabs values that match in a range in sheet1 and the matched cells copy on sheet2. But it pasting the formulas instead,, I need to paste as values. The problem is that i can't identify where to insert the paste snipped I'm sorry but for me...

Hi, I am looking to improve this macro as it is really slow to run. Context: I want to copy 2 Columns (Room & Price Actual) into my Forecast columns IF the date is less than today. I need to copy paste with values. > I am looking for a code that paste using a range method as I believe it...

Hello everybody, I just found a similar thread by fatman003 on https://www.mrexcel.com/forum/excel-questions/1112324-vba-copy-data-multiple-workbooks-into-master-wkbk.html. My problem is almost the same, but I couldn't adjust it for myself. I hope you can help me. I have an evaluation of...

can anybody explain how to copy from a range of cells in a column and paste into a data driver cell. the thought is building the copy paste out so it takes the first number (sheet a cell b1) copies it. pastes it into a different page in lets say sheet b c4 goes back to the other page copies the...

Hello, I never had this happen before, can't figure out what I am doing wrong. I have a excel sheet that looks like this...(note the blank columns) But when I paste into an email, it looks like this...(note the spaces are no longer separated) DateTypeDebit"CheckNumber"...

Hi, I have a question, in my A1 cell thare is a value 35 no formula but if I copy it then paste > formula to B1 the value 35 from A1 is also copied why is that? I was expecting blank. Thanks

Hi, My code copy and paste well, but it's pasting Formula. (i need to paste as value) i'm missing the spot where to insert the snipped to paste as a value to sheet2 Please can someone help me? This is my code ActiveCell.Range("C1:AE2").Copy...

so let's say I have to worksheets, Sheet1 and Sheet2. I would like to search for a column header in Sheet2, and if found, copy all the data in that column (except for the header) and paste it into a particular column in Sheet1 beginning from row 2 (to account for the header). I would then...

Hi all, i'm not very good with VBA. Will it be possible to copy and paste as values data from 1 workbook to another? Made a table as an example, both Workbook have 8 identical Sheets except for the data. Workbook1 contains actual data(with formula) while Workbook 2 contains projection(values)...

I need a vba code to copy multiple columns from sheet1 and paste as list in sheet2 Here is current data format in sheet1 <tbody> H G H I J K L M 16 001/2018 002/2018 003/2018 17 8000 9000 9500 18 London NewYork Paris 19 GL acct Name Plan...

I have this formula, but if is more than to rows it doesnt work, maybe on a loop it will work, someone knows how to do it? Sub CopiaSuma() ThisWK = ThisWorkbook.Name LastRows = Sheets("Draft").Range("C" & Rows.Count).End(xlUp).Row Workbooks(ThisWK).Worksheets("Draft").Range("P7").Copy...

Hi, I have this Macro where it select a range and paste it on a specific cell, is there a way it can do it on the following of the last row. Sub CopiaDetalle() Dim rng As Range Ultimafila = Range("C" & Rows.Count).End(xlUp).Row With Sheets("U-Detail") Set rng = Range("C11:AC" &...

Hi, I've been searching for a code to handle the following, but can't seem to find the right one. That is: Find the "ERROR" string in column A of Sheet1, Copy its string value in column C (J1.G0203 for example) Paste it in col/row A2 of Sheet 2. Loop until all ERROR string values are...

Hi, i have this macro, but i would like it to paste after the last row, what should I change? ' Fecha Rw = Range("AA" & Rows.Count).End(xlUp).Row With Sheets("Draft") For Each Cl In .Range("J7", .Range("J" & Rows.Count).End(xlUp)) If Cl.Value = "Active" Then...

I have search for 2 days only to find complex solutions. What i want to do is simpler. I have a current working VBA sub that selects a formula from one cell, named ("StockPriceFormula") and copy/pastes down a named range ("CurrStockPrcRange"). Current Working VBA: ===================== Sub...

Hello, Hi, how to copy data from one sheet to a table on an other sheet using macro records , i faced a problem when i click the button it's working good but if i try to add other data it's overwrite the first one(it doesn't copy the data on the next row). thank you in advance This is the...