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

2016-09-19 Thread dza49
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 @

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

2016-09-14 Thread dza49
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

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

2016-01-20 Thread dza49
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 @

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

2016-01-19 Thread dza49
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

2015-02-25 Thread dza49
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 attempting to build. The situation is as follows, I have

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

2015-02-19 Thread dza49
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

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

2015-01-22 Thread dza49
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

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

2015-01-21 Thread dza49
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

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

2014-11-04 Thread dza49
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

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

2014-11-04 Thread dza49
the means you can,In all the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* dza49 dvp...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript