Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 11th 16, 07:06 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 55
Default Copy format based on identical datafields

Hello,

Struckling in previously obtained help and codes (thanks!) I want to built it up on another way and in some steps, so I can understand it better (also to learn a bit).

The macro somebody can hopely create for me;

--------

When push the button start a macro.
Sheet1:
Run a loop from row2 till last.
For each record:
Select the combined tekst in "Column_I + Column_J".
Sheet2:
Search in sheet2 to the indentical combined text in "Column_I + Column_J".
If found:
copy the format of that row in sheet2 from "Column_L till Column_UV"
to the active record in sheet1 to "Column_L till Column_UV".
If not found:
Next row till last one.

regards,
Johan


  #3   Report Post  
Old October 12th 16, 07:48 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 55
Default Copy format based on identical datafields

Works. Some parts minor rebuilded.
Thanks!

regards,
Johan


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Totaled based on Matching Identical Criteria in Worksheet Rob Excel Discussion (Misc queries) 1 April 21st 09 04:07 AM
Format all worksheets for identical printing Potatosalad2 Excel Discussion (Misc queries) 3 May 5th 06 03:42 AM
Clearing DataFields Jay Excel Programming 0 May 1st 06 02:56 PM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 07:03 AM
Inexplicable difference in row hiding speed - identical code, identical machines! Matt Larkin Excel Programming 5 November 1st 04 10:35 AM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017