a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:

udhaya · #1 11-08-2015, 09:43 PM

I need a help...

I need a macro that can copy data from copy.xls to our current excel macro.xls based on the following criteria:

* Get the filename of another excel(copy.xsls) in B1 cell by clicking on the button in the C1 cell of our current file (macro.xsls)
* have to read the cell value in the copy.xsls based on the criteria

Like for example :
in the Lth column having the header at L5 filter criteria "Yes"
Copy the H column values in to the A column in macro.xsl

udhaya · #2 11-12-2015, 10:12 AM

Kindly help me with the reply code

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error when trying to open .docx after I run a macro to copy data between tables in two documents	reesjordan	Word VBA	3	06-18-2015 12:28 AM
Need macro to copy object on slide 4 to current slide	djlee	PowerPoint	2	02-11-2015 10:37 AM
Want to change Macro to copy and paste data to new sheet	Vortex69	Excel Programming	0	12-23-2014 09:53 PM
Excel VBA Macro - Deleting Specific Data based on criteria	MD011	Excel Programming	3	12-10-2014 02:15 AM
Macro to copy specific columns in Excel from another spreadsheet	KD999	Excel Programming	1	07-20-2012 08:58 AM