Yes there is, but it seems to me that it would falsify the records.
On Jan 11, 2:57 pm, AlwaysLearing wrote:
> Hey Guys,
> I have a spreadsheet that has multiple rows of data for each employee
> with each row containing the date they worked and for how long. For
> example, Mr. Smith worked on 7/
Hi,
The syntax is:
ActiveSheet.Name = Range("Sheet1!C4")
This line renames the active sheet to whatever is in Sheet1!C4
Change the details to suit your requirements.
Regards - Dave
Date: Mon, 11 Jan 2010 18:08:49 +0530
Subject: Re: $$Excel-Macros$$ Using macro move sheets fr
Hey Guys,
I have a spreadsheet that has multiple rows of data for each employee
with each row containing the date they worked and for how long. For
example, Mr. Smith worked on 7/1/09 for 8 hrs and on 7/2/09 for 8 hrs
and 7/3/09 for 8 hrs. Is there a way to combine all 3 rows as Mr.
Smith worded
I am trying to use the Gauss/Jordan method as a subrouting in my code.
This is code that lets you put linear equations into a matrix and then
finds the values for the variables in the equations. I am concerned
that my rewrite has made the count off so I am not getting the answers
I expect. Can anyb
hi
goto
http://www.dailydoseofexcel.com/archives/2006/10/29/saveas-in-excel-2007/
hope this will help you
Regards Yngve
On 11 Jan, 07:00, grlinks-karthik wrote:
> I need to copy the sheets from one work book to another work book, can any
> one help is urgent
>
> I have to work book name call
I have a worksheet created on a Mac in Excel 2004. It has customised
tool bars with dropdown menus with macros attached. Is it possible to
make the tools bars and macros work on a PC with Excel 2007. I can
display the tool bars, the attached macros are recognised but the
address is wrong. The comma
Hi,
Do share the file on Network.
Regards
Nitin Gupta
On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote:
>
> Hi,
>
> I want some help and little bit
> challenging
>
> I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS
> AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE
> IF IT I
Hi Ramesh,
Access already allows multiple users to work on data simultaneously. You don't
have to do anything special to make this happen. The only limitation is that
only one user can make changes to the design of the database at any one time,
but as to data entry and general use, it's open t
you can use following function to get date range instead of a vlookup:
Function GetDateRange(Day1 As Date, CurrentDay As Date) As String
Dim i As Integer, LeftRange As Date, RightRange As Date
If Day1 > CurrentDay Then
DateRange = "#INVALID#"
Exit Function
End If
i = Application.Workshee
Its very simple data. For every date I want Mon-Sun for that date.
File 1: Date Week15-Jan-09 =vlookup(A2,File2,2,0) which gives #N/A
File 2:Date Week11-Jan-09 11-Jan to 17-Jan12-Jan-09 11-Jan to 17-Jan
13-Jan-09 11-Jan to 17-Jan14-Jan-09 11-Jan to 17-Jan15-Jan-09 11-Jan
Hi there
I have attached a small excel sheet called TESTTHEM which i'm testing
and learning excel simultaneously. On the attached sheet
under the type column, i have created a dropdown list with some values
in it. If i select a value from the dropdown list say for ex:
Pictures, is it possible to
use Office grove for such purpose or Sharepoint. These two products are
created for such scenarios.
Thanks & regards
Ashish Pahuja
On Mon, Jan 11, 2010 at 6:31 PM, SUMIT VYAS wrote:
> Dear
>
> Local Area Network Working Possibale
>
> Yes I try & Success
>
>
>
> On Mon, Jan 11, 2010 at 5:48 PM,
Hello, I need to alter the array of the lookup table e.g. adding a new
column to the array. I am using the lookup name. I there a way to
refresh the name so it it contain the new column . Thanks
--
--
Some important li
offcurse!!
On Mon, Jan 11, 2010 at 6:31 PM, SUMIT VYAS wrote:
> Dear
>
> Local Area Network Working Possibale
>
> Yes I try & Success
>
>
>
> On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack > wrote:
>
>> Hi Anant,
>> I don't think this is possible in XL. It is standard procedure in Access.
>>
Dear
Local Area Network Working Possibale
Yes I try & Success
On Mon, Jan 11, 2010 at 5:48 PM, Dave Bonallack
wrote:
> Hi Anant,
> I don't think this is possible in XL. It is standard procedure in Access.
> Can you use that instead?
> Regards - Dave.
>
> --
> Date
Hi dave,
I also need the said procedure in access, can you help me.
Thanks in advance.
Ramesh
--- On Mon, 1/11/10, Dave Bonallack wrote:
From: Dave Bonallack
Subject: RE: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE
LOCATION
To: "excel-macros@googlegroups.com"
Date: Monda
Does any one has macro to rename the tabs
I have list of names around 50 in one sheet and i want to rename the tab
according. sometimes i may have less also.
Thanks and Regards,
Darshan
On Mon, Jan 11, 2010 at 11:30 AM, grlinks-karthik wrote:
> I need to copy the sheets from one work book to
Try Share workbook function in Tools menu
but it is complicated as well as quit dangerous fuction
becoz unlimited user can work on same sheet at same time
u may facing problem of data loss
regards
Gaurav
On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote:
>
> Hi,
>
> I want some help and litt
Ye To Me Bhi Dhund Raha hu
Koi Help Karo Yaar !
On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote:
>
> Hi,
>
> I want some help and little bit
> challenging
>
> I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS
> AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE
> IF IT IS POSS
Hi Anant,
I don't think this is possible in XL. It is standard procedure in Access. Can
you use that instead?
Regards - Dave.
Date: Mon, 11 Jan 2010 15:29:04 +0530
Subject: $$Excel-Macros$$ HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION
From: anant.shelk...@gmail.com
To: excel-macros@google
Hi,
I want some help and little bit
challenging
I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS
AND ALL THE CHANGES MADE BY ALL USERS IT TO BE SAVE IN THAT FILE
IF IT IS POSSIBLE PLS TELL ME HOW CAN I DO IT
--
Anant Fakt Tumachyasathi
--
pls send that acrossi may give sm inputs
On Sat, Jan 9, 2010 at 12:58 AM, Mark Reuber wrote:
> I have what I believe to be a very simple solver problem, but keep
> getting the wrong answers, I can easily answer the problem myself, but
> solver doesn't come up with the same solution.
>
> Is th
you can use following code if you have to copy a text file into excel:
Sub CopyTxt()
Application.ScreenUpdating = False
Workbooks.Open "C:\a.txt"
ActiveCell.CurrentRegion.Copy
ThisWorkbook.ActiveSheet.Paste
ActiveWorkbook.Close SaveChanges:=False
Application.ScreenUpdating = True
End Sub
Another
23 matches
Mail list logo
