Look up cells in one sheet and add to another

		Microsoft Office Forums > Microsoft Excel > Excel
Look up cells in one sheet and add to another

FAQ

Thread Tools

Display Modes

02-25-2013, 06:20 AM

aulrich28

Windows 7 64bit Look up cells in one sheet and add to another

Office 2007

Novice

Join Date: Feb 2013

Posts: 2

Look up cells in one sheet and add to another

I am trying to create a timesheet form that would automatically populate from Sheet name (Calendar) to Sheet name (Timesheet). I keeping track of my time and jobs I work on through Microsoft Office Calendar. I want to export that info at the end of each week and import it into the Timesheet form. I have attached a sample of what I would like do to. Might be to much but I am lost. Tried vlookup, if, and index formulas with desired result.

Thanks for any help

Attached Files

Sample Timesheet.xlsx (23.2 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macros to Re Arrange these Cells to Look like Sheet 2	taimysho0	Excel	2	01-25-2014 11:05 AM
sheet 2 data highlight in sheet 1	gsrikanth	Excel	1	04-21-2012 06:25 PM
Construct a summary sheet by summing up from one or more than one sheet.	PRADEEPB270	Excel	1	11-04-2011 03:46 AM
How to merge two cells from sheet1 to one cell in sheet2 in next sheet	KIM SOLIS	Excel	6	10-30-2011 11:14 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 AM.