I want to create a command button that will filter specifice product. Could
you please give me sample macro that filter data.
Thanks.
software 發表在 痞客邦 留言(0) 人氣(0)
I have several pivot tables within one spreadsheet. All pivot tables have
the exact same criteria within the drop downs (eg. country, region, city).
The quot;dataquot; presented in each pivot table is different (eg. revenue, gross
profit, net income).
software 發表在 痞客邦 留言(0) 人氣(0)
I am trying to create a spreadsheet with two worksheets, the first is a list
where the user checks off a series of check boxes in a list, the second
worksheet is intended to be formula driven using the check boxes to calculate
the value of each item in the list. Hence I want to use the IF command in the
second worksheet to say if check box is clicked then the value equals x.
software 發表在 痞客邦 留言(0) 人氣(1)
The trace arrows do not appear any more in my sheets - I still can see the
link sheet icon but not the dotted line?
I tried gt;gt; options gt;gt;objets: show all . Did not do it.
software 發表在 痞客邦 留言(0) 人氣(0)
Let's say I have thousands of employees, but I need to determine who
worked for me during a particular date range, and all I have to go on
is their start date in one column and their end date in another
column.
software 發表在 痞客邦 留言(0) 人氣(0)
I created an Excel spreadsheet and saved it to a network drive. When other
people edit the spreadsheet and try to save it they get a message saying the
file is set as read only. They are directed to save the file as another name.
The save dialog box comes up and saves the file as a quot;copy ofquot; the original.
If you right click on the file and go to properties the read only attribute
software 發表在 痞客邦 留言(0) 人氣(0)
Here's one play using non-array formulas which might also deliver this ..
A sample construct is available at:
www.savefile.com/files/9870225
Multiple search amp; auto-extract rows from 3 sheets based on key charge code
software 發表在 痞客邦 留言(0) 人氣(4)
Is there a way to insert multiple rows at a single time? Let me see if I can
explain.
I have an existing worksheet contain several hundreds rows on data. I want
to insert 16 new rows between each existing row of data. I can do this by
going to each row and inserting the rows but I was hoping there would be a
software 發表在 痞客邦 留言(0) 人氣(3)
i have received an excell document and cant open it, can anyone help ,
many thanks
ray
Go to the following URL at Microsoft.com to acquire the free Excel reader:
software 發表在 痞客邦 留言(0) 人氣(0)
I am sure this is possible in a macro, but I'm only just learning them
In a workbook I have 2 sheets one containing last months data (lstmnth)
and one containing this months data (thismnth)
software 發表在 痞客邦 留言(0) 人氣(4)