=OFFSET(AE1,MATCH(B8,AE2:AE65536,0),1,COUNTIF(AE2:AE65536,B8),1)
The offset function given by Vinay is working absolutely fine,
but once the Product changes, Specification should be refreshed.
Can this problem be solved using macros.
I am good in excel, but very bad in Macros.
I am trying to use
Perfect! Worked a charm. Thank you.
On 19 Apr, 07:20, "Ajit Navre" wrote:
> Use something like...
>
> Dim vArr As Variant
> vArr = Split(ActiveSheet.QueryTables(1).Connection, "\")
> Debug.Print vArr(UBound(vArr))
>
> Ajit
>
> -Original Message-
> From: excel-macr
I would like to know if there is any Macro which can fill my subject
line in outlook automatically e.g. Completed, MT, current date
your help will be highly appreciated..
Thanks and regards
--~--~-~--~~~---~--~~
---
Thanks Ashish
is there any other way than Macro
I appreciate ur help.
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Mayank,
>
> Try this VBA code.
> 1. Select the cells and run the code below:
> 2. Code:
> S
Hi Ronnie,
Here is your solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ash
Hi Mayank,
Try this VBA code.
1. Select the cells and run the code below:
2. Code:
Sub Divideby1000()
Dim myCell as Range
For each myCell in Selection.cells\
myCell.Value = myCell.value/1000
Next
End Sub
For more tips, tricks, downloads and problem solutions: visit -->
h
Hi Shrinivas,
Mr. Powell has rightly said, please debug the same way.
And If it helps please also check, if you have larger amount of
columns or rows than your friend, since this also cause "Subscript Out
of Range". Run on lesser or same amount of rows , also ensure correct
sheet/file names in th
Hi Ajay and Yu,
Here is the solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashish
Hi Ajay and Yu,
Here is the solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-c...
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashish **Ja
Hi Satish,
I don't know which format of XML is reqd. by your website and what
kind of manual intervention reqd. to input data else wise.
Either you can write a macro to create a custom XML file or
Go to FILE -> SAVE AS -> Save as Type XML SPREADSHEET.
For more tips, tricks, downloads and problem
Hi Vincent,
Timer is defined DateTime Class of VBA. Hope you're not over-riding
them any of them anywhere.
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashish **Jain*
Hi Vincent,
Timer is defined DateTime Class of VBA. Hope you're not over-riding
them any of them anywhere.
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashish **Jain*
Hi Satish,
I don't know which format of XML is reqd. by your website and what
kind of manual intervention reqd. to input data else wise.
Either you can write a macro to create a custom XML file or
Go to FILE -> SAVE AS -> Save as Type XML SPREADSHEET.
For more tips, tricks, downloads and probl
Hi Ajay and Yu,
Here is the solution:
http://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regards
*Ashi
Hi Mahesh,
Its simple.
Use speak method of range. Some examples for you:
i. Range("A1").speak
ii. Range("B10:E15").Speak
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Regar
Hi Steve,
If we leave the weekend part, your problem is solved.
You can use pivot table. Put work order in Row field and
Count of Dates in Data field. Problem is solved (partially).
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Hi Jake,
No, there is no way to get your function listed in that box and the
reason is that you're using code behind(VBA). This restricts your
function to be used from a workbook only where your function code is
placed. Maximumly you can add it to a personal workbook or in an add-
in but still th
Hi Ajit,
I can keep any name for the pdf file and save it anywhere as required. I
have many pdf files for picking data. From each file I take data from
different page. If I get code for one file then I can write the same code
for other files also (with some edition). Area to be taken will be diffe
TRY THIS:
Select Case Crit_Value
Case 0
Cells(25, 1).Value = "No Order"
Case Is < 0
Cells(25, 1).Value = "Error Crit_value < 0"
Case Is < Init_Inven
Cells(25, 1).Value = "No order inventory on hand>Crit value"
Order_Amt = Desire_Inven - Init_Inven
Please find below the macro recorded:
Sub Trial()
'
' Trial Macro
'
'
'
Range("A1:F16").Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R16C6").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable1", DefaultVersion:=xlPi
Attached is the file on which macro was created and used.
On Sun, Apr 19, 2009 at 2:52 PM, Ujjwal Jha wrote:
> Please find below the macro recorded:
>
> Sub Trial()
> '
> ' Trial Macro
> '
> '
> '
> Range("A1:F16").Select
> ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceDat
Hi Ujjwal,
Yes, you were able to make us understand. and the problem is Macro
recorder is not enough intelligent to create loops for us.
Now to better understand the problem, please post what you've recorded
through macro.
For more tips, tricks, downloads and problem solutions: visit -->
http://
Hi Shelly,
Here is your solution, assuming
Last Month Formula : =VLOOKUP($G20,'[ABC ltd billing data - Jan''09
Final.xls]Pivot-ST'!$B$5:$I$398,8,0)
New Formula you need : =VLOOKUP($G20,'[ABC ltd billing data - Feb''09
Final.xls]Pivot-ST'!$B$5:$I$398,8,0)
Solution:
1. Select all the data by press
23 matches
Mail list logo