transpose=false

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...

Help! my recorded macro is below. My issue is, workbook "billing.xlsm" name will vary such as: "billing 1" or "billing 2" etc. I have tried applying solutions i have read in forums but i might be going about it wrong. Sub Auto_Copy_Invoice_From_Color()...

This code uses GetOpenFilename and opens up a file window so that the user can select a Workbook The problem I am having is when a user changes their mind and doesn't select a workbook. If this happens the user gets a Run-time error which I never want to happen. How do I stop this from...

Hello everyone, I am completely new to VBA, but the process I now need to perform is forcing me into learning about it. Currently I'm working on a summary workbook that needs to pull data from multiple different workbooks. All of the workbooks I need to pull from are formatted the exact same...

Hi all, I've got a large Excel document with about 16 worksheets. Alot of the cells have a colon at the end of the strng, but not all. I need to remove all of the colons sp that my Index Match formulas will work. I've recorded quide a detailed Macro and added the code in to remove the colons as...

This code is supposed to be a simple copy some columns from one tab and paste them on another. It appears to be functioning, but no values are being pasted. Private Sub CommandButton1_Click() ' ' To unprotect sheet without password ActiveSheet.Unprotect ' Copy Over Columns...

Hello, I really need some help! Keep in mind that I use the Record Macro function liberally, so this may have to do with my limited knowledge of actual coding procedures. But here goes my explanation: In Macro Excel VBA, I've coded into VBA the formulas of SUMIFS functions for each column...

I have a macro, and it is only pulling the one macro to print. The formula is not continuing onto the next one. I'm newer at writing code. I've done this both ways using the Call function and just adding the subs into once macro.... Sub RunAll() FW bonbon End Sub Sub ShocoChoc()...

My code doesn't like the first line. The name of the tab is correct Sheets("BOE").Cells("C5:C1015").Selection.Copy Sheets("Export Load Table").Select Sheets("Export Load Table").Range("A3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...

Hello, First time poster, long time listener. I'm am looking to do the below: 1) Formulas located in A2:S43 2) Copy/Paste those formulas in row 46 (leaving row 44 & 45 blank) 3) Copy A46:S87 (just pasted box), and paste the values and formatting into itself (A46:S87) 4) Loop 1-3 times the...

Hi I want to past a data to another file using macro without any duplication this below is past without considering any duplication Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.Close savechanges:=True...

The last row range of the original data set (A:E) needs to replace the last row range of a different set (T:X). What does it need to look like to copy the last row range in A:E over? Sub pastespecial() With ws .Range("T:X").Copy .Range("T1").PasteSpecial...

Hi! So we recently switched form excel 2010 to 2016 (finally) and my macros are now working differently. I assume this may be a known issue, but I haven't been able to find the best info when searching online. So here is the specific issue: My macro is performing 3 actions I guess you could...

I am trying to run the following routines in vba for Excel 2013 I want to insert this equation across all my sheets With ThisWorkbook.Worksheets .Item(1).Range("C29").Formula = "=NGL(+$A$29,+$B$1,+$B$6,+$B$4)" .FillAcrossSheets .Item(1).Range("C29"), xlFillWithAll End With With...

Hello everyone! I'm trying to automate the copy process of a certain Sheet to another Sheet in order to create a sum up of a day in my company. So: I have a workbook with 32 Sheets. 31 Sheets for each day of the month. 1 Sheet that works as a "template" to sum up the data of each day. All...

I am trying to create multiple workbooks by replacing 5 cells of data (from another workbook) to reflect a new employee's information and save under that person's name. I am a bit out of my league here. I recorded a macro by copying/pasting data from the source workbook that is storing the...

I've got a bunch of code that I got some from borrowing from other files and some from using the macro recorder. I was hoping to get some help with cutting out any unnecessary portions and condensing it. It mostly consists of a web query and the copying several ranges and pasting the values on...

Hello, I have recorded this VBA, but I need it to apply to a different Name. Sub Macro2() ' ' Macro2 Macro ' ' Sheets("Pivot").Select Range("C21").Select ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh...

This is the macro I have to format a set of data, delete certain rows based on certain criteria, and then refresh a pivot table that is using it as a data source. It all runs fine for me, but I am looking for ways to speed it up. Pretty much the entire formatting part of the macro was done by...