Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.


Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Toggle shoutbox Shoutbox

@ agyat	:	(24 May 2013 - 05:15 PM) O Dear, Where Are You? Without Your Words This Sb Is ..
@ agyat	:	(23 May 2013 - 01:23 AM) Wow! Mr. Sb Back Home.
@ OpaQue	:	(23 May 2013 - 12:44 AM) Ting
@ OpaQue	:	(24 April 2013 - 02:44 PM) I guess, Time to run Mycent script.
@ OpaQue	:	(24 April 2013 - 02:43 PM) wow.. not much spam. except habatt posting lot of links..
@ yordan	:	(23 April 2013 - 01:04 PM) You're welcome, agyat. Nice to have been helpful. Second lesson: try full words, "you" instead of "EW".
@ agyat	:	(23 April 2013 - 05:03 AM) @YORDAN: tHANK EW FOR YOUR FIRST LESSON.
@ yordan	:	(22 April 2013 - 09:43 PM) @agyat : "why don't you help me", or "please help me", or "please teach us"
@ yordan	:	(22 April 2013 - 09:42 PM) welcome back, velma
@ velma	:	(22 April 2013 - 07:51 AM) yawns Good to be back, wonder what is going on here
@ agyat	:	(22 April 2013 - 03:50 AM) Oh! so, why don't help me learn english..
@ yordan	:	(21 April 2013 - 08:38 PM) The goal mentioned by shiu : "learning english, learning computer"
@ agyat	:	(21 April 2013 - 06:31 PM) WHAT GOAL?
@ yordan	:	(20 April 2013 - 10:39 AM) yes, that's our goal. simultaneouly learning English and teaching/learning computer using.
@ shiyu	:	(20 April 2013 - 07:30 AM) learning english,learning computer
@ yordan	:	(19 April 2013 - 01:11 PM) Oh, I see, it's just a trick in order to force people looking at your texte. Somehow smart, maybe.
@ agyat	:	(19 April 2013 - 02:54 AM) And of course I know it is not SEO friendly.
@ agyat	:	(19 April 2013 - 02:52 AM) There may be two possible answers for that .... 1) Shout was posted using mobile keypad. 2) To force people read content carefully and/or with more concentration.
@ agyat	:	(19 April 2013 - 02:49 AM) There may be two possible answers for that ....
@ yordan	:	(18 April 2013 - 09:35 PM) however, why this mixing of capital letters in the middle of your text?

MS Excel -- Automatic Update Of Data

Started by Kushika, Mar 12 2006 11:32 AM

Reply to this topic

20 replies to this topic

#1 Kushika

Member [ Level 2 ]

Members
72 posts

Location:UK

Posted 12 March 2006 - 11:32 AM

I've got a cell that contains a number, and it is likely for hat number to increment or decrement itself on a ragular basis.

Could someone briefly explain how it would be made for the number to adjust automatically? For example, lets say that that cell is driven by a database, if I import data from a database, and then the information in the db changes, will Excel adjust accordingly? Please help -- I'm really stuck on this. It's part of some coursework I'm doing and I'm desperate for an answer.

#2 yordan

Way Out Of Control - You need a life :)

[MODERATOR]
4,677 posts

myCENTs:53.92

Posted 14 March 2006 - 04:21 PM

If you really import the cell from a database, the value will change when you perform the import. then, it will not be changed until the next import.
If the cell is linked to a query to the database, it will probably change each time you refresh your view or each time you click in the "recalculate now" tag which is hidden somewhere in the Exclel menus.

#3 Guest_FeedBacker_*

Guests

Posted 16 April 2008 - 11:52 AM

How to increment the cell values when I linked two excel files
MS Excel -- Automatic Update Of Data

I am using two excel sheets. Sheet1 linked to sheet2.
For ex:
Sheet1's B1 cell linked to sheet1's c1;
Sheet1's B2 cell linked to sheet1's c2;
Sheet1's B3 cell linked to sheet1's c3

When I tried to link the first b1 cell and try to drag to copy on the same way the formulae for b2 and b3 cells., I am not getting the appropriate values. I am getting the same b1 cell values in the cell. I need to get the increment of cell number when I am dragging the cell value to the other cell values.

