selection.copy

Hey Guys, I am looping through a directory of files I need to modify. I copy daya from the open file to a temp file, modify it then copy that data back into the source file. Not the most elegant process, but easy for me. The problem I have is activating the source file again after working in...

Hello, I have attempted to create a VBA which takes data from certain cells on a form and copies them into specified cells in another sheet. The intention is that the code will find the next empty cell of each column. My problem is that the code appears to just overwrite the cells, it works...

I want the below macro to leave the user on cell A3 in the sheet "Crew Satisfaction Data" but for some reason it leaves the user on a different sheet ("Response Calculator") that isn't mentioned at all in the Macro. Can anyone tell me why and how I can fix it? Ewan :O)

Hello all, i want to find out if there is a better way to copy from sheets1 through 9 and paste to sheet "master" one sheet below the other. here is the code i have cobbled together which does work but maybe there is a more efficient way? ' select the range to copy and paste to "master"...

Hey guys.....:) Is there a way to turn this into a loop?:confused: Worksheets("Data Entry").Select ActiveSheet.Shapes.Range(Array("Picture 2")).Select Selection.Copy Range("R2").Select ActiveSheet.Pictures.Paste.Select Worksheets("Data Entry").Select...

I have an EXTREMELY large data set in excel with varying data sets (some have 12 lines and some with 18, etc) that are currently in rows that needs to be transposed to columns. All the groupings are separated by a empty/blank line. I started the VBA to transpose this it but dont know how to...

Hi am new to vba. How to repeat the commands below and paste results in row C8, C9, etc. Thanks. ' Sheets("Rand").Select Range("A1").Select Calculate Range("A1:A8").Select Selection.Copy Range("A12").Select Selection.PasteSpecial Paste:=xlPasteValues...

Please help! I have a workbook with c300 tabs - all tabs are formatted the same (i.e. same headers) but have different numbers of rows. I know that to consolidate all of these into one sheet I can use: <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...

I am trying to figure out how to take a macro I have made for Row A. Then if i were to select another row, it would run the same as it did for Row A. My example macro: Sub Macro2() ' ' Macro2 Macro ' ' Range("D1").Select Selection.Copy Range("A1").Select ActiveSheet.Paste...

I have this code: Sub CopyPastefoo2() ' ' CopyPastefoo2 Macro ' ' Sheets("RawData").Select Range("A2").Select Range(Selection, Selection.End(xlDown)).Select Sheets("DataCalcs").Select Range("AF2").Select Range("AF2").Formula = "=IF('RawData Old1'!A2=0,""Base Bid""...

I want to copy a template which contains a combo box from sheet "Change_Block" to the sheet "Scope_Changes" this will be one several times, so i don't know te combobox name upfront .. I tried this in a macro .... but the " With Selection" gives the run time error 438: Object doesnt support...

Good Day to all, I am new to VBA, I have Budget data in sheet1 as follow <tbody> A B C D E F G H I J K L M N O P Q R S 1 Comp Div Acct CC PG Dim CURR Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 905 101 4100 UC000 526 LU1 USD 52 58 53 63 57 56 53 59 57 63 69 72 3 905 102 4215...

I have a code I've been working on to open files in a folder and see if they meet certain criteria. If so it copies it to another sheet where I am organizing the data I want. The issue I am having is when it finds a file that does not meet the criteria it just ends the code and doesn't continue...

Hi, i have encountered a problem to select the columns from B4:E4 to P4:T4. Below is my intial code but it does not work. Union(Range("B4:E4"), Range("P4:T4")).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy 'P Call uidoc.Paste Please help!!! I need to use...

Please help me with looking up the empty cell and paste value in the next cell. Windows("Warehouse Schedule.xlsx").Activate Range("C5:M170").Select Selection.Copy Windows("Attendance Report.xlsx").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...

I have a macro, and at the end of it, I'd like to copy my selection and paste the data right where it is, but paste values only. I have this code: Range("J4:Y4").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy 'Range("J4").PasteSpecial Paste:=x1PasteValues...

Hi, I am working trying to create a macro that will populate different worksheets based on a value in the dropdown selected in the tab called "List". I need the Macro to loop through all the values in the dropdown and populate different tabs based on the value. The name of the tab corresponds...

When I open a file through a macro, it doesn't show up in the recents. How can I make it show up? Sheets("RAW DATA").Select Range("A2:K2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Workbooks.Open Filename:= _ "\\blah\blah\blah\Elimination...

Hi, I am trying to turn this macro into code that I can use everyday without having to have to change all the ranges daily. i have a report that has several formulas in in row and each day I need to copy and paste the formulas into the next row. the report is daily and built daily with the...

I have many columns in my spreadsheet Some cells have formulas others do not I tried the following code to improve the creation of all formulas on the worksheet rowM = 16000 Sheets("Sheet1").Select Range("BA4:KZ4").Select Selection.Copy Range("BA5:KZ" & rowM).Select...