Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging Excel data from identical copies of a workbook
I have two identical workbooks which must be maintained seperately and merged
occasionaly into a third identical MASTER.xls copy. There is no calculation involved. What I need to do is to look at each cell in a range and transfer its data to the MASTER copy - ONLY if there is nothing in that cell already. If data exists already in that cell of the the MASTER, I want to do nothing and progress to the next cell. I will need to do the same thing with at least one other copy. The data amounts to a 1 used as a tick mark indicating a procedure performed. MASTER.xls will ultimately have summaries and charts - that part is easy. I am an OLD COBOL programmer, but a total newbie when it comes to VBA. Any assistance would be greatly appreciated. -- Old time COBOL programmer, new VBA programmer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging identical workbooks in Excel 2007 | Excel Discussion (Misc queries) | |||
Merging two sheets with non-identical data | Excel Discussion (Misc queries) | |||
Excel opening 2 identical & parallel copies of a file. Won't stop | Excel Discussion (Misc queries) | |||
Merging to identical Excel files | Excel Discussion (Misc queries) | |||
merge/extract data from identical worksheets in a workbook | Excel Discussion (Misc queries) |