copy & paste from sheet

I am trying to split data in one cell into multiple cells and then copy it into a new page. With the code below which I have obtained from Excel VBA- Split Cell Strings into individual cells and copy cells to new sheet - Stack Overflow I can split, copy and paste data for the "Setup" rows and...

Hi all! I'm working on a shared tracker with Contact details, dates and more information and it gets updated every day from different people and every time they update or input new data, they are obligated to change its font to red. When I see the new updates, I consolidate this information...

Sub CopyRowDemo() Dim Rw As Long, LstRwRaw As Long, NxtRwDest As Long Application.ScreenUpdating = False LstRwRaw = Sheets("Raw Data").Cells(Rows.Count, "B").End(xlUp).Row For Rw = 3 To LstRwRaw With Sheets(Cells(Rw, "B").Value) If .Range("B6") = "" Then NxtRwDest = 6...

Hi all, Im trying to figure out how to loop through a who workbook and copy value if for example B5 value match Sheet name in the other workbook, then i should copy value from E5 to that sheet and place it under the right column so if its for August month it gets the data from then it should...

Hi, I wonder whether someone may be able to help me please. I'm using the code below to copy a selected range of cells, create a new workbook and then paste the data into sheet 1 from the source to the recipient sheet. Sub copysheet() Application.ScreenUpdating = False Dim Src As...

Hello i have assigned a task like copy the entire values of one excel to another excel file when clicking a macro button, is there any kind of vba code for that ??? thanks in advance

Hello, I'm fairly new to code but can usually problem solve my way to getting it to do what I need it to. I have been trying for days and have not had any success modifying scripts to get them work. HELP! This is what I'm trying to accomplish: 1. Copy "A4" and "B4" in sheet "DataEntry" 2...

I am trying to copy data from one worksheet to another using VBA. This is the code I currently have: Sub sbCopyRangeToAnotherSheet() Sheets("Active Worksheet, A2").Range("Q1:S52").Copy Destination:=Sheets("Analyst").Range("B3") End Sub I am trying to link the sheet name in my VBA code to the...

Hello Folks, I have approximately 1000 sets of 80 excel spreadsheets. I am trying to combine each of these sets of 80 spreadsheets to produce one main spreadsheet for each of the 1000 sets. Basically at this stage I would need to copy and paste data from each individually, onto one central...

Hi guys, I'm hoping someone can help me with this - it should be fairly simple but I'm quite new to VBA and struggling. I've found answers to similar questions on the site, but not quite the solution I'm looking for. I basically have a master report that is produced monthly and pasted into a...

Good morning all, I have the macro below that copies all of my worksheets into one consolidated sheet. Can any help me to change this macro so that it only copy.paste.values all of the sheets into the "Consolidated" sheet. Some of the formulas are causing issues when copied over. Thanks so...

Hi, I need to merge to Macros to work with each other. The first Macro grabs names in a cell range then makes new tab names with the names in those cells - Sub Invoices_Add_Named_Tabs() Dim MyCell As Range, MyRange As Range Set MyRange = Sheets("Address").Range("A2") Set...

Excel 2010 VBA My intention is to copy cell text value (containing a list of information provided by the user) and paste it to two different cells. The intent is to allow the user to edit the record within a userform. If the two text values are not equal, I would enable the "save" and...

Hello, thank you for taking the time to read my question. I would like to have a 'Submit' button that when clicked will copy and paste the value of cells AJ8:AJ42 from a sheet titled 'Activity Sim Hours table' onto a different sheet titled 'Config hours'. I'm struggling with getting the cells...

Excel 2013 VBA Assistance needed. New user to VBA so be patient. I have written code (with some help from videos) to look at a given name in Worksheet POs. Count the number of existing worksheets. If the name is not existing, create a new sheet with the new name, then return to Worksheet POs...

Hi all, please help me to solve this problem. I have 1 file CSV and 1 file Summary excel. I need someone help me to make some action as below Step 1 : I want to copy data from specific cell from CSV file ( ex : G2~G1000) Step 2 : Paste data into sheet "sample" of excel file (ex : Summary file...

Hello, I'm quite new at this, so please forgive any lack of knowledge. I'm trying to get a macro to search for a term in a column (in this case, Camacho Services and column D) and when found, copy the row that has that data to another sheet. As I am a newbie, I modified the code from...

1) We have a program that creates a "New Worksheet" (csv) for me everyday with unique information. The name of the "New Worksheet" is always exactly the same. 2) I copy the "New Worksheet" information to my "Existing Worksheet". 3) The problem is that in my "Existing Worksheet" the links...

Hello Everyone, I need help in writing a code which does the following: 1. Open /pop up a dialog box which asks the user to select a file from the computer 2. Copy paste the data from a worksheet in another workbook (say workbook A) to this newly opened workbook I am not the only person who...

Morning all A bit of a novice with Excel but I've been tasked with copying data from one Worksheet to another based on the value of a cell in the original worksheet. So in Column B, any cell with "Monies from Client" along with corresponding data in the same row under Column C, D and E would...