recorded

Hello, I am looking to see if there is a formula or way to helpgenerate multiple students grade sheets based off data in a excel worksheet. Currently I have a template onanother excel document that is printed out and recorded by hand but I’m lookingto automate this process as we record multiple...

Hi I have an SQL extract table of patients with one or more diseases recorded for them. Each patient/disease information is a separate record/line. Through a pivot, I can see which patient has more than one disease recorded and which diseases are included. However, the pivot contains all...

i recorded a macro that create a pivot table but the change i make with manage data model are not recorded, so i have to make changes in data model manually in powerpivot manage data model, then again i recorded the rest of what a pivot table does. so i want a way to make changes in data model...

Were going to have a race. Each person will run a course one at a time, with finishing time being recorded. After finishing time is recorded, the next person will run the course, and then their time will be recorded. Before race ever begins, column A will have names of contestants in the order...

Hi All I'm just exploring using Add-In's to slowly build up a Function Library. Do please tell me if this is not the right way to go but the idea I have is to save the macro enabled workbook as an Add-In when I close the workbook. I have recorded a macro and notice that whilst code is...

Hello Guys, Can anyone help me on this please. I have my excel data sheet and my word document as per link below https://www.dropbox.com/s/my62tw9jsfktwo9/fixedcharge16032018.xls?dl=0 https://www.dropbox.com/s/h5wb91ymd39h3tr/mailmargeflo1.docx?dl=0 My word document is already...

I have a macro that I recorded to copy columns E-H, and paste values, then delete columns L-R. The problem that I am having is when I run the macro, instead of pasting values on just E-H, it pastes the values for A-K. I have formulas in some of the other columns that I need to stay as...

Hi, I had the following formula that was working fine but now is only returning the status of Update for all, it should look a the date in Merg Sheet(sheet2) Cell AV1 (1/03/2018) and if the date in SF Export(Sheet1) is prior this date result should be "Update" and "New" if after this date...

Hi, A coworker created a large macro that was working perfectly for a few days. She closed Excel, reopened it, and it's no longer working. It crashes her Excel now when she does anything remotely related to macros. It was a recorded macro so it wasn't like she was messing with it too much...

I have worksheets of data in the same format (different data / same format) - I am needing to routinely needing to perform a regression analysis on this data. A recorded macro (shortcut key) would be very helpful. I have attempted and continue to strike out to record a macro that: goes to data...

Hey All: Total newb to macros question, so please be patient, trying to learn I recorded a macro that opens and formats a worksheet then saves as a .csv and .xlsx in a specific file path. I sandwiched this recoded macro inside an Application.FileDialog. The problem occurs when running the macro...

I record customer requests on a daily basis. Some of these requests require actions by other teams so I must fill out other forms and send to other teams when these types of requests arise. there are requests that are not important to other teams but are written on the same initial sheet...

Hi Guys , I have a table with three columns First contain date .. it take a form like (1/31/2018) Second contain time .. it take a form like (0:00:00) Third contain a variable speed that recorded for a mobile body Now , I kindly ask your help to find a way for extracting the maximum &...

I am trying to insert a formula -with so many functions- into a cell using VBA, in order to include it in my bigger code. I wrote the function inside the cell itself and I am using "Record Macro" to get it in the VBA format. The formula itself works perfectly in Excel, before recording it. When...

Greetings, I am able to create a pivot table with a recorded macro but I do not know how to edit the code so that it automatically adjusts to the data range size as it varies from one sheet to another. Below I'm posting the part of the manually recorded VBA that "I think" establishes the...

I added a series to a chart and recorded as a Macro. The following VBA was recorded: Sub Macro2() ' ' Macro2 Macro ' ActiveChart.ChartArea.Select ActiveChart.PlotArea.Select Application.CutCopyMode = False ActiveChart.SeriesCollection.NewSeries...

I would like to be able to control the display and hiding of the Query and Connections pane in Excel 2016 (Power Query). I have tried to find the object using the macro recorder but the open/close event doesn't get recorded. Can anyone tell me if this is controllable, and if so, how? Thanks Matt

Hi, I would greatly appreciate any suggestions about how to transform a large data file containing values recorded in milliseconds (custom time format: d.mm.yyyy hh:mm:ss.000), to a separate data table showing the average of these values for other longer time periods (eg. seconds, minutes...

Good morning all, I was under the impression that if I recorded a macro using excel it would also record actions made in other Office programs, am I wrong? I have seven different price bands which each have specific customers assigned to them. Currently I have to open up seven separate e-mail...

I am looking to some help to understand why i am having an issue with a recorded macro. I want to hide multiple columns and have recorded a macro as below. My problem becomes that when I run the macro, it hides all columns from R:AZ but there are specific column i want left un-hidden. Sub...