Can some one help me to solve this issue. It will save lots of my time.

-question by Madhu

#4 Guest_iGuest-Nalini_*

Guests

Posted 17 November 2008 - 11:50 AM

can i upload any type of database automatically in to excel sheet?
MS Excel -- Automatic Update Of Data

Suppose we have a cell phone easy recharge,In that message we have many fields like customer number,transaction id,amout recharged,talktime,date,time and so on...
If we store one message in a notepad can it automatically go to excel sheet?

or

If we store that by using a table created by sql can it automatically store in excel sheet?

or

Can you suggest me any solution for this?

This is the one I need very soon for my project...
So,Please assist me soon...

-question by Nalini

#5 Guest_iGuest-Abhinav Mehra_*

Guests

Posted 31 December 2008 - 07:19 AM

Auto update cells in different workbooks?
MS Excel -- Automatic Update Of Data

I have a rather elementary query.
I have a cells in a master workbook containing values for a certain person
now these values are changed everyday.
these values are also copied in a no.Of other workbooks.
I want that these cells in the other workbooks update themselves to the value of the cell in the master workbook
thanx
Abhinav 

-question by Abhinav Mehra

#6 Guest_(G)Zia _*

Guests

Posted 02 January 2009 - 07:39 PM

collecting data from web to excel...MS Excel -- Automatic Update Of Data

I used webpage on which data changes periodically and automatically get loaded(according to time frame set) to excel sheet linked to the webpage.

I am creating web queries with iql files...

I hope it will help!

http://www.Oecd.Org/.../24/2750766.Pdf

-reply by Zia

#7 Guest_(G)John_*

Guests

Posted 12 April 2009 - 03:56 PM

automatcally open other excel files to update dataMS Excel -- Automatic Update Of Data

I have a database that will export numerous excel files. I have an excel file that uses the data from these exported files. My trouble comes when theses exported files are regenerated by access. The master excel file will not get the updated information from the exported files unless the exported files are opened (even momentarily) while the master file is open.

Q: Is there a way either from access or excel to have the master file get updated automatically.

Thanks

-question by John

#8 Guest_(G)Manjinder_*

Guests

Posted 18 April 2009 - 05:23 AM

Automatically update master file in excelMS Excel -- Automatic Update Of Data

My name is manjinder and I wnat your help for certen query in excel.

1. I have 200 files of excel and one master file. I want to automatically update the master file when I change into any file from 200 of files.

2. If I change the location of master file then the link of other files in master file should be update automatically.

3. If I change the name of linked file in master then the link of changed name file in master should be update automatically.

-reply by Manjinder

#9 Guest_(G)VINAYACHANDRAN GOPALAKRISHNA _*

Guests

Posted 28 April 2009 - 10:36 AM

EXCEL STOCK UPDATEMS Excel -- Automatic Update Of Data

I have the stock symbols (tickers) to all thestocks that I'd like it to automatically update the price of the stock and thechange in the stock. There's about 7,000 stocks so it's got to be built very robustly to be able to update each of the stock's price and change.

Also I would like to add stocks to this list over time so that in the nearfuture I can add a stock to the spreadsheet and it will automatically get the priceand change of the stock.

Aside from downloading the stock price and change I'd like it to download thecompany's name of each stock as well so that a column next to the symbol willbe the company name.

-reply by VINAYACHANDRAN GOPALAKRISHNA PANICKER

#10 Guest_(G)prabhat_*

Guests

Posted 26 May 2009 - 09:52 AM

Between linking of files one file is main file and remaining files having link with taht file. SO any change in perticular file with all files are linked will update changes in all remaining files.

I f your master file having link with any file not other file having link with master file, then automatically changes will update in your file.

Replying to (G)VINAYACHANDRAN GOPALAKRISHNA -reply by prabhat

#11 Guest_(G)boy_*

Guests

Posted 06 July 2009 - 03:39 AM

how to update database in SQL server from excel..MS Excel -- Automatic Update Of Data

Think about these situation and I really hoping for any suggestion...

1. Upload a excel file, these file is a form that need to be filled up..

2. All the data inside the form need to be sent directly to the database(SQL server)..Update the database automatically when uploading the file..

