#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 168
Default Macro

hello,
now i am using this formula =IF(H13="Sale",MAX($A$1:$A12)+1,"") but now i
want a macro, because from now in H13 some data we have to input manually.
thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Macro

Manaully putting data in a cell wouldn't change the need to use a formula or
use a macro. You could probably still use a formula, but the formula need to
be changed. You have not provided enough information for anybody to give you
a response.

"Tufail" wrote:

hello,
now i am using this formula =IF(H13="Sale",MAX($A$1:$A12)+1,"") but now i
want a macro, because from now in H13 some data we have to input manually.
thanks in advance

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 168
Default Macro

oh sorry if i couldn't give enough information ! anyways problam is solved !
thank you very much.

"Joel" wrote:

Manaully putting data in a cell wouldn't change the need to use a formula or
use a macro. You could probably still use a formula, but the formula need to
be changed. You have not provided enough information for anybody to give you
a response.

"Tufail" wrote:

hello,
now i am using this formula =IF(H13="Sale",MAX($A$1:$A12)+1,"") but now i
want a macro, because from now in H13 some data we have to input manually.
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
AutoRun Macro with a delay to give user the choice to cancel the macro wanderlust Excel Programming 2 September 28th 07 04:09 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor [email protected] Excel Programming 2 March 30th 07 07:48 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Excel Programming 1 October 15th 04 01:16 PM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 05:04 PM


All times are GMT +1. The time now is 03:18 AM.

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"