Log data in a shared workbook

Hi all 

Is it possible to have a spreadsheet which logs data from anothe
without over writing each other's data, even though several colleague
are inputting and saving in this shared sheet at different times. 

Eg. 
Sheet 1 has various data 

Sheet 2 - A1,2,3, etc = first save 
Sheet 3 - B1,2,3, etc = second save 
Etc. 

...for the day


Cheers
Joe

--
Message posted from http://www.ExcelForum.com

0
6/16/2004 1:35:05 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
729 Views

Similar Articles

[PageSpeed] 12

Joey

Would you consider writing to a CSV file?  You could use VBA's text file
functions to write directly to the file, but the file would still open in
Excel.  One advantage would be that the time that each user had the file
open would be very minimal.  Post back if that sounds like a workable
solution and you need help with the VBA.

-- 
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Joey >" <<Joey.17y44f@excelforum-nospam.com> wrote in message
news:Joey.17y44f@excelforum-nospam.com...
> Hi all
>
> Is it possible to have a spreadsheet which logs data from another
> without over writing each other's data, even though several colleagues
> are inputting and saving in this shared sheet at different times.
>
> Eg.
> Sheet 1 has various data
>
> Sheet 2 - A1,2,3, etc = first save
> Sheet 3 - B1,2,3, etc = second save
> Etc.
>
> ..for the day
>
>
> Cheers
> Joey
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
dickk (90)
6/18/2004 1:05:35 PM
Reply:

Similar Artilces:

Unable to log into my Outlook mail
I can log into my win2k domain, but when I open my outlook I get prompted for username, password,and domain. When I enter the correct info, the system replies that it's incorrect. I have tried changing passwords and many other fixes, including uninstalling and reinstalling office and still can't get it to work. I can log into outlook and my account from a different computer, but not from mine. Scanned my computer with Norton NAV. On the client side, using Outlook 2002, with winXP sp1, office 2002 sp1 & 2. On the server side, using echange 2000 with sp 3, windows 2000 ser...

Formatting Imported Data
Hi, I want to be able to read in a single column of data from either an Excel file or from a column of a word document and then produce the same column of data so that each entry has two cells separating them. So that the column 1 2 3 would look like 1 empty cell empty cell 2 empty cell empty cell 3 I there a straightforward way I can do this in Excel w/o having to use some type of additional program (like VBA)? TIA, Matt Nothing straightforward that I can see. Without some manual arranging which would be onerous, you will be better off to use a VBA macro. Sub InsertRows22() Appli...

Online Log Size
I've got a 40G SS 2005 table without indexes that I need to add a clustered index to. I know that if I do a standard index addition, it will write out about 40G to the log and I was hoping to avoid that. If do the ONLINE option for building this clustered index, will it write out significantly less to the log by any chance? Nope - but, you can try changing the recovery model to BULK-LOGGED and seeing if that reduces the amount of data recorded in the transaction log. Remember to change the recovery model back to full after the index has been rebuilt. Note: the transact...

Can not enter data after the check box are checked.
I am working in Microsoft word 2007 and have developed a form that users fill in. I used the option Developer to create the form. I have check boxes in the form and when a user put an x in any of these boxes the fields that I have where they can type in data will not let them enter any data - if I do NOT check any of the boxes I can enter the data into these fields, got any suggestions? This form has been protected from users to edit the form, other than just entering data into the fields. Thanks The documnet needs to be protected for Filling in Forms; are you using Text Input...

Circular Logging
Can circular logging in Exchange 2003 really free up 20 GB of hard disk space? I enabled it and I was amazed to see my free space five-fold. yip, not necessarily 20mb but just make sure u backup the transaction logs, u will need when u do a restore of your database. "Josh" <Josh@puzzled.com> wrote in message news:26a701c4aada$a7d2f7b0$a501280a@phx.gbl... > Can circular logging in Exchange 2003 really free up 20 GB > of hard disk space? I enabled it and I was amazed to see > my free space five-fold. Josh wrote: > Can circular logging in Exchange 2003 r...

How to reference workbook name in hyperlink formula?
In order to simplify the maintenance of workbook formulas I need to reference workbook name in hyperlink formula =[myWorkbok.xls]mySheet!$E4 in this way =[A1]mySheet!$E4 given the file name stored in cell A1 Cell A1 : myWorkbook How do I write the formula to make it work? Will it work even if the referenced workbook is closed? Regards Frank Krogh The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm ...

