The easy way to do it, Ken is to click on the cell you want the data in, type "=" in the folula bar and then go to the data cel you want to copy and click on it. That should populate the formula you need.
Clinton Randolph, CC-PMD Training Officer Liberty Ambulance Service, Inc. 1626 Atlantic University Circle Jacksonville, Fl 32207 [email protected] www.joinems.com This email may contain information that is preivelidged, confidential and/or exempt from discovery under applicable laws. Dissemination or further distribution by anyone other that the intended recipient for lawful reasons is prohibited and may be a violation of state and federal law. If you have received this email in error, delete it and notify the sender immediately. -----Original Message----- From: Ken Southwood [mailto:[email protected]] Sent: Tuesday, May 31, 2011 4:06 PM To: [email protected] Cc: Clinton Randolph Subject: [users] Re: Retrieve? Thankyou for that advice. But, unless I've entered it wrongly (no space, too much space) it doesn't work for me. I've tried variations on it, but no luck. Ken Southwood On 5/31/2011 2:53 PM, Clinton Randolph wrote: > This should be a simple formula "=sheet name, cell label" in the cell > you want the info to appear in on the new sheet. > > Clinton Randolph, CC-PMD > Training Officer > Liberty Ambulance Service, Inc. > 1626 Atlantic University Circle > Jacksonville, Fl 32207 > [email protected] > www.joinems.com > > > This email may contain information that is preivelidged, confidential > and/or exempt from discovery under applicable laws. Dissemination or > further distribution by anyone other that the intended recipient for > lawful reasons is prohibited and may be a violation of state and > federal law. If you have received this email in error, delete it and notify the sender immediately. > > -----Original Message----- > From: Ken Southwood [mailto:[email protected]] > Sent: Tuesday, May 31, 2011 3:14 PM > To: [email protected] > Subject: [users] Retrieve? > > Can someone tell me how to program a cell in one sheet to retrieve and > record a number in a cell in another sheet? > > > Ken Southwood > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] For > additional commands send email to [email protected] with Subject: > help > > -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
