Dear Smitha,
Please try this. (Sheet - 1 & Sheet - 2)
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R
Hello Pascal,
Your code does not pick up the General Category Activity from Row 911 in
Original Sheet.
Please look into this.
Thanks for your effort
On Wednesday, July 25, 2012 11:42:41 PM UTC+4, bpascal123 wrote:
> Hi Anil,
>
> I have started looking at your query. I'm getting somewhere with th
Dear Smitha,
Please find the attachment..
it will help you...
Regard
Manoj
On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R wrote:
> Hi,
>
> Please help in conditional formatting or use of if formula in the
> following case. Excel attached.
>
> Closing Stock Verification stock required 1 1 if
Hi,
Please help in conditional formatting or use of if formula in the following
case. Excel attached.
Closing Stock Verification stock required 1 1 if closing
Stock=Verification Stock blue colour should be filled in cell B3 5 4 if
closing Stock>Verification Stock green colour should be fille
*Thanks don
I think link mentioned by u will be helpful to me
Govind Mori
*
On Wed, Jul 25, 2012 at 12:18 AM, dguillett1 wrote:
>
> http://appscout.pcmag.com/your-questions/274021-excel-2007-can-t-save-as-dbf
>
>
> http://www.dbforums.com/microsoft-excel/1644233-excel-2007-add-save-dbf.html
>
take it to the right side corner dude...
Regards
Gawli Anil
On Thu, Jul 26, 2012 at 10:49 AM, balbirkumar . wrote:
> Thanks for support . But my problem is the cursor does not become "+" sign
> to drag. Please suggest.
>
>
> On 26 July 2012 10:32, अनिल नारायण गवली wrote:
>
>> Drag the cursor whe
Thanks for support . But my problem is the cursor does not become "+" sign
to drag. Please suggest.
On 26 July 2012 10:32, अनिल नारायण गवली wrote:
> Drag the cursor when the cursor become "+" sign and drag.
>
> Regards,
> Gawli Anil
>
> On Wed, Jul 25, 2012 at 11:49 PM, kumar.ashish861 <
> kumar
Drag the cursor when the cursor become "+" sign and drag.
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 11:49 PM, kumar.ashish861 wrote:
> Dear Balbir,
>
> First u have to select a cell & copy it (what you want to paste), then
> select a range, including the copied cell (where u want to paste th
Dear Tony,
U can use without macro
Just select the range and press ctl+G of press F5 function key .
Then click to blank cell and use Alt+E+D select the row and delete it
Regards,
Gawli anil
On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI wrote:
> Dear Tony,
>
> Please try it..
>
> *Sub Dele
Dear Noorian,
Thanks for the precious information..
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 5:36 PM, NOORAIN ANSARI <> wrote:
> FYI
>
> -- Forwarded message --
> From: ExcelUser
> Date: Wed, Jul 25, 2012 at 5:30 PM
> Subject: Office 2013 + YOY Reporting + 5 Useful Shortc
Hi,
Please try this.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jul 26, 2012 at 9:22 AM
PFA...hope it will help you
On Wed, Jul 25, 2012 at 4:22 PM, David Grugeon wrote:
> See Attached file
>
> Regards
> David Grugeon
>
>
> On 26 July 2012 02:55, Cute Awesome wrote:
>
>>
>>
>>
>>
>>
>> pls help in providing the formula
>>
>> Inventories are due every 20 days from the day of inve
Dear Tony,
Please try it..
*Sub DeleteBlank()*
*On Error Resume Next
ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0: On Error GoTo -1: Err.Clear*
*End Sub*
On Thu, Jul 26, 2012 at 5:13 AM, Tony O wrote:
> I am working on a spreadsheet with Ex
I am working on a spreadsheet with Excel 2007.
I have the vba code to delete a line:
Selection.Delete Shift:=xlUp
I want to delete all rows that have the cells in column A that are blank
and column B and column C for just those rows.
I'm thinking that the code should look something like this,
See Attached file
Regards
David Grugeon
On 26 July 2012 02:55, Cute Awesome wrote:
>
>
>
>
>
> pls help in providing the formula
>
> Inventories are due every 20 days from the day of inventory conducted
>
> pls help by providing conditional formatting formula wherein column
> C i.e. inve
Hi Pascal
I think in the first loop Actions are merged cells and firms are not
merged. In the second one it is the other way round so you are probably
counting firms between actions rather than actions between firms.
Regards
David Grugeon
On 26 July 2012 05:42, bpascal123 wrote:
> Hi Anil,
>
Hi Anil,
I have started looking at your query. I'm getting somewhere with the code
below but if someone in this forum can me figure out why these lines are
not getting all values:
'This loop stores the number of times an activity occurs between 2 merged
cells --> need assistance,,, not accurat
Dear Balbir,
First u have to select a cell & copy it (what you want to paste), then
select a range, including the copied cell (where u want to paste the data)
the press CTRL + D
Thanks
Ashish
On Wednesday, July 25, 2012 5:45:10 PM UTC+5:30, Balbir Kumar wrote:
>
> Dear Friends,
>
>
> I am n
pls help in providing the formula
Inventories are due every 20 days from the day of inventory conducted
pls help by providing conditional formatting formula wherein column C
i.e. inventory due turn yellow after 20 days of inventory conducted
example
: inventory conducted f
hi pascal,
Thanks for explaining.It really helped me.I'm a beginner in macros so i
used to follow all experts.
On Tuesday, July 24, 2012 5:48:08 PM UTC+5:30, bpascal123 wrote:
> This forum is a great place to learn, contributors I closely follow;
> Noorain, Asa, Don...
>
> On Monday, July 23,
Dear Experts
In the attached sheet I have the formuale in A55which gives a output by
checking the A53 and A54 cells.Also I need outputs in cells A56,A57,A58 and
A59.
Please help me to get these values.
The Answers are in same row ,as the row from where the output in A55 had
come under the
Dear Experts
In the attached sheet I have the formuale in A55which gives a output by
checking the A53 and A54 cells.Also I need outputs in cells A56,A57,A58 and
A59.
Please help me to get these values.
The Answers are in same row ,as the row from where the output in A55 had
come under the
Dear Balbir,
Try this.
Copy Cell & Select Range Than Press Enter Key.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Wed, Jul 25, 2012 at 5
Dear Friends,
I am not able to drag the data from my mouse pointing in excel sheet.
Please help.
--
With
Thanks & Regards
Balbir Kumar
"*The worst thing in Life is- "ATTACHMENT” It hurts when you lose it. The
best thing in life is - “LONELINESS” because it teaches you everything and,
when yo
FYI
-- Forwarded message --
From: ExcelUser
Date: Wed, Jul 25, 2012 at 5:30 PM
Subject: Office 2013 + YOY Reporting + 5 Useful Shortcuts + Cluttered Data
To: Noorain Ansari
**
[image: Excel for Businessnewsletter]
*Published Now and Again for Business Users of Microsoft Excel
Hi guys, can anybody help me turning this If macro to an case macro.
Sub friday()
For i = 1 To 200
For j = 1 To 200
If Cells(2, j).Value = "sexta-feira" And Cells(i, 1).Value = 512 Or
Cells(2, j).Value = "sexta-feira" And Cells(i, 1).Value = 513 Or Cells(2,
j).Value = "sexta-feira" And Cells(i,
Hi Asa, just to give a feedback on this, it was very good, perfect
solution. thank you very much.
2012/7/6 Jorge Marques
> Hi Asa,
>
> Thank you very much for your help. This weekend I will analyze your
> solution, many thanks in advance for your time and support, I expect to
> give you feedbac
Even if you make manual arrangement before clicking pivot table? At my vba
coding level, it's quite a long code.
If you manually re-arrange your data (maybe using a macro) and use a pivot
table you may generate a report that will more or less look like what you
want. You can also use calculated
dear prkhan,
Share ur data with groups...
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 12:50 PM, prkhan56 <> wrote:
> Hello,
> With the present data, I cannot.
> That is what I will do when I get all the Emp details in a summary sheet.
> Now the Emp names are in columns.
> I wish to have their d
Hello,
With the present data, I cannot.
That is what I will do when I get all the Emp details in a summary sheet.
Now the Emp names are in columns.
I wish to have their details one below other so I can use it in a Pivot
Table
On Wednesday, July 25, 2012 12:53:20 AM UTC+4, bpascal123 wrote:
> Hav
30 matches
Mail list logo