I can't save data on Microsoft Money 2004 running on Vista 64bit
In microsoft.public.money, Ian wrote: It won't do any good, but I'll try to remember to add this to the umpmfaq... "Cal Learner-- MVP" <via_newsgroup@please.tnx> wrote in message news:6d0nv4dpq7t24u67ng3rcps4f0b2j322da@4ax.com... > In microsoft.public.money, Ian wrote: ...

RMS 2.0 Data Dictionary
Hi, Does anyone know of a data dictionary or document that lists the changes between RMS 1.31 and RMS 2.0? I have a third party software and I want to make sure that when I upgrade to 2.0 it still works and that RMS 2.0 will still work. They have asked for the changes but I haven't been able to find any documentation. Any ideas? Thanks, Laura Hi Laura, Here's a site you can go to that gives you information on v 2.0 in a "what's new" format.... http://www.microsoft.com/dynamics/rms/product/20.mspx If your third party software works with store ops manager, you ...

log events in the event log
I want to be able to track when a user connects to their mailbox. I have someone who is trying to connect to other mailboxes and I want this to be log in the event log. I would like to show the user name and the mailbox they tried to connect to in the same event. Is there a way to do this? Thanks in advance for your help... Question for you...Does this person who is attempting to connect to the mailboxes have full exchange administrator rights on the Exchange Org? If so, you may want to refer to a previous post as this same question was asked and then answered. Jermaine "faf19...

Diagnostics Logging
Some email to some domains can't be delivered showing as "The connection was dropped by the remote host" What type of logging should I enable to troubleshoot this? THanks also, where does it log too be default? "James" <fake@email.com> wrote in message news:uxUhWt9eEHA.1652@TK2MSFTNGP09.phx.gbl... > Some email to some domains can't be delivered > showing as "The connection was dropped by the remote host" > > What type of logging should I enable to troubleshoot this? > > THanks > > ...

organizing data on the fly to access certain infomation
I have different fields in my columns i.e. name, date, time. I need to find like names and place them together, or, like dates and place them together while keeping my rows intact. I need to be able to organize this information when ever I want and however I choose according to the different fields with out compromising the integraty of the rows. Take a look at Data > Filter > AutoFilter........... Vaya con Dios, Chuck, CABGx3 "10john01" wrote: > I have different fields in my columns i.e. name, date, time. I need to find > like names and place them togeth...

Access Data in Excel Cell
I have a customer who has extensive reports build in Excel. Many of the report pull data from other spreadsheets, but ultimates somewhere the data is manually input. My task is to automate the input of the data. Is there a way to enter a formula into a cell that goes off to an Access database and gets either a value from a record/field combination, or that runs some code that generates a value? I know I can do this will code outside of the spreedsheet that will get the data out of Access and write to a cell in the spreadsheet. But I'd like to find a way that the user can continue ...

Retrieving data from Exchange Server #2
I have recieved this message: "Retrieving data from Exchange Server - and if I cancel the message I fail to connect to Calendar or my Inbox. The message appears sporadically as most times I can switch between Calendar and Inbox . The Outlook get stuck until I close the Outlook. Some one know how can I disable this message? This message indicates that Outlook senses slowness in Exchange response and can almost literally be caused by anything from Outlook to the Exchange Server and anything in between. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backup...

"Data Access Page" is not available in 2007, How to solve the internal network user's visit to the ACCESS ?
Dear all, According to the previous discussion I posted in this group, I understand that ACCESS 2007 do not have the "Data Access Page" functionality. I want to know in ACCESS 2007, how can my collegues, using the internal network, can visit and input data in my ACCESS document ? ( In ACCESS 2003, I use "Data Access Page" to let my collegues use my ACCESS document. ) Thanks. Martin Martin, The first thing that comes to mind is Sharepoint... http://sharepoint2007.microsoft.com/Pages/Default.aspx -- Gina Whipp 2010 Microsoft MVP (Access...

