Dear Sir ,
Thank a lot :)
Regards
abhishek
On Sat, May 26, 2012 at 1:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
Hi,
Excel don’t have inbuilt Horizontal Filter Feature
Hope it will help See the Post here :
** **
Thanks Rajan,
I am seeing a runtime error while selecting the range for the
rngOutput..Could you please advice on this.I have selected range from
A1:C14
*Set rngOutput = Application.InputBox(Please select Output Cells, , , , ,
, , 8)*
Cheers,
Prabhakar
On Wed, May 16, 2012 at 6:23 PM,
Thanks Buddy..I got...
Cheers,
Prabhakar
On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Only select one cell For Output
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
Hi ,
I am not able to understand this part, could you please explain.
rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value =
rngCell.Value
rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value =
rngCell.Value
cheers,
Prabhakar
On Sat, May 26, 2012 at 2:41 PM, rao
These lines is just to adjust values within cells
If Target Cell is rngOutput.Offset(lngLoopCounter) then
rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value =
rngCell.Value Put the value in TopLeft cell Target Cell
rngOutput.Offset(lngLoopCounter).Offset(1,
Hi all,
Please find the attached query..Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
Try the below condition and see the attached sheet.
=SUMPRODUCT(($K$2:$K$48=E5)*($L$2:$L$48=$F$4)*($P$2:$P$48))
Ashish
On Sat, May 26, 2012 at 4:14 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi all,
Please find the attached query..Thanks
--
FORUM RULES (986+ members already BANNED
Use this in F5 and Drag
=VLOOKUP(F$4,INDIRECT(LMATCH(E5,K:K,0) :P COUNTA(P:P)+1),5,0)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 26 May 2012 4:15
To:
Hi Rajan/ashish..
Its working Fine thankyu so much..
On Sat, May 26, 2012 at 4:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Use this in F5 and Drag
** **
=VLOOKUP(F$4,INDIRECT(LMATCH(E5,K:K,0) :P COUNTA(P:P)+1),5,0)
* *
*Regards*
*Rajan verma*
*+91 7838100659
Hi Rajan,
Thanks for quick reply
Some part of work is done. Still problems remain same like -- In splitted
files if you check validation is not working, If you check in main
file range G:i there is validation and values comes from validation sheet.
I want same validation in splitted workbooks,
In the future PLEASE try to use a meaningful subject line (doubt is not
meaningful) and then explain your problem in the posting as well as in the
attached file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, May 26, 2012 5:44 AM
Hi Prajakt
First, I worked up that the volume was the weight divided by the rows.
Then i worked out that a box 60x40x20 would have a volume of 0.0480
So the sides need to be 60/40/20 adjusted for the change in volume.
The adjustment is according to the cube root of the ratio change so it
is the
Hi Amol
I have sometimes solved problems like this, by, rather than copying
part of the workbook, copying the whole workbook and then deleting the
parts i did not want in the copy. I do not know if this approach
would work for you.
Regards
David grugeon
On 26/05/2012, Amol Jadhav
Dear David,
Thank you very much, really good work.
Thanks Regards,
Prajakt Pande
+971551388482
**
skype:- prajaktpande
On Sat, May 26, 2012 at 4:22 PM, David Grugeon da...@grugeon.com.au wrote:
Hi Prajakt
First, I worked up that the volume was the weight divided by the rows.
Then i
Hi David,
I was doing the same thing for last 3 months, but few days before I got
macro from this group itself which save my lot time.
Actully I have team of 60 members so its very difficult to distribute work
and collate it back.
Regards,
Amol
On 26 May 2012 18:01, David Grugeon
see if it helps
Private Sub CommandButton2_Click()
Dim rng As Range
Dim i, j, c As Long
Dim wb As Workbook, srwb As Workbook
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set wb = ThisWorkbook
Set rng = wb.Sheets(1).Range(F1:F
Hi Don,
I apologies,next time onwards i will try to use meaningful subject
line..Thanks Don
On Sat, May 26, 2012 at 5:49 PM, dguillett1 dguille...@gmail.com wrote:
In the future PLEASE try to use a meaningful subject line (doubt is not
meaningful) and then explain your problem in the
Thanks Rajan for your prompt reply.
On Sat, May 26, 2012 at 2:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
These lines is just to adjust values within cells
** **
If Target Cell is rngOutput.Offset(lngLoopCounter) then
rngOutput.Offset(lngLoopCounter).Offset(-1,
Dear Rajan
Thanks for the replyand...sorry for the delayed comment from me
ok. I agree that you know intloop MUCH better than I do
However your program is NOT working on my sp sheet
The VBA starts copying OVER sheets with existing data and that is a problem
for me
regards
Subu
Dear Friends,
Please help me with a formula or any other solution. I wants to remove the old
keep only latest dated data from the attached sample file.
The file contains history of cabs going for PM service to WS on particular
days. I wants to get when the last time it visited WS. As of now I
Hi Subu
Deal with item 2 first. On your master sheet put the following
formula into cell B11. This will show the current sheetname even if
it is changed.
=MID(CELL(Filename,A1),FIND(],CELL(Filename,A1))+1,255)
Now, To copy the content of the blank sheets use the following (i
assume that the
hello Group
I am creating a table where people have to respond to questions in Yes, No,
N/A. there are nearly 3K question
I want that all the questions to be answered even in case of following
circumstances
-if someone skips any question the Cell should contain N/A by default.
-if someone
22 matches
Mail list logo