How can I link cells between 2 sheets on Excel?

So I have a Data Entry Form sheet and a Database sheet.
When i enter data in the data entry form i want it to show up on the database sheet under the same headings. How can i do this?

It sounds like you want to create a database of ongoing form entries. If this is true you will have to create a macro that copies your Form entries and uses Paste-Special/Values into a database sheet at the end of the form-entry process.
If you Link one cell to another it will keep changing as more data is entered.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook

Related information

Cpu usage lowering?

I understood form your question that you want to free up CPU usage. Well you could do that by going over to Services in Administrative Tools in Control Panel, and removing the unnecessary services ...

What software allows me to edit my video then burn it?

1- Ulead VideoStudio. to Edit and Burn. 2- windows movie maker to edit video only. 3- Adobe Premiere Elements that was top 3 i use ;) go also to List of video editing software on Wikip...

Do you invert the axis when you play first person shooters???

Yes. I had a FPS on the Dreamcast that I always used to play. It's default setting was inverted axis, so since then, yes, I invert the axis when I play FPS.

...

Hi all, how do i paste/burn an actual picture onto a CD, plz?

Writing/Burning/Pasting data or files onto a CD is a very simple thing. All you need is a CD Writing software (like Nero), some stuff to write onto a CD and a blank CD itself. > Insert your CD ...

Which is the best .avi file cutter or splitter software?

There might be other options but Virtualdub is a good choice. It's freeware, has been around for many years, and is well supported. As with any tool, there's a learning curve but to do ba...

What programs can I use to open PDF's?

Foxit is what I use, very fast.

...

What is the best MP3 Coverter?

Try Absolute MP3 Splitter - it splits, converts and merges all sorts of MP3, WMA, WAV files, etc. You can d/l for free but you need to pay for the full version.

...

Can someone help me with Internet Explorer? HELP!?

Your question is not clear but if you want to go back to IE6 go to Start\Control Panal\ Add or remove programs and uninstall IE7, Restart your PC. If that did not work go to ...