View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe[_31_] Joe[_31_] is offline
external usenet poster
 
Posts: 2
Default IF.. Then.. Post to specific cell

Hi there,
Here is my logic however I need help on the syntax
Need an input box to ask the user "what day of the month
do you want the data posted to?"
Once the user replies....ex: 21 for the 21st of the month
I want data copied from a1:a3 posted to Rox x of the
column that I'll have previously named Day21....ex: Col
AA,Row5 will be named "Day21".
This is all on the same worksheet.

If input is 1 then
post to cell named Day1
elseif input is 2 then
post to cell named Day2
etc.

Thans for your support,
Joe