marco

Hi All, I wrote the marcro below. I have one key element that I need to make this work and I wanted to see if this is possible. One of the variables is the CoNum (company number). When the Marco runs, the user is asked to enter the three digit company number which in turn I want it to decide...

I have a Excel Template which contains the below macro. How can I run the macro automatically when I open the template file? ---------------------------- Sub PrepSpreadsheet() Const Ffold As String = "D\Documents\file" 'change as required Dim Fname As String Fname = "Product...

My Excel Data has two coloms 1st Column is Bank A/c No & 2nd Column is Amount Excel Data Bank No Amount 17755 65000 17692 25000 17456 1500 25005 500 27201 10 26845 2 Required text File Data 0250010000.17755.00065000.00...

Hey mr.Excel I'm trying to make a marco that seach the active sheet for the value of the sheet FAM cell A1. Is this possibel to do??. Dim i, lastrow For i = 1 To lastrow If ActiveSheet.Cells(i, "G").Value = Worksheets("FAM").Cells(A1).Value Then ActiveSheet.Cells(i, "G").EntireRow.Copy...

Hey MrExcel I am new to VBA, and would like to ease my workload a bit by adding a VBA Marco to do some the boring part. I want to make a marco thats search the active worksheet for some specific names (around 5, more can be added, and will always be standing in column G) and then copy the rows...

Hello Any and all help in regards to this is greatly appreciated, I have very little VB knowledge and wish to use a macro in excel to organised a lot of data quickly, that said I'm happy to learn how to code it or if someone can provide a macro which will sort information which will be...

Hi all, As a newbie to macros I am having trouble trying to save a worksheet to CSV file. The macro worked to .txt but when I change it to .xlCSV it comes up with runtime 1004 error, method 'save as' of object '_workbook' failed. Any help would be amazing. Cheers Sub Export7400_setup_Click()...

Hey hey everyone, I was wondering if anyone could help please, I'm trying to write a macro which will copy formulas from one sheet and copy into rows into another sheet. Now here is where I'm having problems, I want to paste into a number of rows which have data in. But the number of rows can...

hi Guys, I am relatively new to Marco. I am trying to create marco, but not able to only autofill till last raw. I have created coding, but it is upto 137 row. I really want to auto fill till last row which have value in previous column. my coding: Sub Macro1() ' ' Macro1 Macro ' '...

Hi Excel Guru's :) I'm hoping one of you can help me with a macro in Excel 2007. I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1. <tbody> A B C 1 Dog Cat Bird 2 1 2 3 </tbody> What I am after is a macro that will on 'sheet2' list the data as shown...

Hi everyone. I'm pretty new to coding from scratch in VB, and I've got some code that should loop, but it doesn't. The idea eventually will be to download a spreadsheet, make a new sheet for every item in a range, and then filter for each of those items and put it in the right sheet. I have to...

I fear I may be travelling deeper and deeper into this rabbit hole called DAX and would like to know if I am at all on the right track for what I am trying to do... Some background (as simple as I can explain):I am attempting to obtain a count of stores that have the following attributes: i)...

I have a pivot table that i update every monday from a query in a different file. The pivot table is filtered specifically by date and other criteria. When i update the query i have to go into the date and click the dates off that are new since the last time i updated the pivot table. I need...

Hi, I found the below code (thanks to whoever wrote it) on this forum maybe and what it does is copy a chart from Excel and paste it into Word. I have 23 charts on a sheet and need these copied into word. I have copied and pasted the below code and made changes(see 2nd code) which is basically...

I have a range of cells (b3:f8), and whenever any of them i would like to run a marco I made called Seede. Im not sure if it matters, but it is on the sheet 2 and each one of the cells in that range is a formula reffering to cells on a different sheet. So what is inside of the cells in the...

Hi all, I am a self taught VB programmer that is new to this forum so bear with me if my question seems simple, but it should be easy to answer. I have been creating a macro in file called "converter.xlsm" that converts a database file (example: data.csv) to one that I can input into an assembly...

Hi folks i'm looking for a bit of help using macro's on Excel 2010. what i'm trying to do is create a macro that will copy a range of cells from one sheet to another depending on a option being selected from a drop down box. I've tried to use formulas but without success. sheet 1 contains a list...

Hi, I am trying to create a marco for updating number based on day of the week.... Sunday = 0.1 Monday = 1.1 Tuesday =2.1 Wednesday = 3.1 Thursday = 4.1 Friday = 5.1 Saturday = 5.5

I have several actions that need to be done within a worksheet change scenario. The Problem is that the whole macro runs instead of just the part that needs to work because of a cell change & it also goes into a loop or something. How do I run only the part of macro that needs to instead of ALL...

Hi Guys, I have a workbook which will use the Show Report Filter as pages option for a pivot table to create 16 sheets based on the filter. I also have another worksheet called "Cover Page". What I would like (if possible) is to create 16 new files ( xlsx format) based on the 16 sheets, but...