LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
E.Carroll
 
Posts: n/a
Default With a formula copy data from one sheet to another

I´m new here in the office and the old secretary left all the workboots
perfect. But the boss wants a new sheet inside and i´m not sertain of how to
acomplish this.

What i need on the sheet "week #1" The last cell(AN5) will have a number I
need a formula that if this cell has a valor more then 14 I need excel to
copy everything in the row 5 (A5 until AN5) to a similar sheet called
"Lianhona #1" thats in the same workbook. I don´t have much time or
experience with excel and I only have Excel 2000 so if anyone could share
some ideas I would be very greatful.

Thanks.
S.H.C.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i enter data using formula and the Copy command For exa. 5494 New Users to Excel 0 January 28th 05 05:55 AM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
matching data formula? Todd Excel Worksheet Functions 1 November 16th 04 08:44 PM
getting data from 2 different exc sheet pinar Excel Worksheet Functions 1 November 9th 04 02:58 PM


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"