$$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

Anyone have any idea on how to record macros in Outlook and have a place where I can research each individual step in VBA? Thanks, Daniel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www

$$Excel-Macros$$ Outlook 2016 - Macro Help!

Hey Everyone, I was hoping for a macro recorder in Outlook but sounds like it doesn't exist so I have a relatively simple process but have no idea where to start to make it happen. Here is what I'm looking to do with the selected email in my inbox: 1) Forward email with attachment to select em

$$Excel-Macros$$ Re: Having trouble with INDEX and INDIRECT

Wow, such a stupid mistake!! Thanks so much. I had intended the array to go to $AX$501, just a typo! Thanks again. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussex

$$Excel-Macros$$ Having trouble with INDEX and INDIRECT

Hello, I've struggled with building a INDEX formula that would reference dynamic file names and tabs which I'm hoping that someone can help with. I'm building a file that would consolidate hours entered into a schedule by a shop. Each week I would define which week from which I would pull the

$$Excel-Macros$$ Re: In need of an Excel macro to filter selected data and copy it incrementally to a central file

onsolidation Macro.xslb* and in the tab called *data*. I am only using ShtNo for the filter reference in the store files. Thanks for your help. Daniel On Thursday, 19 February 2015 17:20:27 UTC, dza49 wrote: > > Hello, > > I have a couple of unique requests for a macro that I'm

$$Excel-Macros$$ In need of an Excel macro to filter selected data and copy it incrementally to a central file

Hello, I have a couple of unique requests for a macro that I'm attempting to build. The situation is as follows, I have the same file located in different locations on the network where different departments enter in their data by week. I need to go into each of these locations, filter the dat

Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

Excellent, thank you sir!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please H

$$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

Hello, i'm having trouble with a macro that i've sent up to: 1) unprotect a sheet with a password 2) do some filtering and set a print area 3) apply the password again Looks like steps 1 and 2 are working fine but step 3 isn't working. After running the marco I can click the "Unprotect Sheet" b

Re: $$Excel-Macros$$ Cell Reference to consolidate specifically named tabs into one spreadsheet

> > I'll make some sample files for testing and then put together a macro for > you. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,T

$$Excel-Macros$$ Cell Reference to consolidate specifically named tabs into one spreadsheet

Hello, I have been given a task where I have say 10 spreadsheets located on the network which have the same filename and tab naming convention. Each spreadsheet will have a tab for each week of the year that contains reports that I'd like to consolidate. For example, each spreasdsheet will ha