Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() _Summary_of_things_needing_tweaking:_ When macro is run second time around, it should update the original export instead of creatiing it as a new sheet. There are two enter sheets so coding needs to by applied to those two sheets, note second sheet has a few extra columns of data. If there is no value to compare against for the marks then in the export read 'check'. The table starts from row 3 (the headings) whilst data entries (name etc) run from row 4 to row 299 (both enter sheets) If subject has word 'accelerated' in it, then export the original mark without comparing against table -- iMAN2 ------------------------------------------------------------------------ iMAN2's Profile: http://www.thecodecage.com/forumz/member.php?userid=371 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102545 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two columns and return a third | Excel Worksheet Functions | |||
Comparing two combos/cells to return a value | Excel Worksheet Functions | |||
comparing cell to row, return all matchs | Excel Worksheet Functions | |||
sumproduct return value by comparing two criteria..... | Excel Worksheet Functions | |||
Comparing two lists and return specified data | Excel Worksheet Functions |