Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 66
Default copy from worksheet in macro

I have two worksheets one for attendance and one for terminations. I want to
create a macro where I will have a text box that the person will fill in the
employee number and from the attendance roster it will find the relivent
information from it.

example I need the first name, last name, emplyee number and supervisor from
the attendance roster and need it to fill in on the termination sheet at
various locations. Please help as I have been battling this for a bit.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 140
Default copy from worksheet in macro

You are on the right track. VBA macros are required to do this work.

I do this programming for a living. See the link below.

http://phoenix.craigslist.org/wvl/cps/1144665428.html

I could do this in 2 hours.

Dennis


"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:956ed682c17f3@uwe...
I have two worksheets one for attendance and one for terminations. I want
to
create a macro where I will have a text box that the person will fill in
the
employee number and from the attendance roster it will find the relivent
information from it.

example I need the first name, last name, emplyee number and supervisor
from
the attendance roster and need it to fill in on the termination sheet at
various locations. Please help as I have been battling this for a bit.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 66
Default copy from worksheet in macro

Thanks for the reply denis, but I dont get paid to do it so wont pass it on
to someone else to get paid. Sorry :)

Dennis Tucker wrote:
You are on the right track. VBA macros are required to do this work.

I do this programming for a living. See the link below.

http://phoenix.craigslist.org/wvl/cps/1144665428.html

I could do this in 2 hours.

Dennis

I have two worksheets one for attendance and one for terminations. I want
to

[quoted text clipped - 7 lines]
the attendance roster and need it to fill in on the termination sheet at
various locations. Please help as I have been battling this for a bit.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Macro with Worksheet Kersten Excel Discussion (Misc queries) 4 April 3rd 09 05:36 PM
VB Macro to Copy from Worksheet KCG Excel Discussion (Misc queries) 1 September 2nd 07 08:46 AM
Macro to copy worksheet clarknv Excel Discussion (Misc queries) 2 June 17th 07 08:42 PM
macro to copy worksheet vitorjose Excel Worksheet Functions 0 January 25th 07 01:01 AM
I need help with a macro which will copy a worksheet and.. Greegan Excel Worksheet Functions 2 July 29th 05 11:48 PM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"