How do I automatically copy date from one to another?

**Scoodman** · 03-12-2010, 01:58 AM

I want to copy information from one spreadsheet to another. Say information from "Incident Log" A2 - AI2 to "Incident Register" A3-AI3. Not only this, I want it to recognise the next time it copies information across, that A3-AI3 on the "Incident Register" has been used so to go to A4-AI4 and so on...

Is this possible?

**teylyn** · 03-12-2010, 02:06 AM

Hi Scoodman,

you can pre-populate your Incident Register sheet with a formula like this in cell A1

=if(isblank('Incident Log'!A1),"",'Incident Log'!A1)

copy down and across.

**Scoodman** · 03-12-2010, 02:53 AM

Thanks very much Teylyn

Thread: How do I automatically copy date from one to another?

Thread Tools

Display

How do I automatically copy date from one to another?

Re: How do I automatically copy date from one to another?

Re: How do I automatically copy date from one to another?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions