Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default move data in cells automatically

i can create a macro to do this, that's not a problem, need assistance with
the formula. i have a spreadsheet where once they take data from sheet A
they archive it to sheet B when they are done with it. problem is over time,
they've added and deleted columns in sheet B. is there a way when they copy
rows 5-10 from sheet A to rows 1000-10005 in sheet B, i can have it move
what's in col B to col C and what's in col K to col Q. can this be done or
am i wishing? tia
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default move data in cells automatically

nevermind, please disregard post. i don't want to do this anymore.

"Ann" wrote:

i can create a macro to do this, that's not a problem, need assistance with
the formula. i have a spreadsheet where once they take data from sheet A
they archive it to sheet B when they are done with it. problem is over time,
they've added and deleted columns in sheet B. is there a way when they copy
rows 5-10 from sheet A to rows 1000-10005 in sheet B, i can have it move
what's in col B to col C and what's in col K to col Q. can this be done or
am i wishing? tia

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
Move cells automatically desperate question oli merge Excel Discussion (Misc queries) 2 November 15th 06 06:36 PM
set tab or enter keys to automatically move to different cells J9Y Excel Discussion (Misc queries) 8 November 8th 06 03:29 AM
How to enter data then move automatically to new cell? Wibs Excel Discussion (Misc queries) 7 December 19th 05 02:22 AM
How do I automatically move vertical cells horizontally? Trice New Users to Excel 0 October 7th 05 04:57 PM
Paste and automatically move cells Paul (ESI) Excel Discussion (Misc queries) 4 June 30th 05 02:31 PM


All times are GMT +1. The time now is 08:07 PM.

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

About Us

"It's about Microsoft Excel"