#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Paste and Insert

Ok, I created a formula that I have been asking about but now I have one
problem. Let me quickly explain the scenario. I have info that I punch in on
one sheet and it appears on another. Now all I want to do is make that info
stay so I can punch in more info. Also after it pastes I would like to insert
a new row. Can we do this????

-Schwimms

"you can only grab the world when you can reach it"
-Dr. James B. Chris
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Paste and Insert

Would it help to share that formula with us?

Where do you do the "punching"?

In one cell or multiple cells?

By "stay" what do you mean?

Next new punch goes into cell below and next into cell below that and down the
column?

Where would you like to insert the new row?


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 12:56:00 -0700, Schwimms
wrote:

Ok, I created a formula that I have been asking about but now I have one
problem. Let me quickly explain the scenario. I have info that I punch in on
one sheet and it appears on another. Now all I want to do is make that info
stay so I can punch in more info. Also after it pastes I would like to insert
a new row. Can we do this????

-Schwimms

"you can only grab the world when you can reach it"
-Dr. James B. Chris


Reply
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
Fit info into a no. of places (insert row, copy & paste) easily [email protected] Excel Worksheet Functions 1 April 23rd 07 07:30 PM
Macro that will select and insert a new row and paste as value [email protected] Excel Worksheet Functions 3 December 5th 06 04:06 AM
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. stan-the-man Excel Worksheet Functions 7 June 14th 06 08:10 PM
How to assign Ctrl+Shift+Insert to Paste Values? [email protected] Excel Discussion (Misc queries) 5 October 3rd 05 10:43 PM
insert and paste in one step KathyinCincinnati Setting up and Configuration of Excel 1 December 2nd 04 12:30 AM


All times are GMT +1. The time now is 05:23 PM.

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

About Us

"It's about Microsoft Excel"