Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a formula to copy data from one worksheet to another
I am trying to copy cell data from on worksheet to another based on the value
in a different column. 1 ws is a calendar - Each cell represents a day of month 1 ws is the month of January - Colums in this worksheet are "Day" and "Applicant" Column A = "Day" column is a drop down so user can select appropriate "day of month" Column B = "Applicant is a text column so user can enter the "applicant name" I can get the "If" statement to work, but for only one cell at a time. Because there could be multiple interviews on the same day I need to look at the entire column A and copy the corresponding field in colum B Any help would be great! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a formula to copy data from one worksheet to another
Erika
Your post reads like you left something out in the middle. You mention an "If" statement but you don't show any "If" statement. Post back and describe what you have. Not what you want. Just what you have. Describe it all as if you are talking to someone who knows nothing about your work, your office, your company. Then describe what you want to look for. Then describe what you want to happen when what you are looking for is found. When you say you want to copy "field in column B", where do you want to place it? What sheet? What column? What row? HTH Otto "Erika" wrote in message ... I am trying to copy cell data from on worksheet to another based on the value in a different column. 1 ws is a calendar - Each cell represents a day of month 1 ws is the month of January - Colums in this worksheet are "Day" and "Applicant" Column A = "Day" column is a drop down so user can select appropriate "day of month" Column B = "Applicant is a text column so user can enter the "applicant name" I can get the "If" statement to work, but for only one cell at a time. Because there could be multiple interviews on the same day I need to look at the entire column A and copy the corresponding field in colum B Any help would be great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data from once worksheet to another using formula | Excel Discussion (Misc queries) | |||
Copy data from one worksheet and paste into another worksheet | Excel Programming | |||
Copy data in multiple worksheet tabs into one worksheet | Excel Programming | |||
A formula to filter data and copy it from one worksheet to another | Excel Worksheet Functions | |||
formula/function to copy from worksheet to worksheet | Excel Programming |