**IN PHP PROGRAMMING LANGUAGE..

Can anyone give me suggestion????Need your guys help...

#12 Guest_(G)Hemal_*

Guests

Posted 29 September 2009 - 04:05 PM

merging the data from various sources by keeping some column unchanged.MS Excel -- Automatic Update Of Data

I am having a file which is having some indices in first column (Column A) & their value in next column (Column B).

I do have many other text / .Prn/ .Csv files. All these files are having again the same design as of the above one I.E. Indices in Column A & their values in Column B.

Now I want to have the facility to keep first file as a MASTER file, in which Column should remain unchanged (indices), column B is already having some values, I want to just pick the values of same indices but for some other tag from Column C...

Is it possible ? How ?

Thanks

-reply by Hemal

#13 Guest_(G)Ravipal_*

Guests

Posted 19 December 2009 - 10:22 PM

Data from excel to excel from runing VBAMS Excel -- Automatic Update Of Data

I want to export data from 1 excel sheet to another excel sheet without opening the sheets from which data to be exported.

Thanks in advance.

-question by Ravipal

#14 Guest_(G)Jason_*

Guests

Posted 22 December 2009 - 02:38 AM

when you tell one cell to = another from another sheet it adds dollar signs before the letter and number of that cell which makes it permanent. after you make one cell = another from another location such as another sheet. modify the equation by deleting the dollar signs and then drag to copy and you will see a difference. the cell might look like =sheet2!$A$2. delete the dollar signs so it says =sheet2!A2

-reply by Jason

#15 Guest_(G)Charlene_*

Guests

Posted 01 February 2010 - 06:27 PM

Data refreshing in excel 2007MS Excel -- Automatic Update Of Data

I have conditional formatting on a range of cells but the format that I've specified this range to use, does not take effect until I refresh my page even when the value is true. I have co-workers using the same version of excel and the exact same document but the range of cells automatically changes to the specified format without them having to refresh their page. I've looked in my options and can't find anything that's different than their options. What do I have to change???

-question by Charlene

#16 Guest_(G)_*

Guests

Posted 23 February 2010 - 09:54 PM

I have a spreadsheet that user load and then change some of the cells to represent the actual data not the estimated data that is in the spread sheet. I want to put this on an html page so that they can do it there. Is this doable and if so does anyone have a code snippet I could improve on to make this work?

Thanks,

Jim

#17 Guest_(G)ebincharles_*

Guests

Posted 22 February 2010 - 10:00 AM

excell formulaMS Excel -- Automatic Update Of Data

I am using MS Excell.I need to convert the amount in one cell in words to another cell.Example A1 = 580.00Then B1 should be = FIVE HUNDRED EIGHTY ONLY.CAN U HELP ME?

question by ebincharles

#18 Guest_(G)Winona Vannoy_*

Guests

Posted 23 March 2010 - 10:41 PM

Years ago I created a spreadsheet in Lotus where I could query postings to accounts on the same page. I was able to update it to Excel 2003 by just saving it in that program changing the type at the bottom as I saved it. I am now trying to update it to excel 2007 and I can work all of my macros in that program but it will not query. Can anyone help me. Thanks

-reply by Winona Vannoy

#19 Guest_(G)NAREN BHARADWAJ_*

Guests

Posted 02 May 2011 - 06:53 AM

to convert the amount in one cell in words to another cellMS Excel -- Automatic Update Of Data

Replying to iGuest download suresh addin and install that addin in your excel . Where ever u need to convert no into word it will convert for ex a1 cell is having 250 u want B1 cell in word (put =rswords(A1))

-reply by NAREN BHARADWAJ

#20 Guest_(G)Jared_*

Guests

Posted 09 March 2011 - 08:54 PM

Updating a different page automaticallyMS Excel -- Automatic Update Of Data

I have two different worksheets that I would like to update. The first worksheet already updates automatically from the web. However, the second worksheet I want to automatically update with the information from the first worksheet, but I want the information to fall at the bottom of the existing data.Is there a way to update the cells below the existing data automatically from a different worksheet?

-reply by Jared

Back to Business & Productivity

Reply to this topic

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users