copies

Hello all - I have a workbook that wipes clean radio buttons and input cells upon reopen. I would like a macro I could assign to a button that copies the workbook SAVING form progress to said point and allows me to SAVE AS a new doc and doc name... Without disrupting original doc or original...

I had filters on a Excel sheet and had a macro which would copy across only the filtered data to another workbook. I recently introduced slicers to the data, however the macro now copies across all the data and not just the filtered data from the slicers. Anyone know how I an over come this?

Hey guys, I have a spreadsheet with a very simple formula - ='Copy updated data here'!K173 Essentially copying over the figures from another spreadsheet. However, when the cell is blank it copies over a zero. Any idea how I can remove these automatically within the formula?

I currently have the following code to copy values from one workbook to another. It copies from cells B1:B186. Workbooks("Placeholder.xlsm").Sheets("Sheet1").Range("A1:A186").Value = Workbooks("Finances.xlsm").Sheets("Sheet1").Range("B1:B186").Value In the case where I don't know how many...

I have two sets of code, The first one, copies and inserts the copied range on to a different sheet and the Second, copies and pastes the range on to a different sheet. There is one line of code that has to be different for me. I put the lines in question in bold. Why is this? Does it have to...

Hi can anyone help? I am copying data from "AJ2:AS & lRowAJ" to "N2:W & lRowAJ" and "X2:AG & lRowAJ" If I use the following line it copies fine [CODE .Range("AJ2:AS" & lRowAJ).Copy .Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ).PasteSpecial...

Hi Mrexcel Experts Am wondering how to go about this last problem, the VBA WAY, currently facing me in my Numerical Analysis. My data starts on Cell A2 and ends on Cell U..eg. A2:U11200, A2:U17000 etc. Row 1 is Header. In my bid to further ensure "exactitude" of data due to "round-off...

Hi All, First of all thanks in advance for helping me on this. I have created a Userform that has a few simple elements in it. 1. ComboBox1 2. ComboBox2 3. TextBox1 4. Okay, clear and close buttons From ComboBox 1 you select the job role. From ComboBox 2 you select the relevant file you want...

Hi, I have a macro that copies a formula down to the end of the data (with a variable amount of rows) however I was hoping to add something or amend it so that when it copies down it fills without formatting. What I have at the moment is: Range("C2").AutoFillDestination:=Range("C2:C" &...

Hi, I have this following code: If Not Intersect(Target, Range("C8")) Is Nothing Then If Target.Value = 66 Then Target.Offset(, 1) = 66 Target.Offset(, 1).AutoFill Range(Target.Offset(, 1), "Z" & Target.Row) I would like to alter it so it does the following: 1. Copies anything...

I have a pretty neat code I use to insert a row and it copies the formulas from the row below and pastes them into the new inserted row. It then clears contents of the new row. However, IF there are no contents in that row it copied, I get an error that says "No cells were found". Is there a...

Hi guys, I was just wondering if anyone is able to help me out with this code? Currently my code copies all the rows from Sheet1 where column A contains the word "Audit" (this is the value specified in cell T1 in the code). and it appends these rows to the rows in Sheet2. However I now need...

Trying to copy a specific cell(s) from sheet 1 to sheet 2 when a value in said cell changes. example: part 1. sheet1 cell B2 value=1 sheet1 cell E2 Value is 10 Copies value from sheet1 cell B2 and sheet1 cell E2 to worksheet2 cell B2 and E2 part 2. Sheet1 cell B2 Value changes to 2 sheet1 cell...

Hi all that know more than me. Now I have a question regarding some code and how to make it work. I have written most of the code and am stuck on just 2 lines. I created the following code and the module below is called upon from the main code. The problem is because it is set to look at the...

Good Day, I have a simple weekly time sheet that currently I have to change the date each time and print, change the date, then print, until I have enough copies to last a while. I am unable to attach the file at this time, However, cell B7 would be the only date(cell) I need to change...

Hello, I have a very basic VBA code like as follows: Sub Hello() 'Removes any duplicates Columns("A:A").Select ActiveSheet.Range("$A$1:$A$27").RemoveDuplicates Columns:=1, Header:=xlNo 'Copies name from top of CE List into Input tab G12 Sheets("Names").Select...

I am trying to get this code below to work so I can print multiple copies of a form with the same sequence number in two different cells: Sub PrintCopiesWithNumbers() 'UpdatebyEntendoffice20161031 Dim i As Integer Application.ScreenUpdating = False For i = 1 To 10...

Hello , I have this macro that I need help to modify : Sub PrintSheets () Dim i As Long For i = 1 To Me.Pages.Value Sheets ("Page" & i ).PrintOut Next i End Sub Now my wish is to print two copies of each sheet (page) printed by the macro above. Then on the first Copy, I want to...

I have the following code, which simply opens workbooks that are all in the same folder (this is the source). the code then copies a range on the General worksheet within each of the workbooks. The range is then pasted to the destination workbook (the one with this code). All of the workbooks...

Hello, I have an excel sheet name 1 having data and dynamic chart. The "define name" for dynamic chart using offset functions is also on the same sheet. When i make copies of sheet name 1 the chart on the copy sheet is not dynamic. Although i have selected scope WORKSHEET while defining name...