mar

Hi guys, Can someone please can help me with this problem? I know it's a macro but I don't know how to start: I have a folder called Data in this extension C:\Documents There are 12 sub-folder (Jan, Feb, Mar,.., Dec) in the folder Data. Every sub-folder (Jan, Feb, Mar,.., Dec) has 30 files...

In the table below, the following named ranges are defined: <tbody> $A:$A TableLeft $E:$E TableRight $1:$1 Jan $2:$2 Feb $3:$3 Mar </tbody> I need a formula in E1 that will be the equivalent of =sum(B1:D1) but using the named ranges. <tbody> R/C A B C D E 1 Jan 3 7 4 14 2 Feb 6...

I want to show improvement, from last year to this year, on average delivery times on a line chart. How do I set up the chart axis, etc.? Thank you! Last Year This Year Jan 9:30:00 AM 7:30:00 AM Feb 9:30:00 AM 7:30:00 AM Mar 9:30:00 AM 7:30:00 AM Apr 8:30:00 AM 7:30:00 AM May...

Hi guys A bit of a complex one (for me as a newbie anyhow) but I need a bit of help please. I’m looking to create a pop up box with a drop-down menu containing the 12 months of the year (Jan, Feb, Mar, etc). This selection will determine which row values will be entered on my “ForEx” tab (e.g...

Hi All, I've been searching the forum, but haven't been able to find exactly what I need. I need a macro that gives below result, hope anyone can help. Data: <tbody> Jan Feb Mar P1 Q1 75 100 125 P2 Q2 30 40 50 P3 Q2 10 40 70 </tbody> Result: <tbody> P1 Q1 Jan 75 P1 Q1 Feb 100...

Hello I am struggling to work out the logic to determine a match between 2 dates, 2 products and one customer? What I am trying to do is run a macro or formula to determine from the list where the SAME customer name (col A), matches with a RED & BLUE product with the same delivery date. In...