copy & paste columns

Hi. I am trying to build a code that copy cells from non-contiguous ranges and paste on another sheet continously. The ranges have multiple columns but I just want to copy the data from a specific column (Which I select depending on a combobox value). This is the code I have for now: Private...

I am trying to solve an issue which I am struggling with greatly, and any help on it would be very much appreciated. I will try to break the issue out into steps in hope that it might be helpful. I have sheet1 that already contains information and sheet2 with information that I want to insert...

hi, while I`m running below code I`m getting error like: run-time error 1004 select method of Range class failed Application.ScreenUpdating = False Application.DisplayAlerts = False Dim wsC As Worksheet Dim wbC As Workbook Set wbC = ActiveWorkbook Set wsC = wbC.Worksheets("ABC")...

Hi Guys, I need a small help from you guys, I need to copy Paste Column A,B,C and D column into the end of the sheet with their headings. Can anyone help me out in that case? Thanks in Advance

Hi all, This is my first time posting, so apologies if I don't articulate what I'm looking for perfectly. I have a set of data that gives people scores based on various metrics in a grid and would like to email people who receive a score greater than 0 in any of the categories. I've come to...

Hello All I have to get raw data from many files in 'Sheet 1'. The structure is generally the same, because the raw data follows the column with the word DIC, but it is not in the same location. How can I use a function (such as find) to 1) search for the column containing the word DIC and 2)...

Hi, Sheet one contains a table of table from C6:AY7000 On Sheet 2, I want to create a summary of data from Sheet 1 based on 2 Criteria which applies to column I and N. On Sheet 1, I have put in a formula to link to sheet 2 for the criteria to make things easier. So BN3 = Sheet2C3 And BN4=...

Hi there, I'm trying to figure out how I could generate a report using a Command Button. I have a spreadsheet that contains data in columns, some of which I want showing up in the summary report. Any new data entered should be updated in the summary report when I hit the command button. Existing...

Hi, I have a spreadsheet with around 900 rows and lots of sets of duplicates that I need to separate from each other and analyze. I need a macro to insert 3 blank rows after every set of 9 that can be identified by the text in the last row of column A which will include the words "Site 9"...

Hello, I'm new to VBA. I have finished a subroutine that allows me to press a button to run Macro1 that will open a dialogue box to select FileB (that contains data I want to import). Right now, it will import that data (always B4:B20) from Workbook1 and insert it into Workbook2. The help I...

Hi everyone this is my first post on Mr.Excel, I am pretty new to creating macros and was looking for some help from all of you Gurus ;). I am having trouble trying to create a macro that could copy and paste into a new document for me. What the macro would essential do (if i could actually do...

Hi Guys, I have one sheet that have 133 Columns, and I need the information for only 9 of them, is there a way of looking for the header in the sheet that have 133 Columns and Copy in another sheet only the information of the 9 columns that interest me ? The sheet that have 133 Colums is...

Hi, I need to go from format "a)" to "b)". This is more complicated than a regular transpose, as you will see: a) <tbody> a1 b1 a2 b2 a3 b3 a4 b4 </tbody> b) <tbody> a1 b1 a2 b2 a3 b3 a4 b4 </tbody> Thank you in advance!! T

I am hoping this is actually pretty easy, but how do I copy all of the formulas in Column D5:60 and paste them in column E5:60 without changing the cell reference but being able to change the sheet reference. (This may be two different things) ex. in D5 the formula is = Mon!G12 I want to put...

Hi All, I am trying to copy selective data from one worksheet to another. My intent is to copy data in column F below to another worksheet in Column H. I only need to copy numeric data in Column F. Below is the screen shot of my data set. There are 244 Batches and each batch contain 4 members...

Hi, i have a "payroll sheet" which have a cell (say D2)containing the week#. There is data in a certain column let say "C" which i want to copy to my "Consolidated sheet". I am looking for a macro which can copy the values in column C in payroll sheet to the appropriate column in the...