automated

Hey everyone, excel 2013-64 bit Looking for help on how to lock the data table that is linked to my pivot tables in a automated report. I data dump into multiple sheets, and run a macro that deletes the oldest data (3 months previous), then shifts and renames all data. example table1 table2...

Hello, I am trying to get values from a table that looks like this (simplified to a comprehensive and complete example): Anybody have an idea of what function I can use if I have both the size and name of the item (ie L, Hat) to retrieve the price? I am using a "table" (that is not made as...

Hello, I have a pivot table that I want to show averages. I set it up to show everything as averages & save and close the file. I then have an automation that imports new data from TOAD into the file. When I open the file back up, the averages have all been changed to sums AND the Grand...

Dear All, I have a task to capture 3000 screenshots. I have successfully concatenated the hyperlinks in Excel and then screenshot the page with the hyperlink present underneath the screenshot and then save to a word document. To do this 3000 times will take an extremely long time that I do not...

I have made an automated macro file that runs a hold queue every 15 minutes. Now we are looking into the possibility for multiple locations being able to add notes for the lookup without all locations having to run the macro. I have experience with shared files and the issue is there is only...

Hi all, I'm relatively novice when it comes to Excel, however I do understand most concepts and by trial and error - and reading material - I've managed to create (again) relatively complex sheets when needed. Just to set expectations. So, to my particular case. The main purpose is to have a...

Hi, Was wondering how to automatically get the name of something in Sheet 2 from Column A into Column E-K in the same column, depending on what letter I put in Column H in Sheet 1? The index of which column the name is put depending on what letters are put in is below. WB - Column E B -...

Hi, I am very new to VBA but can follow the basic logic fairly well. I have a list of people on sheet 1, column A. The corresponding information for each person is listed across 5 columns in sheet B (cols A:E). **The row numbers are consistent throughout the sheets (ie. Joe is listed in Row 5...

I know there are several threads related to this, but I have not found any to solve my problem. I am new to VBA. I have the task of pulling results of an Access query into Excel, formatting them in a "standard" way (the data will be formatted the same everytime in every report), then...

So my GySgt put myself and a friend in charge of making an excel program that will automatically Email 5 people with either the whole document, a link to the doc, or just an email using the cells to inform them on what needs to be checked. And I don't even know where to start. Ill try explain...

I developed a spreadsheet to score golf tournaments, do skins, various flights, etc. to help the Men's Club. It has been fun but an Excel expert, I'm not. If I could solve the problem below without using a macro that would be preferred. Once upon a time I was a programmer, but that's moons...

Hello I have an Excel 2010 file with a macro built into it to refresh several tables drawing from an outside source (AS400/PRMS specifically). The file is set up in a such a way that the tables are condensed & combined into an easily readable report. The report will be used by several...

I need a timeline similar to this, that I saw in another post. (I'm a newbie to this forum, and for some reason, the link to a similar chart is not showing when I submit this post. Hence, I am morphing the link a bit so as to try to get it to show in this thread) http: //www...

Specifically what I want to do is: I want a bulk amount of links from a column I have in excel like this: http://www.ImageSite.net/core/media/media.nl?id=3730&c=ACCT103457&h=e8090dfd62c03838ac16 to download to this location on my computer: E:\Documents and Settings\User\Desktop\all images and...

Hi, I have totally no expierence with writing macro's and always use the record button. I want to use excel to analyse test data. Here starts the problem. When I stop the test it always ends with a unknown ammount of row filled with '****'. When I start using functions these cells give...

I am using xml in VBA. The code below adds an item to a shopping cart on a remote website (posts a form). Then the code displays the result in Internet Explorer. You can see in the response there is a "get estimates" button. I need to automatically click that, enter location info, and get the...

Hi! I´m using excel 2011 for mac and wonder how I send an automatic e-mail with information from a sheet. On sheet one I have a list of customers and their information. I.e NAME EMAIL Anthony Hopkins anthouny_1817@hotmail.c On sheet two I have a receipt that picks up...

I have an excel spreadsheet that is automated using Visual Basic. My master spreadsheet receives data from 31 different sheets. I realized that when it is compiling it is rounding up. I have tried everything I know to get it to stop rounding because the data with rounding is incorrect. I...

I have multiple worksheets that I need to run the same macro on. I've tried several code examples I found online to do this, but none of them will work using my code (which works fine on individual worksheets). They work fine when running "as is", but won't cycle through the worksheets when I...

Hi there, I am using subtotals on a daily basis to get batch totals of money that a supplier has banked on our behalf. For clarity, I want to highlight every alternate subtotal and its preceding rows so that when printed each group of values that make up a subtotal and the subtotal line itself...