LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to make columns in one sheet match columns from another sheet

I have four columns of data that need to be exactly the same on two
worksheets. How can I make those columns on sheet B be automatically updated
when I make any chage to sheet A. Those changes can be text update, row
insertion/deletion, and ideally, formatting.

Do I need a macro to do this? Does anyone have a similar macro for me to
start with?

Thanks
Zoe
 
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
How to Insert Columns in a big Sheet... JV Excel Worksheet Functions 2 March 30th 07 07:42 PM
help with sorting text in columns to match other columns rkat Excel Discussion (Misc queries) 1 August 11th 06 03:42 AM
Take 3 columns, one per sheet and turn it into one on 4th sheet Lori Excel Worksheet Functions 1 February 16th 06 12:45 AM
Can I add more columns to a spread sheet or is limit 256 columns Piper Excel Discussion (Misc queries) 4 October 9th 05 08:27 PM
TEX TO COLUMNS PROTECTED SHEET Jeracho Excel Discussion (Misc queries) 1 August 26th 05 09:51 PM


All times are GMT +1. The time now is 03:00 PM.

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

About Us

"It's about Microsoft Excel"