copy & past

I want to copy three columns in Excel: B-E-G into another sheet so that they will be paste in the same order, I mean they will be paste in column B-E-G not in A-B-C. How to do this, please?

Hello, I have a report fire every morning (1 workbook with 1 sheet) showing what active items need to be worked on (my team tasks are no color fill rows and all others team tasks are grey fill rows). Columns A and lets say J are blank for me to write status notes/dates in. Once I push it out...

Hello! I'm still a beginner on so let me know if i'm not clear enough. I need to copy from Sheet 1 and paste on Sheet 2 in a automatic way, so when I click on a button on Sheet 1 it pastes on Sheet 2. The data comes from 4 Drop-down lists with multiple cells on sheet 1. I learned how to do it...

i am trying to copy a worksheet from a workbook that connects to an oracle database and then paste that sheet in to a network located workbook then name that sheet to todpays date. i am getting an error and when i hit debug it gos to the activesheet shapes line. i will be summoning this with a...

Hi I have a numbers of rows with dates, some of the cells are blank in these rows My manager asked to to find the earliest date in each row (used formula =SMALL(A1:D7,1) this returned me the earliest date from the row I need to paste this result (earliest date) into all the cells that have a...

Hi, I want to to copy and paste to cell, near the cell with the text with formula, text not formula. Like in the photo, but automatically. Sorry for bad english. Can you suggest me something?

Hi Excel Masters! - Attempting to write a VBA w/button that can be clicked that would permit roughly 18 specific cells to be copied and pasted into specific cells in specific columns. Each time the button is clicked, the data is copied and pasted in the line below the previous entry. Below is...

I have 2 sheets, Sheet1 and Summary. In Sheet1, the first row contains text that may or may not be contained in column C of Summary. I am trying to copy and paste the values in Summary's column D alongside column C matches to Sheet1's first row (the data in Summary is already grouped by column...

Hello, I'm new to vba, i saw a post when i was researching to: how to copy all the details from one sheet, copy this and save it in csv format on a specific folder. Then luckily I saw the code @Georgiboy posted and tested it: Sub Print_Test() Dim FSO As Object Dim TextFile As Object Dim rCell...

Good Evening!, I am an VBA newbie and need some help. I am writing a small script that should help me. Now i have some trouble with sending an email via IBM Notes. My script opens a word doc. and copy the whole document to the clipboard. After that it opens an new Notes Mail Document and...

Hi All, Hope there is someone who can help and utter newbie in VBA coding. I have a workbook with multiple sheets. The first sheet (PFD Copy) is my master sheet from which I want data to be pasted into other sheets. The following is the code I have written so far: Sub Frommastertobuftarget()...

Hello I have a workbook name time_card_calulator and time card i wan to export the total hours to the time card in such a way that it will be adding up data from monday to friday over and over weekly when data is being export depending on day. but each time it adds up out of the table i...

Hello everyone, i am trying to create a worksheet that will find the value input into column "D" and turn the other cells in that row the same color for example: before input after input currently I have the below code and don't know where to go from here Private Sub...

I am working on making creating an archive of UTMs that have been created using a simple form. I am having issues with the pasting portion. My VBA code will insert a line and then insert the timestamp into column B in the "UTM Log" worksheet as required, however it is not capturing the UTM in...

Hi, I try to copy column from a workbook to another one(The first one is not open, but can be opened if needed, and the second one is where my macro would be). I get the path to my file from a function(Which return a String) bc the file is often updated(That part work with no problem). The...

I have a folder having total 13 workbooks with same sheet name "Annex 2" . I need to open each single workbook (from those 13 workbooks) and need to copy data from column A to P from Sheet "Annex 2" and need to create a new Master file and paste into it. Please help me out with this. Thank you...

I have used and adapted code from another thread on the site however there was errors regarding the size of copy and paste due to using EntireRow. On one sheet I have a data validation list of either outstanding or completed with the aim for excel to cut and paste the row to the "Done" worksheet...

Is there a way to copy and paste formatting from a range of cells on one sheet in a workbook to the same cells on multiple other sheets at the same time? I have a timekeeping workbook where I have 52 tabs where each tab is a week for tracking hours worked. I need to go through and adjust...

Hi all, I need a VBA to add the Colume Headings Range A1:N1 in to the next empty Row, I need to keep The formating etc. using the pictuer as an example i would like to copy row A to the top of the Transport and top of HQ, the amount of rows in transport and HQ can be different every time.

Hi all, I have created a macro which counts if specific folder "CopyFrom" contains files begining with the name specified in column "B". Formula takes number of rows to run macro "x" specified in "R1" and shows the count in column "S". I am running into 2 problems here. 1. I can not make...