Sheet1
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 17 articles for 0.294 sec
> > In A2: =IF(Sheet1!B2="x",ROW(),"") That's the criteria col, returns arb row nums for source rows satisfying the criteria > > In B2: > > =IF(ROWS($1:1)>COUNT(A:A),"",INDEX(Sheet1!A:A,SMALL(A:A,ROWS($1:1)))) Above is the extract and float-up results. SMALL(A:A,ROWS($1:1)) returns the smallest arb row num from the criteria col, and as it is copied down it'll return the 2nd smallest, and     

Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: Max
Date: Jun 7, 2010 22:59

I am trying to find a way to generate GUIDs, which I've found, but I need to ensure they are truly unique. Here is the script that generates the GUIDs Sub GenerateGUID() Dim c As Long, r As Range c = 1 Set r = Range("a2") Do Until r.Cells(c, 1) = "" Dim strGUID As String Set TypeLib = CreateObject("Scriptlet.TypeLib") strGUID = Left(TypeLib.GUID, 38)
Show full article (0.92Kb)
Excel 2003 Sheet1 has one column with 904 records (alphanumeric) Sheet2 has one column with 1069 records (alphanumeric) Both fields have same format (17 characters) I need a code to read each record in sheet 1, then go to sheet 2 and read the records, if the record is found then copy the record from sheet2 and paste it in sheet1 next to the record. Do the same with all records in sheet2     

Group: microsoft.public.excel · Group Profile · Search for Sheet1 in microsoft.public.excel
Author: christopher wooley
Date: May 31, 2010 21:34

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula recalculate every time you open the file or do most things in Excel. -- Regards Dave Hawley www.ozgrid.com <test@testnospam.nl> wrote in message news:gs6pu5t907u8i8j09b726repetts6gc621@4ax.com... I've got this workbook with several worksheets. If I open this workbook and close it, the question if I want
Show full article (2.06Kb)
I have a similar situation as George, but I want the user to be able to open multiple worksheets and have all the rest of the worksheets remain hidden. The code I currently have only has worksheet1 visible and prompts for a username and password. If they enter the correct username/password, it will unhide one worksheet, but not multiple sheets. If the enter an incorrect username/password     

Group: microsoft.public.excel.newusers · Group Profile · Search for Sheet1 in microsoft.public.excel.newusers
Author: sebastico
Date: May 14, 2010 03:49

Demin, Would something like the following suffice (where f2 represents col b):? libname have excel "k:\art\rangetest.xls"; data want; set have."sheet1$"n (keep=f2); run; HTH, Art ------------- On May 13, 5:51 pm, demin <qdmi...@gmail.com> wrote: Hi, Can we specify one column when importing excel file? I've tried: proc import...   range="sheetname$B1:B516"; ... run
Show full article (0.39Kb)
I've got this workbook with several worksheets. If I open this workbook and close it, the question if I want to save the changes is asked every time. Even if I didn't make any changes. I think there could be 2 reasons for this dialogue window. 1- I don't close the file with the same worksheet in the front. If the file is opened with sheet2 in front when I open it, and look at sheet1, and     

Group: microsoft.public.excel.newusers · Group Profile · Search for Sheet1 in microsoft.public.excel.newusers
Author: ozgrid.com
Date: May 13, 2010 19:51

Bob Umlas, Excel MVP;953424 Wrote: Certainly not by hovering the mouse over the cell, but you can set up a worksheet_change event to bring up the formatting (and maybe set a ceertain cell to turn this "feature" off), something like this (on the sheet-code): Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next Dim rg As Range If Range("A1"
Show full article (1.36Kb) · Show article thread
Yes, that is possible. But you have to provide more detail about what you want. You say that you will be entering data into ONE cell in sheet1. Will that always be the same cell? If so, what cell? Then you say you want this data to be "accumulated" in sheet2. Exactly how do you want this data placed in sheet2? Where in sheet2 (column/row)? What about the next entry you make in sheet1     

Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: Sheri
Date: May 13, 2010 19:25

Hi, yes you can for example in the cell you want the consolidation ='[your file name.xlsm]sheet1'!$G$11+'[your 2nd file name .xlsx]sheet1'!$T$5 to make it easier enter = in you cell and with all the other sheets open start going to that sheets and clicking in the cell you want to pull the information from "MaryfromHartford" wrote: Hello all, I want to pull cells from 10 Excel
Show full article (2.08Kb)
    

Group: comp.softsys.sas · Group Profile · Search for Sheet1 in comp.softsys.sas
Author: Arthur Tabachneck
Date: May 13, 2010 18:55

Show full article (0.52Kb) · Show article thread
    

Group: microsoft.public.excel.newusers · Group Profile · Search for Sheet1 in microsoft.public.excel.newusers
Author: test
Date: May 13, 2010 17:57

Show full article (1.03Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: bala_vb
Date: May 13, 2010 12:45

Show full article (1.75Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: Otto Moehrbach
Date: May 13, 2010 12:25

Show full article (0.88Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Sheet1 in microsoft.public.excel.misc
Author: Eduardo
Date: May 13, 2010 09:56

Show full article (0.55Kb) · Show article thread
1 · 2 · next