Merging of Worksheets

[Shabbo]

Dear Sir,

I wanted to consolidate Cash/BPCL/and NEFT sheet into one sheet.

Actual data Is large so please select entire range.

 

[Khalid NGO]

Hi,

Use RDBMerge add-in, it is very useful / fast and easy to use:
https://www.rondebruin.nl/win/addins/rdbmerge.htm

Before merging, change your sheet names temporarily to something like:
Cash
Cash2
Cash3

Then in the field "Merge all files with a name that contains" enter the following name:
Cash*

There are many options which are self explanatory.

Regards,

 

[Shabbo]

Hi,

Use RDBMerge add-in, it is very useful / fast and easy to use:
https://www.rondebruin.nl/win/addins/rdbmerge.htm

Before merging, change your sheet names temporarily to something like:
Cash
Cash2
Cash3

Then in the field "Merge all files with a name that contains" enter the following name:
Cash*

There are many options which are self explanatory.

Regards,

Its not working sir.

 

[Khalid NGO]

Hi,

Please check the option "Which files" and try selecting xl? It should work


Regards,