Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David
 
Posts: n/a
Default excel-How many macros can one spread sheet have

I need to know how many macros can one spread sheet have. I have a
spreadsheet i am working on that could have just over one hundred macros.

Basically what i am trying to do is set up the spread sheet to have a cell
selcted and click on macro button to put in for example NIV for divison, or
4110 for account.as seen below. I can when we are busy have to write out over
7to 8 pages of entries.
5910 NIS
5910 NIS
4910 NIV
4910 NIV
I have to do sales transfers weekly and writing out first all the account
then enter dollar amounts, then go in to ACCPAC and do a journal of what i
have on paper. May be be abel to inport the excel spreadsheet. ????Help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean
 
Posts: n/a
Default excel-How many macros can one spread sheet have

Hi,

I am not sure exactly what you want to do but you should consider looking
into data validation, it may be able to do what you want. You could set one
column with the account in and another with the division and then
concatenate them in a third column.
That way you can select the account and division from a drop down list.

Hope this helps.

Sean


"David" wrote in message
...
I need to know how many macros can one spread sheet have. I have a
spreadsheet i am working on that could have just over one hundred macros.

Basically what i am trying to do is set up the spread sheet to have a cell
selcted and click on macro button to put in for example NIV for divison,
or
4110 for account.as seen below. I can when we are busy have to write out
over
7to 8 pages of entries.
5910 NIS
5910 NIS
4910 NIV
4910 NIV
I have to do sales transfers weekly and writing out first all the account
then enter dollar amounts, then go in to ACCPAC and do a journal of what
i
have on paper. May be be abel to inport the excel spreadsheet. ????Help



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
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 09:05 PM
How do I spread excel sheet across two monitors? eingram Excel Discussion (Misc queries) 2 December 17th 05 01:46 AM
Excel Slow to open Spread Sheet from Explorer Charles Welty Excel Discussion (Misc queries) 0 October 5th 05 02:16 PM
How do i update hyperlink in excel spread sheet automatically. Phanichand Mudumba Excel Discussion (Misc queries) 1 September 13th 05 05:46 PM
How do you add an Excel spread sheet to a Microsoft Word report? RaymondTBirmingham Excel Worksheet Functions 1 March 14th 05 07:19 AM


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