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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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