next problem

**sexgod** · 02-12-2007, 06:03 PM

can i impute text and data into sheet 1 and it will display on different sheets, for example column A list of first names, B list of jobs, C list of hours worked.
so that all data for SAM will be also on Sam's sheet, all toms on toms sheet etc but only the columns that i want to be copied, and as i write new info the relevant sheets will up date themselves.

**VBA Noob** · 02-12-2007, 06:27 PM

Always best to give more details that way you get a less general answer

You could use formula's but depending on how big the sheet is it might slow things down

Here's a a site that has some code to make a new sheet for each person

http://www.rondebruin.nl/copy5.htm#workbook

HTH

VBA Noob

**sexgod** · 02-12-2007, 07:00 PM

sorry not into vba ( think thats what its called) i wouldnt know how to start with it will have to find another way , thanks for trying

**tuph** · 02-12-2007, 07:09 PM

You could use VLOOKUP, but VBAnoob is right - it can slow things down if the workbook is large. Can you attach a copy of your spreadsheet so we can see what you are trying to do?

**VBA Noob** · 02-12-2007, 07:12 PM

Download this example from Max

http://savefile.com/files/37091

VBA Noob

**sexgod** · 02-13-2007, 04:09 AM

will send a copy of what i am trying to do to you later but got to go to work now and i work away from home could be some time befor i get back to you ok . by and once again thanks

next problem

LinkBack

Thread Tools

Rate This Thread

Display

next problem

vba

thanks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions