Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Merg
Hi All,
I have 4 csv report file with the following file name as follows :- Interspec_CH_EOD_Report.csv CHPending.csv Interspec_HD_EOD_Report.csv HDPending.csv my query is I want all HDPending.csv data to be copied in Interspec_HD_EOD_Report.csv file at the end of the row of Interspec_HD_EOD_Report.csv file deleting the heading row from HDPending.csv like for CHPending.csv also to be copied to Interspec_CH_EOD_Report.csv file. Then I want common data to be removed no data to be repeated. TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Merg
What was the problem with my last solution?
http://www.microsoft.com/office/comm...ang=e n&cr=US "kiran" wrote: Hi All, I have 4 csv report file with the following file name as follows :- Interspec_CH_EOD_Report.csv CHPending.csv Interspec_HD_EOD_Report.csv HDPending.csv my query is I want all HDPending.csv data to be copied in Interspec_HD_EOD_Report.csv file at the end of the row of Interspec_HD_EOD_Report.csv file deleting the heading row from HDPending.csv like for CHPending.csv also to be copied to Interspec_CH_EOD_Report.csv file. Then I want common data to be removed no data to be repeated. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format zip code (9) to use in Word merg doc | Excel Discussion (Misc queries) | |||
VLOOKUP 1 stop Answer: 3 steps: count dup's, compare dif's, merg | Excel Discussion (Misc queries) | |||
How do I get macro to unmerge cells that have been previously merg | New Users to Excel | |||
Merg Worksheets | Excel Worksheet Functions |