Copy data from one worksheet to another

H

hooch1969

New Member
Joined
Nov 29, 2005
Messages
1
I know this has probably already been answered, but I have not been able to locate what I need to know after searching the forums.
I want to enter data into one worksheet and the data then transfers automatically to another ON THE NEXT AVAILABLE LINE.
There are several fields that I need to transfer, including the name of the worksheet that the information is coming from.
I'm relatively inexperienced with Excel. Any help with this is greatly appreciated.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
No, Excel doesn't have any automatic feature to do this. MrExcel.com has experienced programmers that can be hired to create VBA modules for you.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Pasting concatenated data in another worksheet whilst ignoring blanks
Replies
0
Views
104
rmcc
R
C
  • Solved
VBA to copy data from multiple Sheets into One
Replies
3
Views
705
aRandomHelper
A
T
  • Question
Issues with sharing files Using One Drive
Replies
1
Views
166
Drrellik
Drrellik
C
  • Solved
Copy Paste Data
Replies
2
Views
190
cotech_10
C
S
  • Solved
Macro to get a cell copied from one worksheet to another, this is an odd situation
Replies
3
Views
197
sspatriots
S

Forum statistics

Threads
1,203,515
Messages
6,055,850
Members
444,828
Latest member
StaffordStag

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top