Hi,
if I have a list of pair (start_date, end_date) what technique to use to filter by month some calculation --see attached file--
in the attached example, the measure should return 3 as a result of the selected range (Feb)
thanks.
Using Dax; I want to lookup a value by a date, but ignoring the day (just some moth and year) to fill a calculated column
some thing like IF AND(month(table2[date]) = month(table1[date]), year(table2[date]=year(table1[date])) I will get the data
this is a sample file ...the purpose of this formula is to find a sequence that the count exceed a threshold value, and start filling from the empty cell to reset the count (it does not have to be 0)
thank you for the help, and I'm here for any other clarification of the problem!
Hi, I need help using only formula to count last "cl" sequence before empty cell in:
a,b,ab ,ac, cl, bb, cl, cl, ab , cl, cl, cl, cl, cl
the count is 5
And for this sequence cells:
a, b , ac , cl, cl, cl, ab, ac
the count is 0
I already red that and I still struggle to convert the point from screen coordinate to Point inside excel sheet.
and I use Workbook_SheetSelectionChange to capture the mouse click event!!
Hi,
in excel 2007, How can I change the cursor appearance other than the 4 XlMousePointer?
Also I want to capture the mouse event and cursor position Left, Top in Point in order to add a shape at that location?
Thanks
Hi,
The problem:
Using excel 2007 and given 2 workbooks "wbA" and "wbB", what I want is to transform some cells value from wbA.sheet(i+const) to different cells locations in wbB.sheet(i).
Is there a tool or a macro for this task that I can start to customize it?!
More info:
if I can write a...
Hi,
I write a programe in C++ (no MFC) to do calculation and I use excel to plot the results;
So for this reason I need to fill 3 big tables to 3 excel worksheets .
untill now my solution is to output the data to a 3 temporary csv files, and open and move those sheets to a master workbook then...
I see that the data is organized in complex way.
and you need ony one case of red per period (day/night)
So I think only one column is enough!
Why not juste create a simple "table".
it is true that you will enter more data but the filers
by Name or month or years or Period will be a piece...
I hope that you can report the leader board of accepted answer in the new forum.
or at least "I like" counter.
So blah blah ... like this one will be filtered
PS: did I got a new post now? from nothing!!
Regards
wbk is a variable that hold one workbook at a time and loop in all your destination workbook(s); those destination files can be browsed for example.
you can check this file for a compleate code.
http://www.mediafire.com/download/c57it3z5xwhdqs7/AddSheets.xlsm
regards
Try this it may do your work!
Option Explicit
Sub Filemover()
Dim sPath As String, dPath As String, sFN As String
Dim r As Range
Set r = Range("A2")
Do Until IsEmpty(r)
sPath = r.Offset(, 1).Value2 & ""
dPath = r.Offset(, 2).Value2 & ""
sFN = Dir(sPath & "*" &...
ok, in this case I change (*.jpeg) to (*.jpg)
Please reload the file and test it again!
http://www.mediafire.com/download/qcinnzzghh2jz9a/picture.xlsm
regards
Please check that you have D:photo1001.jpeg and not D:photo1001.jpg
This is what I can figure as error! or to be sure rename one of the file to aaa.jpeg and enter aaa in A2 for example.
@poojavasti, Please download this file and remember to enable macro before you can try to test it.
Let me know if it did not work! (I use excel 2007)
http://www.mediafire.com/download/qcinnzzghh2jz9a/picture.xlsm
Please try this code I dont know how to work in inch!!...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Application.Intersect(Range("A:A"), Target.Cells(1, 1))
If isect Is Nothing Then Exit Sub
GetPicture isect
End Sub
Sub GetPicture(r As Range)
Dim...