Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is It Possible?
I will try not to confuse anyone but here goes I am
working on Excel doing spreadsheets to keep track of peoples pay. I am using 1 document. with multiple Sheets in it. The first sheet is an overall sales log for a 7 day period with names, prices and other information. I want to know if it is possible and if so how to copy say just specific information from the first sheet to another by just having it to recognize a Name. Say I have information of Jan in Row 3B 6B and 17B and Jans personal log is the 2nd sheet. I want to transfer specific information located on 3A, 3G, 3J to the second sheet on for example 5A,5B, & 5C. Same for row 6B on sheet1, where i wannt to transfer 6A,6G,and17G to sheet 2 6A,6B,6C. And the same for row 17 B. But in Coloum B on sheet1 the information is A name Jan is it posibble to just allocate specific information on a weekly log that has 5 different people @ different intervals and taking thier specific information and posting it to a different sheet? Please help or tell if u need more information Thanks Rey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|