Copy Like Data

		Microsoft Office Forums > Microsoft Excel > Excel
Copy Like Data

FAQ

Thread Tools

Display Modes

10-13-2015, 11:45 PM

macropod

Windows 7 64bit Copy Like Data

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

You could do this with formulae as simple as:
=INDEX('Day Closed'!A:A,MATCH(B2,'Day Closed'!B:B,0))

=C2-A2
in C2 and D2, respectively, of your 'Day Opened' sheet, but that sheet and the 'Day Closed' sheets don't use the same data formatting - the latter evidently uses text formatting to preserve leading 0s, but the former appears to be numeric. You should use the same data formats for both sheets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data from one form to another	jodjamz	Outlook	0	04-28-2015 05:07 PM
Copy data from certain Cells in new sheet	zain_shaikh	Excel Programming	1	02-11-2015 07:35 PM
Copy data from Word into Excel	chinchee	Word VBA	18	05-23-2014 05:25 AM
How to copy data automatically to particular sheet?	nicholes	Excel Programming	13	03-12-2014 01:05 AM
Copy data from spreadsheets to a two, with the sum criterion	marreco	Excel Programming	1	05-15-2012 04:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:59 PM.