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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:

FAQ

Thread Tools

Display Modes

11-08-2015, 09:43 PM

udhaya

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

Office 2010 64bit

Novice

Join Date: Nov 2015

Posts: 2

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

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

Attached Images

	data_in_copyexcel.JPG (29.3 KB, 14 views)
	Button_in_macroexcel.JPG (12.7 KB, 14 views)

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