check the attachement see if it helps
On Tue, Jan 11, 2011 at 12:44 AM, John A. Smith wrote:
> Is there a way to change a filtered view by changing the value of a cell
> rather than clicking the drop-down arrow and scrolling to the data you want
> to filter it to?
>
> Or more specific, see attach
I would use =VlookUp in the corresponding cells in WorkbookA. You can
find some good videos on Youtube.com if you are unfamiliar with lookup
tables
On Jan 10, 1:13 am, Tom wrote:
> How can you use vba to help me do this?
> WorkbookA has 3 columns with these respective headings:
> Code - showing
Hi Paul
Thanks for the reply
I followed your instructions.
When I right click 'Next fortnight' button and select 'Assign macro' -
It
goes to second line of the code - "=ECHO(FALSE)" in 'Macro1' Sheet
When I right click Re-Calculate' button and select 'Assign macro' - It
goes
to second line of the
Is there a way to change a filtered view by changing the value of a cell
rather than clicking the drop-down arrow and scrolling to the data you want
to filter it to?
Or more specific, see attached for a formula to look up all instances of a
specific variable.
Thank you.
John
--
---
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1&"D$65")*1,"Linked Workbook not open!")
But I don't have XL2007 here to check it.
Hope this helps.
Regards - Dave.
> Date: Mon, 10 Jan 2011 0
Hi Ayush,
Thank you these graphs look awesome! I love the bar chart particularly
as it demonstrates our progress over 16 weeks.
However, I am not sure the pie chart represents what I would like to
report. Perhaps I am not being clear so I will try to explain what I
want to see differently. I want
Hi Lucky,
Attached spreadsheet is formulated as per your requirements.
Let us know if this helps. :)
Best Regards,
DILIPandey
On Mon, Jan 10, 2011 at 4:29 PM, lucky singh wrote:
>
> Hi Friends,
>
> Want a formula that find the value as positive or pending as per horizontal
> and vertical.
>
>
see the attachment see if it helps
On Mon, Jan 10, 2011 at 4:29 PM, lucky singh wrote:
>
> Hi Friends,
>
> Want a formula that find the value as positive or pending as per horizontal
> and vertical.
>
>
> Thanx...
>
> --
>
>
Anil,
Try this:
In Excel2007, go to the Developer tab.
In the Controls group (center section) select the "Design Mode" icon.
then, right-click on the button.
You should get a menu, but depending
on the type of button control,
the menu will be different.
If it is a "Form Control", then there wil
Hi Friends,
Want a formula that find the value as positive or pending as per horizontal
and vertical.
Thanx...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:/
I have an Excel spreadsheet which compiles a summary report by linking
to many
spreadsheets, whose file names are computed according to the date,
e.g. If Cell A1
contains '[Data_2010_December]Inputs'! the link formula might be =
+INDIRECT(A1&"D$65")*1
That works fine provided that file Data_2010_D
congratulations Manoj.. :)
Best Regards,
DILIPandey
On Mon, Jan 10, 2011 at 9:18 AM, Manoj kumar wrote:
> Thanks :)
>
>
> Regards,
> Manoj Kumar
>
>
> On Sat, Jan 8, 2011 at 2:58 PM, Maries wrote:
>
>> Congrats Mr.Manoj..
>>
>> -- Forwarded message --
>> From: ayush jain
Hi via,
Please find the spreadsheet containing the scenario mentioned alongwith the
required solution.
Let me know if this works.
Best Regards,
DILIPandey
On Sat, Jan 8, 2011 at 10:27 PM, via135 wrote:
> hi all..!
>
> everyday i am entering value of a product of different weights.
> Weight
13 matches
Mail list logo
