Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from one sheet to another
I have a sheet in a workbook that I want to extract information from based on
Initials in Column G and have the information placed into other sheets in the workbook based on the initials. I need to have the data in date order (Column A) and no blank lines. I'm at a complete loss as to how to do this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from one sheet to another
You will need VBA (programming) for this.
Are the "other sheets" named the initials in column G of that first sheet? What is the name of the first sheet? What is the layout of your data, i.e., how many columns to copy, what columns, starting with what row in that first sheet, starting with what row in those "other" sheets? HTH Otto "Bcosta" wrote in message ... I have a sheet in a workbook that I want to extract information from based on Initials in Column G and have the information placed into other sheets in the workbook based on the initials. I need to have the data in date order (Column A) and no blank lines. I'm at a complete loss as to how to do this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from one sheet to another
Columns a A B C D E F G H I J Date Job# JobName Job$M Job$A PriorC% Mech Appr 3rdMan %Comp Where Date is entered, Job # is entered JobName, Job$M, Job$A, PriorC% are brought in from another sheet based on Job# Mech, Appr, 3rdMan and %Comp are entered I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets based on the initials entered in G I want the Date, Job#, JobName, %Comp Job$A to copy over to different sheets based on the initials entered in H I need to have the data left intact in the original sheets so COPY is a better word than EXTRACT i suppose. "Otto Moehrbach" wrote: You will need VBA (programming) for this. Are the "other sheets" named the initials in column G of that first sheet? What is the name of the first sheet? What is the layout of your data, i.e., how many columns to copy, what columns, starting with what row in that first sheet, starting with what row in those "other" sheets? HTH Otto "Bcosta" wrote in message ... I have a sheet in a workbook that I want to extract information from based on Initials in Column G and have the information placed into other sheets in the workbook based on the initials. I need to have the data in date order (Column A) and no blank lines. I'm at a complete loss as to how to do this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from one sheet to another
You say "JobName, Job$M, Job$A, PriorC% are brought in from another sheet
based on Job#" Do you need for the code to do this? If so, what is the name and layout of that other sheet? You say "I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets based on the initials entered in G". Are these "other sheets" named those initials? In other words, if there is "AB" entered in Column G, is there a sheet named "AB"? What is the layout of these "different sheets"? In other words, where in these "different sheets" do you want the data pasted? The same questions for copying based on the entries in Column H. Otto "Bcosta" wrote in message ... Columns a A B C D E F G H I J Date Job# JobName Job$M Job$A PriorC% Mech Appr 3rdMan %Comp Where Date is entered, Job # is entered JobName, Job$M, Job$A, PriorC% are brought in from another sheet based on Job# Mech, Appr, 3rdMan and %Comp are entered I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets based on the initials entered in G I want the Date, Job#, JobName, %Comp Job$A to copy over to different sheets based on the initials entered in H I need to have the data left intact in the original sheets so COPY is a better word than EXTRACT i suppose. "Otto Moehrbach" wrote: You will need VBA (programming) for this. Are the "other sheets" named the initials in column G of that first sheet? What is the name of the first sheet? What is the layout of your data, i.e., how many columns to copy, what columns, starting with what row in that first sheet, starting with what row in those "other" sheets? HTH Otto "Bcosta" wrote in message ... I have a sheet in a workbook that I want to extract information from based on Initials in Column G and have the information placed into other sheets in the workbook based on the initials. I need to have the data in date order (Column A) and no blank lines. I'm at a complete loss as to how to do this. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from one sheet to another
No I have that info coming in ok.
Yes the sheets are named with the initials. In "initial" sheet Col A=Date, Col B=Job#, Col C=JobName, Col D=%Comp, Col E=Job$M All other columns will be calculations based on the data transfered. Some of the "initial" sheets will use column G as the selector other "initial"sheets use column H. "Otto Moehrbach" wrote: You say "JobName, Job$M, Job$A, PriorC% are brought in from another sheet based on Job#" Do you need for the code to do this? If so, what is the name and layout of that other sheet? You say "I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets based on the initials entered in G". Are these "other sheets" named those initials? In other words, if there is "AB" entered in Column G, is there a sheet named "AB"? What is the layout of these "different sheets"? In other words, where in these "different sheets" do you want the data pasted? The same questions for copying based on the entries in Column H. Otto "Bcosta" wrote in message ... Columns a A B C D E F G H I J Date Job# JobName Job$M Job$A PriorC% Mech Appr 3rdMan %Comp Where Date is entered, Job # is entered JobName, Job$M, Job$A, PriorC% are brought in from another sheet based on Job# Mech, Appr, 3rdMan and %Comp are entered I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets based on the initials entered in G I want the Date, Job#, JobName, %Comp Job$A to copy over to different sheets based on the initials entered in H I need to have the data left intact in the original sheets so COPY is a better word than EXTRACT i suppose. "Otto Moehrbach" wrote: You will need VBA (programming) for this. Are the "other sheets" named the initials in column G of that first sheet? What is the name of the first sheet? What is the layout of your data, i.e., how many columns to copy, what columns, starting with what row in that first sheet, starting with what row in those "other" sheets? HTH Otto "Bcosta" wrote in message ... I have a sheet in a workbook that I want to extract information from based on Initials in Column G and have the information placed into other sheets in the workbook based on the initials. I need to have the data in date order (Column A) and no blank lines. I'm at a complete loss as to how to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract a sheet from another? | Excel Discussion (Misc queries) | |||
how to extract a sheet from another? | Excel Discussion (Misc queries) | |||
Extract info from one sheet to another | Excel Worksheet Functions | |||
Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
Extract sheet name/number to cell | Excel Discussion (Misc queries) |