I apologize for insufficient info. I am starting from scratch, but I
don't see the option for file upload (where can I upload it?) so I'll
try and explain in more detail.
My source workbook contains info on several subprojects. From here I
need 3 items to be copied:
- project number (always locat
See the attached file, does it make sense..
regards,
Mrinal Saha
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> Dear All,
>
> Please help me on the following;
>
> 1) I have created several pivot tables & want to update the data source
> range for all the pivot tables all together.
Hi,
See below if helps...
*Replace "0" to"-" =IF(A1=0,"-",A1)*
*
**Replace "-" to"0"=**IF(A1="-","0",A1)**
*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> Dear All,
>
> Please help me on the following;
>
> 1) I have created several pivot t
Dear All,
Please help me on the following;
1) I have created several pivot tables & want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
2) I have few work sheets where in I get the dat
Hi Dave,
Please ...Attach that workbook..
*Best Regards,*
*Venkat *
*Chennai*
On Thu, Aug 11, 2011 at 2:51 AM, DaveO wrote:
> Did a search but got no hits.
>
> I created a file in xl 2003 that included a button with some code
> attached. I imported that file into xl 2010 and the button flashes
Hi DH,
Please attach some sample data sheet...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson <
donovan.hender...@gmail.com> wrote:
> Good Day, Your Assistance needed:-
>
> I have a spreadsheet showing the time of day particular categories of crime
>
Did a search but got no hits.
I created a file in xl 2003 that included a button with some code
attached. I imported that file into xl 2010 and the button flashes on
and off quickly with no pattern. The code attached to the button still
runs; when I right click the button to assign properties it s
Good Day, Your Assistance needed:-
I have a spreadsheet showing the time of day particular categories of crime
takes place over a month. I need to now show a crime band chart (ie. the
time of day with the most frequent occurring crime categories) break ins /
Auto theft / Robbery. My time band is a
Hi Rajan,
It is not considering the country in any sheet while filtering the data.
Rest of the macro is fine and is working properly as I want.
On Wed, Aug 10, 2011 at 8:15 PM, Rajan_Verma wrote:
> *Please Ignore Previous Mail.. *
>
> *See if it helps*
>
> * *
>
> *Option Base 1*
>
> * *
>
>
Hey James,
try this code for remove
Sub RemoveAllCode()
On Error Resume Next
'Make reference to Extensibilty Library
ThisWorkbook.VBProject.References.AddFromGuid _
"{0002E157---C000-0046}", 4, 0
On Error GoTo 0
Dim VBComp As Object, AllComp As Object, ThisProj As Object
Dim T
I now understand what you need. Have you gotten a satisfactory result yet?
From: Rajan_Verma
Sent: Wednesday, August 10, 2011 9:45 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Macro copy filter data in a new sheet
Please Ignore Previous Mail..
See if it helps
Option
To remove macros simply save as .xlsX
From: ja...@macstop.co.uk
Sent: Wednesday, August 10, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ PasteSpecial
thanks - it's a long story but basically I'm trying to export some sheets from
a workbook with loads of code beh
Or with col 8 formatted as desired place this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 7 Then Exit Sub
If UCase(Target) = "DONE" Then Target.Offset(, 1) = Date
End Sub
-Original Message-
From: XLS S
Sent: Wednesday, A
or
Sheet1.Range("f2").Value=Sheet1.Range("f2").Value + 1
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 3:10 PM
To: excel-macros@googlegroups.com
Cc: John A. Smith
Subject: Re: $$Excel-Macros$$ Add 1 to a cell every time the file is opened
Hey Johnasmith,
Please find
Itappears that this is only partially done. You need a worksheet_change
event macro tied to the dropdown cell to do the rest. How do you want the
list of cities displayed?
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 4:00 PM
To: excel-macros@googlegroups.com
Subjec
Hey Naresh,
Please find the attachment.
On Wed, Aug 10, 2011 at 4:51 PM, naresh v wrote:
> Hello experts,
>
> Let us assume in the particular cell i want a dropdown like "south" or
> "north".
> I will select anyone of it.If I select "south" In the next cell it
> should show the "AP",
Hey Johnasmith,
Please find the attachment...
Code...
Private Sub Workbook_Open()
dt = Sheet1.Range("f2").Value
Sheet1.Range("f2").Value = dt + 1
End Sub
On Thu, Aug 11, 2011 at 1:24 AM, John A. Smith wrote:
> Excel guru's, can I make a receipt file that adds 1 to a specific cell
Excel guru's, can I make a receipt file that adds 1 to a specific cell
everytime the file is opened?
Please see attached.
Thank you.
John
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hello Naresh,
See the attached. You can Add/Delete New/Old entries.
HTH
Haseeb
For free help, visit,
http://www.excelfox.com/forum/forum.php
--
--
Some important links for excel users:
1. Follow us on TWITTER fo
thanks - it's a long story but basically I'm trying to export some sheets
from a workbook with loads of code behind it. I wanted to use move/copy
originally but it takes the vba behind the sheets with it. (Which I don't
want).
So I wrote a function that just deleted all vba code in the workbook
Hey James,
If you want copy all cell ..then ..Just use Sheet copy and move
option then use paste special value function (Alt +E +M)
On Wed, Aug 10, 2011 at 11:29 PM, ja...@macstop.co.uk
wrote:
> Hi,
>
> This is driving me crazy, can someone help!
>
> I have a nice pretty worksheet, all coloure
don't worry, I worked it out using 2 lines of code, pastespecial values then
formats - would be nice to do it in one but I'm not that fussed... For some
reason I had convinced myself doing it a second time would wipe out the
number
--
---
Great and very easy Option James
On Wed, Aug 10, 2011 at 11:46 PM, ja...@macstop.co.uk
wrote:
> what happens if you just rename the .txt file to .csv and open in Excel...
>
> --
> --
> Some important links for excel
Hi,
Do you have any code so far that I can help you with or are you starting
from scratch?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldai
what happens if you just rename the .txt file to .csv and open in Excel...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi,
This is driving me crazy, can someone help!
I have a nice pretty worksheet, all coloured in and stuff - all I want
to do is select all the cells and copy - then paste into a new
workbook.
I can do all of this, but it seems when using pastespecial I have to
select values (because these cells
Post a file with a more complete explanation
-Original Message-
From: Seba
Sent: Wednesday, August 10, 2011 9:36 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ copy selected range to target with params
hi,
I need help with writing a macro which would copy selected range and
Better option try press Ctrl + O then Select File type "All Files"
then select ur notepad file...
link
http://www.cpearson.com/excel/ImpText.aspx
On Wed, Aug 10, 2011 at 11:38 PM, Raghavendra wrote:
> Hi,
>
> I have data (numbers) in note pad, Around 1,000,000 line items. Can I
>
Hey Sundaryelan,
Please find the attachment
.
On Wed, Aug 10, 2011 at 10:22 AM, Sundarvelan N wrote:
> Hi Friends,
>
> Please refer the attached image. Please help on this scenatio.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> --
Hi,
I have data (numbers) in note pad, Around 1,000,000 line items. Can I
write a VBA code to copy data from Note pad to Excel? If yes, can
anyone advise me with Code?
Thanks and Regards,
Raghavendra
--
--
Some impo
Jai,
Read this...
Error Checking Options
The Error Checking Options button is displayed when the formula in an
Excel worksheet cell triggers an error. In addition to the button, the
cell itself is marked with a small green triangle in the upper-left
corner.
When you click the button,
Hi,
I am using a huge database of family and members, with column address /
DOB / Emp Code.
Now what I want, since the address and EmpCode is only agaisnt primary
member, so after executing command, I want that address should be filled in
each member of family alon
Dear Jai,
Please find simple solution without using Macro.
On Wed, Aug 10, 2011 at 11:39 AM, Jai wrote:
> PLEASE HELP
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks
hi,
I need help with writing a macro which would copy selected range and
prompt me for target workbook, sheet and range. It would need to copy
only values and transpose them.
any help is greatly appreciated.
Regards,
seba
--
-
Run this macro on your numbers and just use =e8+g8
Sub fixmynumsSAS()
Application.ScreenUpdating = False
'lr = Cells.SpecialCells(xlCellTypeLastCell).Row
On Error Resume Next
For Each C In Selection 'Range("a1:q" & lr)
If Trim(Len(C)) > 0 And C.HasFormula = False Then
C.NumberFormat = "
See the attached sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai
Sent: Wednesday, August 10, 2011 11:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REMOVE THE ERROR IN THIS FILE
PLEASE HELP
--
--
Hi Naresh,
Based on your query i have attached the sample file for your reference.
Regards
Prakash Paul
On Wed, Aug 10, 2011 at 4:51 PM, naresh v wrote:
> Hello experts,
>
> Let us assume in the particular cell i want a dropdown like "south" or
> "north".
> I will select anyone of it.If I sel
See if it helps
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of naresh v
Sent: Wednesday, August 10, 2011 4:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can you please help regd. lists
Hello experts,
Let us a
PLEASE HELP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3.
Hello experts,
Let us assume in the particular cell i want a dropdown like "south" or "north".
I will select anyone of it.If I select "south" In the next cell it
should show the "AP","Tamilnadu","Karnataka"
If I select "North" it should show the "Maharastra", "UP" like that
can you please help me
Notice the sheet arrow keys at the bottom left. RIGHT click one>voila
-Original Message-
From: Dsastray
Sent: Tuesday, August 09, 2011 4:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic code
found is not working.
I would like t
Attach a file
From: Sundarvelan N
Sent: Tuesday, August 09, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached image. Please help on this scenatio.
Thanks
N.Sundarvelan
9600160150
--
--
Attach a file with a better explanation and before/after examples
-Original Message-
From: AJ
Sent: Tuesday, August 09, 2011 2:20 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Locking cells based on conditions / todays date
There are dates in calendar order stored in row 4,
What you want is doable with a macro. However, your “dummy” data does not give
data for testing to see what you really want. Redo your data and give a better
explanation of what you want. This to get you started
Application.Goto Sheets(3).Range("a2")
myname = Application.InputBox("Pick a cell Th
Hi,
In below code some times I could able to send attachments but some times its
not taking attachment at all. Please let me know whats is the problem in the
below code.
Sub sendmail()
'
Dim UserName As String
Dim MailDbName As String
Dim Recipient As Variant
Dim ccRecipient As String
Dim Attachm
- Original message
From:""Bhilwara Infotech Limited""< ma...@bhilwarainfo.com >
Date: 10 Aug 11 13:15:46
Subject: Job opening with Wipro for MIS Executive
To:
For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079
46 matches
Mail list logo
