Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending data from one sheet to another.
I have Sheet 1 as my master list of infomation.
100023 red 100048 blue 100589 yellow Sheet 2 contains infomation to add FI 100027 purple FI 100048 blue Sheet 3 contains information to delete FO 1000589 yellow I need the master sheet to automaticly or by macro button add any new files in Sheet 2. So it would only add the purple row because blue is already in the list. And Sheet 3 information needs to be deleted from the master Sheet, so yellow would be deleted. Any additions need to be appended to the bottom of the master list. The result would be in the master sheet: 100023 red 100048 blue 100027 purple |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Appending Data | Excel Discussion (Misc queries) | |||
Appending Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Appending data from one WB to another WB by date: | Setting up and Configuration of Excel | |||
Appending individual XML files to a sheet | Excel Discussion (Misc queries) | |||
Formula for appending data | Excel Worksheet Functions |