Using macro to copy data relating to specific date

naq_uk · Apr 15th, 2002, 11:32 AM

Is it possible for a macro to copy and paste specific cells from one sheet onto another one if the date is the same from the first sheet? IF anyone knows PLEASE HELP!!

THANKS!!

From,
Naz

AJ · Apr 15th, 2002, 12:40 PM

Yeah, definitely, but could you post a little more info please about precisely how you imagine the process to work i.e.
"If cell a1 on sheet1 matches cell c27 on sheet4 then copy all of row 3 on sheet 1 to the last row on sheet6?" etc. etc.

Mark O'Brien · Apr 15th, 2002, 12:45 PM

Yeah, more detail would be good especially as it may be possible to avoid VBA on this one, unless you really require it. (I tell you, I frighten myself with the amount of times I'm trying to avoid VBA these days.)

_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-15 11:47 ]

naq_uk · Apr 15th, 2002, 03:28 PM

Basically I have a sheet called picking list with date in cell B12. I have another sheet called invoice where the information is recorded onto a separate sheet with a row for each invoice(including the invoice date [column c]).
What should happen is that if there are invoice records with the same date as the one in the picking list then the entire row from the invoice records should be copied onto the picking list sheet.

For example say there have been 5 entries on the invoicefor today all of the information recorded from the invoices should copy onto the picking list if the date is that of todays.

Sorry if it is confusing it is for a college project and my teacher can't help. He is new to this!! (English schooling system!!!)

Thanks 2 any1 who can help....If it makes SENSE!! If it doesn't please let me know.

Love
Naz

[ This Message was edited by: naq_uk on 2002-04-15 14:29 ]

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

Apr 15th, 2002, 11:32 AM	#1
naq_uk New Member Join Date: Apr 2002 Location: London, Tottenham Posts: 8	Is it possible for a macro to copy and paste specific cells from one sheet onto another one if the date is the same from the first sheet? IF anyone knows PLEASE HELP!! THANKS!! From, Naz

Apr 15th, 2002, 12:40 PM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Yeah, definitely, but could you post a little more info please about precisely how you imagine the process to work i.e. "If cell a1 on sheet1 matches cell c27 on sheet4 then copy all of row 3 on sheet 1 to the last row on sheet6?" etc. etc.

Apr 15th, 2002, 12:45 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yeah, more detail would be good especially as it may be possible to avoid VBA on this one, unless you really require it. (I tell you, I frighten myself with the amount of times I'm trying to avoid VBA these days.) _________________ [b] Mark O'Brien [ This Message was edited by: Mark O'Brien on 2002-04-15 11:47 ]

Apr 15th, 2002, 03:28 PM	#4
naq_uk New Member Join Date: Apr 2002 Location: London, Tottenham Posts: 8	Basically I have a sheet called picking list with date in cell B12. I have another sheet called invoice where the information is recorded onto a separate sheet with a row for each invoice(including the invoice date [column c]). What should happen is that if there are invoice records with the same date as the one in the picking list then the entire row from the invoice records should be copied onto the picking list sheet. For example say there have been 5 entries on the invoicefor today all of the information recorded from the invoices should copy onto the picking list if the date is that of todays. Sorry if it is confusing it is for a college project and my teacher can't help. He is new to this!! (English schooling system!!!) Thanks 2 any1 who can help....If it makes SENSE!! If it doesn't please let me know. Love Naz [ This Message was edited by: naq_uk on 2002-04-15 14:29 ]