selection.copy

I have a VBA that copy data from 19 sheets into one sheet(Mastersheet). Problem is that it copies data incluing formulas. I want it to copy values. How can I change the code? Code is: Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add Sheets(1).Name =...

I've only started to learn macro. I need to work on a spreadsheet everyday (different number of rows) to basically do the following: 1) In worksheet "Combined", find the total amount of "deposits" for each account (column "J") and also total number of items on deposit (column "M"). 2) Copy the...

Hi all - so I'm trying to see if there's a shorter/better version of what I'm doing? I have a macro created that I look up a value from one workbook to another and copy everything that's from the 2nd workbook to the first workbook. But I want to know if there's a way to put this in loop till the...

Hello everyone, I have recorded a macro and it works fine. I have 18 sheets that are numbered 1 through to 18. I would like this macro to loop through each sheet from 1 to 18 as I will need to extract data from each sheet about 4 times (I can change the range(D25) each time I run it. Thank you...

can any one please shorten this code in professional way please.. Sub datacollect() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("Surety").Visible = True Sheets("Lossrun").Visible = True Sheets("OPT").Visible = True Surety...

Hello, I am having an issue figuring this out. I have the below code that will open afile based on certain dates. Since the file names have varying dates everymonth I created variables that will open the correct file based on the dates incertain cells. Cells A15 and A16 have the actual dates...

Hy guys, I'm a noob in macro's, but i can't figure it out, with forum and record function. I'm starting to apologise first on my english, because i'm canadian and french :-) loool I got a totaly fonctional macro, but it's very very very long. I'm pretty sure you guys expert, can find a way to...

Hello My code that copies data from cells to an ordered list, then clears the original cells, and then copies data from the list to a different position on the form...essentially rotating the data. I believe my code is very clumsy and not efficient. I am hopeful someone can provide some...

Afternoon, I have tried recording the below macro which looks to combine the data on 9 tabs into one tab. Problem I have is that the data on each of the 9 tabs is dynamic and may vary in number of rows. I believe I have identified the problem and have made the code bold and underlined. Any...

Hi there. I had the following Original Code, working well. The purpose it to feed a dashboard file with some source data, for analysis. What is being done is opening a file, copying the data into a "Stage" file, adding few columns with formulas, copy-pasting values, deleting some columns...

Good day.. Need help - Newbie in VBA coding. have below code: Columns("Z:Z").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=TODAY()" 'Selection.Copy Range("x3").Select Selection.End(xlDown).Select...

Hi Guys, Very first time using VBA - complete Newbie. I'm using the below code to basically organise and copy data into a monthly master data sheet. I would want to build in the control to prevent duplicate values to be posted in the master data with an error message. Appreciate your help Sub...

Hi all, I would really appreciate your help as I am struggling with one VBA, I've already spent a lot of time and I can not find the solution so I would appreciate your help a lot. Below you can find the code and the result: Sub rcalc() ' ' rcalc Macro ' ' Windows("BC...

Hi I have recorded the macro to run the calculation steps as below. Sub Run_Calc()' ' Run_Calc Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("S2:DK2").Select Selection.Copy Range("S8:DK10100").Select Range(Selection, Selection.End(xlDown)).Select ActiveSheet.Paste...

Hello: I have the below statement that combines all worksheets into one. Essentially, it combines all into one called "Combined Reports". However, I would like to rewrite the sub so that a sheet called "emailList" is not combined into the report. Any help will be appreciated. Sub...

Anyone ever see these kinds of issues? My code executes just fine and quickly in excel 2010 but errors out on one line in Excel 2016? *Please forgive the archaic selects all over this code, I didn't write it but I have already re-written but the error still occurs on the same line...

All - I know this Macro can be cleaned - can someone please help me? I also wanted to know if I can change the value of my H and AH columns to only auto fill based from the value of number rows on B. Thank you so much!!! Rows("2:2").Select Range(Selection, Selection.End(xlDown)).Select...

Hi all, From reading through this site, I've written a macro to copy an input from a list, paste it into a model that calculates based on data pulled in from an external source, and then paste specials the results back to the list. However-- when I run it, the macro runs faster than excel can...

Hello VBA Superiors! I am working with a workbook that uses a index/match formula with a few named ranges. my current code works just fine, but I would love to simplify it. I am aware I could put in a single code to drag the formula across the entire used range of the worksheet, but what I'm...

Hi, I am trying to populate and clear fields using a check box. I have written something long and stupid that will not work. Can someone help me. This is what I have: If Sheets("MISC DATA").Range("C18").Value = "TRUE" Then Range("F5:N5").Select Selection.Copy...