Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default code for Copying rows based on a value

Hi, I have an Excel workbook with two worksheets.
Sheet1 has Floor Plan that cover top 45 rows

Sheet 2 has Agent information.

One of the column is Job Type that store "Full time" or "Part Time". I want
to list column J, K and L of rows that has job Type "Full Time" at any
giving time in Sheet 1 (at Row 50, column F,G and H) by using a macro. Also I
need Row 49 to display Field Name of column J, K and L.

Thanks

Mir
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,101
Default code for Copying rows based on a value

Just a little more info and we could help you.

"Mir Khan" wrote:

Hi, I have an Excel workbook with two worksheets.
Sheet1 has Floor Plan that cover top 45 rows

Sheet 2 has Agent information.

One of the column is Job Type that store "Full time" or "Part Time". I want
to list column J, K and L of rows that has job Type "Full Time" at any
giving time in Sheet 1 (at Row 50, column F,G and H) by using a macro. Also I
need Row 49 to display Field Name of column J, K and L.

Thanks

Mir

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
Copying rows based on date flurry[_5_] Excel Programming 4 June 3rd 06 06:05 PM
Copying rows to different worksheets based on a cells value DanSmoach Excel Programming 2 May 8th 06 06:32 PM
Copying whole rows based upon one criteria kirbster1973 Excel Discussion (Misc queries) 2 May 26th 05 10:00 PM
Copying an entire row or Rows based on column criteria Bill Excel Programming 11 April 27th 05 11:13 PM
Copying rows of data based on a value in a cell. Screamerz Excel Programming 4 December 16th 04 01:40 PM


All times are GMT +1. The time now is 10:27 AM.

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

About Us

"It's about Microsoft Excel"