Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
J5 J5 is offline
external usenet poster
 
Posts: 1
Default Moving macro response into a dated list

What I'm trying to do is create a macro where you answer questions about
placing an order and then moving the order down to a list a below and placing
it in with other orders for the same date. For example, I already have
orders for July 1-20 and I get a new order for July 15th. I want to move
this data down in the list with the other orders for July 15th. Is this
possible? Thanks in advance!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Moving macro response into a dated list

I think I'd just get all my input from the user. Then when they're done, sort
the data by the date field (and any other keys).



J5 wrote:

What I'm trying to do is create a macro where you answer questions about
placing an order and then moving the order down to a list a below and placing
it in with other orders for the same date. For example, I already have
orders for July 1-20 and I get a new order for July 15th. I want to move
this data down in the list with the other orders for July 15th. Is this
possible? Thanks in advance!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Moving macro response into a dated list

If it doesn't mess up your other data, it would be easier to have the macro
add data to end of list, and then simply sort based on date.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"J5" wrote:

What I'm trying to do is create a macro where you answer questions about
placing an order and then moving the order down to a list a below and placing
it in with other orders for the same date. For example, I already have
orders for July 1-20 and I get a new order for July 15th. I want to move
this data down in the list with the other orders for July 15th. Is this
possible? Thanks in advance!

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
A macro that will hide all but the last 20 dated rows. Mac0001UK Excel Discussion (Misc queries) 1 September 19th 08 08:45 AM
How do I transform a word response to a numeric response? kanegaro Excel Discussion (Misc queries) 0 January 11th 08 05:08 PM
How do I set up a daily call out response response register? Pule Excel Worksheet Functions 1 October 7th 07 01:34 PM
Selecting a response on a dialogue box from a Macro ChemicalJasper Excel Discussion (Misc queries) 2 January 4th 07 02:08 PM
How to pick one or more items out of a list, moving to new list, moving up or down. (form) Subteam Excel Discussion (Misc queries) 3 February 17th 06 04:13 AM


All times are GMT +1. The time now is 12:47 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"