Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Pulling data from one worksheet to another
Hello everyone - Im not sure if what I am trying to do requires Macro
programming, but here's what I am trying to accomplish. I have a workbook with two worksheets. Worksheet "A" includes a column (column A) with various job titles - one job title within each cell. "A" also has a column (column B) which reflects either a 1 or a 0. The 1 indicates the role has been filled, the 0 indicates the role is open. The other worksheet ("B") is meant for the business unit lead to provide verbiage as to the reason the open role(s) is needed. What I would like to happen automatically is for the bworksheet B to pull only the job titles that are indicated with a 0. Lets assume Worksheet A includes 100 rows of data. Ten of those rows reflect open roles (indicated with a 0). I would like for Worksheet B to pull only the job titles that are indicated with the 0. Thus, Worksheet B would summarize this info within 10 rows. Hopefully this makes sense. Any suggestions would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling data from one worksheet to another
Try modifying this zip file i sent you, it has code and formula to achieve what you want! Regards, Simon +-------------------------------------------------------------------+ |Filename: Job Status.zip | |Download: http://www.excelforum.com/attachment.php?postid=5214 | +-------------------------------------------------------------------+ -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=572431 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling data from one worksheet to another
Simon Lloyd wrote: Try modifying this zip file i sent you, it has code and formula to achieve what you want! Regards, Simon +-------------------------------------------------------------------+ |Filename: Job Status.zip | |Download: http://www.excelforum.com/attachment.php?postid=5214 | +-------------------------------------------------------------------+ -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=572431 Simon - this is very helpful. I am having one problem though. When I run the Macro, it pastes the first name in the first empty cell within the designated column. How can I adjust the macro so I can specify the specific cell I want to start pasting at? Below is the macro I have adjusted thus far: Option Explicit Sub jobs() Dim mycell Dim rng As Range Dim rng1 As Range On Error Resume Next Set rng = Sheets("Dept_HC").Range("A1:A49") For Each mycell In rng If mycell.Offset(0, 8).Value = "0" Then mycell.Copy Sheets("Commentary").Select With Sheets("Commentary") Range("a2").Select Set rng1 = Range("a:a").End(xlDown)(2) rng1.Select End With ActiveSheet.Paste End If Next End Sub Thanks for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling data from one worksheet to another
The macro assumes you have data in the first row like a heading or titl as i have done in my demo for you if you type in a heading or title i A1 then it should work fine. You should remove the line On Error Resum Next Regards, Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=57243 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
Pulling data from another worksheet | Excel Discussion (Misc queries) | |||
Pulling Data from Another Worksheet | Excel Discussion (Misc queries) | |||
Pulling Data from a different worksheet (Need Help) | Excel Programming | |||
Pulling data from different worksheet | Excel Programming |