Problem with log in to Vista
I've got a problem with my Vista (Home Premium) I tried to log in in the morning and this problem occured - all of my desktop icons (same goes to wallpaper) vanished, my Windows taskbar won't open and I can only browse my computer through one explorer window that popped out during a log in (I can browse all the areas/hdd's of my pc) I scanned my OS with AVG antivir but the problem still occurs. It's been 8 months since I install the system (and i've got all the updates) and I never had a problem like this before. What is it? Is it a virus or any other piece of m...

creating a log sheet
Hi all, I've created a method to capture current user (network username) and a date / time stamp. I want this output to be logged on a hidden sheet called 'log' strangely enough! How does it find the next available line in log to output to? tia see if this will help you. you didn't give too specific of a description, so hopefully this is what you're looking for lastRow = Worksheets("log").Cells(Rows.Count, "A").End(xlUp).Row range("A: & lastrow +1) = "your date/time stamp code" -- Gary "sacrum" <sacrum...

shared between two companies
Hi all, we are going to merge with another company. If we do a forest trust between us, can we share PB, free/busy and calendar each other? (Windows 2003 domain functional level both company. we have exchnage 2003 sp2 and they have exchange 2007) thank you. On Sat, 15 May 2010 09:01:01 -0700, ed <ed@discussions.microsoft.com> wrote: >we are going to merge with another company. If we do a forest trust >between us, can we share PB, free/busy and calendar each other? (Windows 2003 >domain functional level both company. we have exchnage 2003 sp2 and they ha...

X Axis Data
im trying to produce a line graph, with data showing year and rainfall amounts, but when i create the graph its not showing the year in the x axis its just labels them 1,2,3 etc and not 1985, 1990 etc why is this Make sure your data has year in one column and rainfall in the next. Select both columns of data when you create an XY Scatter chart (not a Line chart). Excel will use the first column for the X data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RJ831JK wrote: > im trying to produce a ...

How to log internet header of incoming emails?
Hello, I want to log internet header of incoming emails. I want to see the content of the Bcc field. Is it possible? And if yes, how and where I have to config the log settings in exchange server? We use exchange 2000. Thanks. Regards Christian You can create a rudimentary log of incoming mail using the SMTP protocol logging feature of the SMTP virtual server. It will not record the BCC field or any of the message content, though. The BCC field would be inside the RFC 2822 header of the message. To record anything in that you would need an SMTP protocol sink. The Archive sink mig...

OWA, log in to .. log out?
hi Exch 2k3 1 FE server no forms based auth here(yet) This weekend I put a FE server out and put a SSL cerfiticate on it. The name in the certificate is not the same as the server, however our internet facing DNS has an A record for it with the name that is used in the certificate. after the migration I have a small number of users, about 10 out of 1000 that when using OWA get asked to enter credentials when they click "log off". why? Also, because i think its maybe related. This FE server is physically inside our network behind a pix. One thing I wanted to achieve but...

Workbook sharing
Problem starts with switch on Workbook sharing in Excel (Tools->Share Workbook). With this file are working about 9 users at the same time and file is about 2 MB. Everobody opens file and makes changes then save and close Excel. Another opening sometime by somebody generates these message :"EXCEL.exe generated error and will be closed by Windows system. Program must be restart.ed." and Excel shut down. Another user see in window Workbook sharing (Tools->Share Workbook) that user is connected but it´s not true. First user no more can open shared Excel workbook. Shar...

How to find out if a user has logged on ?
Hi: Within a Windows Service, is there a way to find out if a user (any user) has already logged on to the machine ? Thanks In Advance ! Polaris You can use NetWkstaGetInfo with a level of 102 to get the number of logged on users. And NetWkstaUserGetInfo will give you information about the logged in user. AliR. "Polaris" <etpolaris@hotmail.com> wrote in message news:%23pmkzBWYFHA.3320@TK2MSFTNGP12.phx.gbl... > Hi: > > Within a Windows Service, is there a way to find out if a user (any user) > has already logged on to the machine ? > > Thanks In Advanc...

Copy Data
Good day; First of all, I would like to thank you. You helped so many times. Example;;; Sheet-1, Cell A1 = Milk Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],? The word (Milk) will appear'! hi not entirely sure what you mean but see if this is what you want... on sheet 2 cell B1, enter =sheet1!A1 what ever is in cell A1 on sheet 1 will appear in Cell B1 on sheet 2 Regards FSt1 "Khalid A. Al-Otaibi" wrote: > Good day; > > First of all, I would like to thank you. You helped so many times. > > Example;;; > >...

Sharing
Is it possible to share an excel worksheet - have two users make corrections at the same time? XL 2003. Tools | Share Workbook, The owner of the sheet (who shared it) will be asked when the other(s) make changes on the same cell hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Bianca" escreveu: > Is it possible to share an excel worksheet - have two users make corrections > at the same time? ...

log-log charts
can't create log-log chart in excel 2000. There is a selection under format axis to choose log scale for the Y- axis but there is no selection for choosing log scale for the x-axis. can anyone help? Hi CT, You need to plot a xy-scatter in order to have log scale on the x axis. Sounds like you are using the line chart type. Where the x axis is a category axis. Cheers Andy CT wrote: > can't create log-log chart in excel 2000. There is a > selection under format axis to choose log scale for the Y- > axis but there is no selection for choosing log scale for > the x-...