| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro needed to compare value and copy data underneath it to anoth
I have a spread sheet with column A and B being static but Column C1 has a
value 101 and D has 102 and so on till 900. What I want to do is that compare C1 with another sheet that is in same format but missing number in between for example its has C1=101 and D1=103. If C101 is there i need to copy all value in that column to sheet 2 underneath C101 but if D1 is 103 then it should put 0' in D1=102 from D2 - D25. let me know if there can be any macro written to compare and copy the values. If you dont understand anypart please feel free to ask as many questions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare two text and if equal copy adjacent data | Excel Worksheet Functions | |||
| How do I set up formula to copy format from one worksheet to anoth | New Users to Excel | |||
| Is it possible to copy a header/footer from one worksheet to anoth | Excel Discussion (Misc queries) | |||
| copy every 30th cell in the column into consecutive cells in anoth | Excel Worksheet Functions | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Threaded Mode
