Auto transfer of information from one worksheet to another

I

i8ig

Board Regular
Joined
Jul 17, 2007
Messages
122
It's probably simple but can someone help me write a formula/macro that takes information entered on one worksheet and transfer it to another in the same workbook by date? Example:
Name Date Rec Date Due
John Doe 7/25/07 8/22/07

I need the same information on an August worksheet in date order as is on the July worksheet.

Any suggestions?
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
You must log in or register to reply here.

Similar threads

U
  • Question
Information overwriting when transferring
Replies
7
Views
296
UTB
U
I
  • Solved
Formate date when transfering from worksheet to worksheet
Replies
4
Views
342
ipbr21054
I
I
  • Question
Move multiple rows from one table to another using conditional trigger
Replies
2
Views
505
ItsNursinTime
I
S
  • Solved
auto Lock cells after due date
Replies
3
Views
428
Sophia2
S
C
  • Question
Take full name from one worksheet, make appear as first name last initial in another
Replies
3
Views
223
awoohaw
awoohaw

Forum statistics

Threads
1,215,731
Messages
6,126,539
Members
449,316
Latest member
sravya

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