eric86vabeach
New Member
- Joined
- Jan 29, 2014
- Messages
- 23
what i would like to do is copy a range of data "B185:AA185" and cell "b185" has a "date/value" and paste range "B185:AA185" to the right on new page the new page would have "dates/values" going down the side of sheet and if "b185" match then paste row "C185:AA185" i would like to have the match/find due if a day is skip then i wount have to go to the master sheet and add new line
data sheet
[TABLE="width: 500"]
<TBODY>[TR]
[TD]row#[/TD]
[TD]A[/TD]
[TD]"B"[/TD]
[TD]"C"[/TD]
[TD]"D"[/TD]
[TD]"E"[/TD]
[TD]"F"[/TD]
[/TR]
[TR]
[TD]183[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]184[/TD]
[TD][/TD]
[TD]todays date[/TD]
[TD]Day[/TD]
[TD][/TD]
[TD]total sale[/TD]
[TD]other data[/TD]
[/TR]
[TR]
[TD]185[/TD]
[TD][/TD]
[TD]2/22/2014[/TD]
[TD]saturday[/TD]
[TD]February[/TD]
[TD]$100.95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]186[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]187[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]188[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
master sheet
[TABLE="width: 500"]
<TBODY>[TR]
[TD]row # [/TD]
[TD]Date[/TD]
[TD]day[/TD]
[TD]Mounth[/TD]
[TD]total sale[/TD]
[TD]other data[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]2/22/2014[/TD]
[TD]Saturday[/TD]
[TD]February[/TD]
[TD]$100.95[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]2/23/2014[/TD]
[TD]sunday[/TD]
[TD]February[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]2/24/2014[/TD]
[TD]monday[/TD]
[TD]February[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ect..[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Thanks for reading and the Help
Eric
data sheet
[TABLE="width: 500"]
<TBODY>[TR]
[TD]row#[/TD]
[TD]A[/TD]
[TD]"B"[/TD]
[TD]"C"[/TD]
[TD]"D"[/TD]
[TD]"E"[/TD]
[TD]"F"[/TD]
[/TR]
[TR]
[TD]183[/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]184[/TD]
[TD][/TD]
[TD]todays date[/TD]
[TD]Day[/TD]
[TD][/TD]
[TD]total sale[/TD]
[TD]other data[/TD]
[/TR]
[TR]
[TD]185[/TD]
[TD][/TD]
[TD]2/22/2014[/TD]
[TD]saturday[/TD]
[TD]February[/TD]
[TD]$100.95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]186[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]187[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]188[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
master sheet
[TABLE="width: 500"]
<TBODY>[TR]
[TD]row # [/TD]
[TD]Date[/TD]
[TD]day[/TD]
[TD]Mounth[/TD]
[TD]total sale[/TD]
[TD]other data[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]2/22/2014[/TD]
[TD]Saturday[/TD]
[TD]February[/TD]
[TD]$100.95[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]2/23/2014[/TD]
[TD]sunday[/TD]
[TD]February[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]2/24/2014[/TD]
[TD]monday[/TD]
[TD]February[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ect..[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Thanks for reading and the Help
Eric