automatic

I am a beginner in excel. I have to update a master workbook monthly with new data from a temp workbook. The two workbooks have the same column heading. For now I have to find the blanks manually to fill row by row which is very time consuming. How do I configure the excel to search for the...

I have inherited some workbooks from a coworker that left. Needless to say they are not documented. So I have done some VBA coding and can debug most of it. But, I cannot get a handle on what is probably a very basic understanding. When I open a workbook (.XLSM) nothing happens. That is, the...

Hello everyone i have developed to send a email via outlook the code seems to be fine ,but i just have small problem , i have to print numeric and alpha numeric value from the cell but my code doesn't allow to do that, it shows error. the code is working fine when i use alphabets in the cell but...

Hi there, I was wondering if its at all possible to automatically send an Email from Microsoft Outlook when a cell has changed. The columns that apply to the cells are stated below. An email should only be generated if a cell change occurs from row 7 and below. If column L changes then email...

Hello, I am trying to figure out if its possible to develop a macro that will create named ranges for me so I don't have to manually create them. In column A I have the name of each product category (996 product categories - rows 11:1006) . In columns T:BQ I have the name of each product...

Is there a way to automatically date stamp an Excel cell when the cell contents have been edited? Maybe create a comment with "today's" date, showing what date the cell contents was entered.

Hello everyone, first time poster here. I have been trying to figure out how to write a VBA code that will tell Excel to run a goal seek in the background every time a value on my template I created changes. Please bare with the "random" cell locations as this is a custom template. I need a...

Dear VBA Gurus, I am dealing with several VLookups in my Report. I would like to set a VLookup from one worksheet to another. Currently, I am using this macro Sub Vlookup_TestName()' ' VLOOKUPS ' ' Sheets("MRT Scor").Select ActiveCell.FormulaR1C1 =...

Hello, Currently using the following macros to automatically email a spreadsheet out at 9am. For some reason it sends the email more than once at times (at the same time). I'm also looking to have it email at two different times in the day (9am and 1pm), but only once each time. Sub...

Hi All, I'm looking to assign a macro to a command button that allows me to save the selected range to pdf in a predetermined folder in the directory. On top of this I would like to be able to automate to file name based on cell contents in the worksheet. Is anyone able to provide the code for...

Hello, I want to utilize a macro to place left braces next to each merged cell. I already have a macro that goes down a column and merges groups of cells (going from A,B,C,etc): Sub MergeCells() Dim LastRow As Long, Ar As Range LastRow = Cells.Find("*", , xlValues, , xlRows...

Can anyone help me with a VBA script to automatically merge cells that are lettered down A,B,C, etc. in 1 single column? For example, letter "A" might possess only 2 cells, but letter "B" could carry 2 or more, etc. Is there a way to automatically merge each "lettered" group of cells...

Here is what my workbook looks like: 4 tabs called Master, Student 1, Student 2 and Student 3 On the master I have a list of objectives on column 1 on the 3 student tabs i have used the formula =Master!A1.... all the way down to copy the objectives from the master sheet. Now the problem...

Hey guys! I am a new user trying to learn more about the functions of Excel. I currently am working on a project where I have the results of business accounts and their performances on a month to month basis. I have conditional formatting in place that will automatically tell me if the account...

Hi, I have a pivot table linked to a warehouse that displays sales Values. I would like that on opening of the pivot table, the date filter for the report is automatically set to yesterday's date instead of displaying the last saved date. I have never used a VBA code and tried to do it...

I have a spreadsheet with approximately 1,000 rows. Each row represents a store location These 1,000 rows are divided into approximately 310 numbered districts (3 digit numbers). At the end of each district I need to have a blank row, followed by a row with the district totals, followed by...

so what I need to do is add labor cost and parts cost together to get a total that is all correct all I want to do is be able to type a number in a cell with no decimal point and have it automatically change it to currency with dollars and cents with the last two numbers always being cents...

Hello, Would you help me,Please? I would like to do the following: I would like to copy row 1 before row 2 , row 3 ... and so on. So that when I print the sheet and cut the paper, Mark will see the first raw and his own data and he is not allowed to see the data of other persons. Also, each...

Hi, Need help modifying the below code. 1. I would like the script to run automatically when the file is opened. 2. Instead of browsing & selecting the file location, I need it to automatically use file location "Z:\DEPTS\SAP\SupplierRequirements" 3. When file is closed I data should be...

Hello, I would like to set manual calculation when a workbook called "AMS" is activated. The other workbooks should be always in automatic calculation. Moreover if the workbook called "AMS" is activated and then closed and saved..the other workbooks should always be in automatic calculation...