automating

Hello, I'm very new to this forum, just created an account because I've been googling for hours and I can't find a solution to my problem. Hope someone here will be able to help me. I have a 1st table, called "IDStatusSettings" in Sheet 1: This table is displaying datas from other sheets in...

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Hello All - Firstly, I need to apologize for the background noise. I am sitting in a tavern editing a lengthy list from a recovered hard drive. It wasn't until I played the video back that I realized how noisy my environment is. BTW - This same environment is protecting me from chronic tedium...

To save time, lets just assume the Microsoft Trust Prompt after opening a hyperlink will open regardless of trust center settings. I tried automating the prompt with something simple like: Application.Wait (Now + TimeValue("00:00:05")) Application.SendKeys ("{LEFT}")...

I need help automating this sheet. I want to highlight the winning team on the left, then have the losing teams automatically highlighted for every person. After that I want the total highlighted cells to be counted and output at the bottom for each person. Please see my example I hope I made...

Hello, I would like to create a toggle in Excel that changes a revenue growth percentage in a cell, this in turn spits out an internal rate of return. How do I go about automating and getting this in a summary chart? Thanks in advance. Erik

I am working with a survey on the Survey Monkey website for gathering data to put into an Excel sheet that creates a scorecard. However, I want to automate the entire process, and I have been able to get everything but the initial data pull. I was wondering if anyone knew a way (whether a...

Hi all, This is my first time using a form for excel help. I have a fairly good grasp on excel but have run into a brick wall with a model I am trying to automate. The model analysis one year of electricity prices. Each day of the year has 48 (half hour) periods with a price. eg. Sheet 1...

Windows XP Excel 2010 I have eight password protected, multi-tabbed, Excel 2010 worksheets which I would like to automatically refresh each morning before I come into work. How can I go about completing this? I am a beginner with VBA. Thanks in advance for the help!

I am trying to automate a gant chart. If I have the start and end date, how can I make the cells highlight according to the month (the name of the month is at the top of the chart)