Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing worksheet and Marking the difference
I have a report I exported out of an accounting program into excel for 2
different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing worksheet and Marking the difference
I had used vlook up but I sent you the spreadsheet. I didn't notice your
reply before thanks for any help you can give me. Mary Klafert "Martin Fishlock" wrote: Hi Try using vlookup to find the missing items you need to make unqiue keys if the ones with a n/a. If there are too many transactions may need to use Access. or work on months at a time. If you like send me at his remove .cutthis and I will have a look. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "klafert" wrote: I have a report I exported out of an accounting program into excel for 2 different companies, (old company and original company. I am rebuilding one company by exporting data from the original company and importing into the new company. I would like to compare the report and find the missing information that might not have gotten imported into the new company or duplicated information that might have been imported twice without having to set down and check off all entries. I have to do this for a whole year and their are many entries. Then I can take the difference and import the missing and delete the duplicate information from the new company. In the end I should have identical information in both company. I am doing a cash receipts report. I can send the Excel files, as an example, but right now I don't see a way to upload them and attach them to this message. They are virus free. Just reformatted this whole hard drive for anybody concern. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marking unlocked cells in active worksheet | Excel Discussion (Misc queries) | |||
deleting a Text Box in a worksheet | Excel Worksheet Functions | |||
Speed of marking cells | Excel Worksheet Functions |