skipblanks

In Work sheet figures there is a date usually a day before in this format 15/08/2019. I have a simple macro see below is there a way of closing the work book but with the date as 15.08.2019 using the path T:\11 Admin support etc as the target automatically Sheets("Figures").Select...

<colgroup><col style="mso-width-source:userset;mso-width-alt:33901;width:695pt" width="927"> </colgroup><tbody> Hi Dear Members, I have a workbook with ten sheets, one of which is a Total Sheet. I need to extract data from at least eight sheets all from the same range...

Hi Below is some code I have. There's actually a lot of copying and pasting going on between workbooks (more than I show below). I would like to speed up the macro and was wondering is there better faster way to copy paste a number of cells on a worksheet that have been identified with a...

HI, I want to copy diff cells (i.e. B2, D99 & E99) to another sheet in Column A2, B2 & C2 and every time it will get updated below (not overwrite) i.e. a3, b3, c3 etc I write following code but need to short one Sub Macro1() Dim wss As Worksheet, wsf As Worksheet Set wss = Sheets("VAC_EML...

I have code tied to a userform (on the form I have a run button which runs the code). If I launch the Userform from one tab, the code runs great. If I launch the Userform (via a button) from another tab it errors out. (run-time error'1004': Select method of range class failed) It errors on...

Hi there - bit of an Excel novice, but trying to get a Macro I have on a document updated so it ignores a few of the worksheets. The sheets to be ignored are just data, and the macro in question is a simple copy & paste job for some monthly tabs we have further in the document. Have tried to set...

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

Hi! I am trying to automate a painful process. I have a workbook that has a lot of sumifs for four countries. I will have to save workbook 4 times and value past certain ranges. I am trying to automate this process with following code. Sub Hardcode_v1() Dim z As String Dim i As Integer Dim w...

Hi How would I adapt the folowing code to copy and paste everyother cell. Sheets("InOutData").Select Range("I3:I46").Select Selection.Copy Sheets("LayoutVolumesFittest").Select Range("D55").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...

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

Hi Two things - in the below code . I have just recorded a macro to get this . 1, Is there a neater why to do this and 2, The start cell is static but the to cell can vary (j2 static. j50 can vary ) is there a way to acheive this with out having to alter the code every time...

Hello! This is my first post, so I will try and be as comprehensive as I can. I really have tried to look through many back posts to find an answer, but I'm struggling to find the right post, sorry! To start with, I have a drop down list to allow the user to choose a report to be created, I...

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

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

Hello! My macro below works. However, I believe it's not efficient. Is there a way this can be written to make it more efficient? I basically Frankenstein'd this from other macros, but surprising it works. What this does is it extract months that are in columns to rows and insert the...

Hi, I have a VBA code,I want to run 200 times for every next row.but I can't.please help. Sub Test() ' ' Test Macro ' ' Range("Q3").Select Range(Selection, Selection.End(xlToLeft)).Select Selection.Copy Sheets("Creator").Select Range("A2").Select...