+ Reply to Thread
Results 1 to 2 of 2

Carry information from Column accross work sheet

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    chicago
    MS-Off Ver
    2013
    Posts
    100

    Carry information from Column accross work sheet

    I have an excel file that has multiple work sheets. I need the data I add in the first work sheet column A to carry over to the other work sheets in Column A with out having to copy and past is there a way to do that.

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Carry information from Column accross work sheet

    Take this slow.
    Select your data in Sheet1
    Press Ctrl C to copy
    Click the tab of the next sheet
    Select the first Cell of the range you want to paste into in that sheet
    With Shift held down, click on the tab of the very last sheet you want to copy the data to. This selects all the sheets.
    Press Ctrl V to paste
    Frob first, tweak later

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Carry information from Sheet 1 to Sheet 2 maintain data integrity when adding rows
    By rhett7660 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 02:53 PM
  2. Replies: 1
    Last Post: 12-30-2015, 06:18 PM
  3. [SOLVED] Macro to copy row information from sheet to sheet won't work
    By beth.randall in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2012, 01:31 PM
  4. Replies: 1
    Last Post: 03-26-2012, 12:20 PM
  5. Can you have validation information carry a color?
    By lightecho in forum Excel General
    Replies: 1
    Last Post: 03-15-2010, 01:43 PM
  6. [SOLVED] Edit ODBC connection information for a work sheet
    By Per in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 12:05 PM
  7. Replies: 2
    Last Post: 01-13-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1