If you could provide us a sample file (spreadsheet) with the sample
data that would be great to help you
Maddy
ma10ku...@gmail.com
On Feb 22, 6:50 pm, Sudha wrote:
> Hi All,
>
> I need to create balance sheet from trial balance. Though I know the
> logic of doing it, I am dazed by the task
I continued my search after I posted this and came across code that
'shelled out' to what I assume is a callable Windows app:
BrowseForFolders(). Works well, but you can only navigate below your
starting point on the tree, so it pays to start at the top.
Unless someone has a better idea, I'll co
I figured out my error with my previous post! But I'm trying to do is
this:
On one sheet ("Summary of Alternatives"), Cell G37 is a number by
which I will unhide a set of 2 sheets at a time. The first of these
two sheets will always start with "PerformanceAlt" and the second of
the two will alwa
Hi All, I need help!! I've written this code to unhide a certain
number of sheets based on the value of "Sheet 15" G37. All the sheet
names I want to unhide begin with "Performance - Alt" so I was trying
to use this...
It seems there's some problem with the code below (see asterisks near
the bot
Chris,
Thanks a lot. I would've spent weeks (not to say months) to figure
this out.
Tks again,
Art.
On Feb 21, 12:11 pm, Chris Spicer wrote:
> Hi Art,
>
> Contract codes are always a pain. The following functions generate
> the previous n codes:
>
> Option Explicit
>
> Private MonthCodes() As
updated your code below please try that
Application.Calculation = xlCalculationManual
With Worksheets("PivotTable2").PivotTables(1)
For i = 1 To 6
For x = 1 To .PivotFields(i).PivotItems.Count
.PivotFields(i).PivotItems(x).Visible = True
Next
Hi,
Instead of giving drive name (o: or a:) try giving only server name like
\\servername\dirnam1\rnam5\filename
let me know if that helps
On Thu, Feb 19, 2009 at 12:37 AM, BookerT wrote:
>
> Operating system is Windows XP with MS Office 2007. We have numerous
> Excel
> workbooks with multip
Hello
I tried to do this stuff on SAS but without much success so ... And of
course i am a total newbie to VBA ...
Here is my problem :
I need to merge 2 datasets without any common identifier except the
name of the company
Of course in both datasets the names can be writtent differently,
misspel
here is the solution
Private Sub BrowseToDir()
'Declare variables
Dim strOriginalPath As String
Dim x As Variant
Dim strSelectedPath As String
'Remember oroginal path
strOriginalPath = CurDir
'Show dialog and let user browse to a directory
x = Application.GetSaveAsFilename(In
goto vb editor window->tools->reference then add all microsoft object
library
On Fri, Feb 20, 2009 at 5:42 PM, radek lustyk wrote:
> Hello Harmeet
>
> This code has stopped on this 3 lines, maybe this is some library issue ?
>
>>
>>"* Dim ClipBoard As DataObject 'Data object for getting text
When u select the filtered data press (alt+;) and then copy it..
On Thu, Feb 19, 2009 at 11:46 AM, Lavprasad Kori wrote:
>
> Hi Ajay,
>
> This is Lavprasad. The horizontal filter is very good. But I want to know
> that when I copy the data filtered data then hidden data is also coppied.
> F
Would be easier to help if you can provide the file on which you are trying
this macro
On Sat, Feb 21, 2009 at 11:04 PM, Carlita wrote:
>
> i would like to create a loop (do while) in order to copy paste
> different name from a list box and write it on a database on different
> rows. (one name fo
Hi Savio,
Supposing you have the date in cell A1, type the following in cell B1.
=IF(AND(A1>NOW(),A1 wrote:
>
> is there any way to have a cell in excel update itself every week to
> show the first day of the week?
> say the week starts on a monday, the cell displays 23/02/09, retains
> this val
Tum apna dimag ma use karna ...sab hum hi kar le . h r u prabaht
Nitesh
On Wed, Feb 18, 2009 at 11:03 PM, prabhat.shrivasta...@gmail.com <
prabhat.shrivasta...@gmail.com> wrote:
>
> Dear All,
> I want to know the formula to which retrieve multiple data from single
> column.
>
> 1 a
> 2 b
> 1
Very nice my dear friendreally this is awesome
Thanks a ton for this
*Unfeigned Regards
Manoj S Negi *
*"Miles & miles to go before I sleep"*
*¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·
Pranab,
Thanks a Ton !!
Rgds /Sabrinathan
On Mon, Feb 23, 2009 at 12:59 PM, b.pranab wrote:
> Dear All,
>
> Best formula file ever seen,
>
> Wregards,
> Pranab.
>
> >
>
--~--~-~--~~~---~--~~
--
Hi Dear,
There is some problem with the Excel File Giving error that Data may have
been lost.
Can you send tht file again.
Thanks
Mayank
On Mon, Feb 23, 2009 at 12:59 PM, b.pranab wrote:
> Dear All,
>
> Best formula file ever seen,
>
> Wregards,
> Pranab.
>
>
> >
>
--
Regards
Mayank Patel
IT
Hi Savio,
Little update on this. Try following if you want the date to automatically
change:-
=IF(TEXT(TODAY(),"ddd")="Mon",TODAY(),IF(TEXT(TODAY(),"ddd")="sun",TODAY()-6,IF(TEXT(TODAY(),"ddd")="sat",TODAY()-5,IF(TEXT(TODAY(),"ddd")="Fri",TODAY()-4,IF(TEXT(TODAY(),"ddd")="thu",TODAY()-3,IF(TEXT(
18 matches
Mail list logo
