There are several ways to name a range.Using a version similar to Excel 2010:
First: When you select a single Cell, there is a box in the menu/icon area
that shows the cell address:(to the left of the box that shows the cell
contents)Like: A2
highlight the range (say: A2 through A101)then, in
Sorry, I already found the solution (source:
https://msdn.microsoft.com/en-us/library/office/ff823060.aspx):
*Create a WorkSHEET Specific named range*
1.
Select the range you want to name.
2.
Click on the "Formulas" tab on the Excel Ribbon at the top of the window.
3.
Thank you for your solution.
How can I name the range: "...in a column and name the range "Input""?
Op dinsdag 6 juni 2017 18:25:43 UTC+2 schreef Paul Schreiner:
>
> You're saying that F77 is a calculation that uses the value of F5.
> You want to change F5 from 1 to 100
> and do WHAT with the
You're saying that F77 is a calculation that uses the value of F5.You want to
change F5 from 1 to 100 and do WHAT with the resulting value in F77?
Are you saying that you want to simply put 1-100 in one column and then show in
an adjacent column the result when this number is put into F5?
Is the
I need a macro for a simple question:
In my Excel sheet I have a value in cell F5 which gives a result in cell
F77.
Now I want to calculate each value in F5 (from 1 to 100) to the associated
value in cell F77 in two new columns: value F5=1->value F77=..., value
F5=2->value F77=... (etc.)
Is
hi noor
can you help me
Regards
chandru
On Tue, Jan 17, 2012 at 12:17 PM, chandra sekaran duraichan...@gmail.comwrote:
Dear all
can you please help me . which i attached excell sheet having two
sheets one SAP sheet and output we need product wise sum Qty and Value
if you suggest
sekaran
Sent: Tuesday, January 17, 2012 12:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ simple Macro need -SAP data
Dear all
can you please help me . which i attached excell sheet having two sheets one
SAP sheet and output we need product wise sum Qty and Value
Dear all
can you please help me . which i attached excell sheet having two sheets
one SAP sheet and output we need product wise sum Qty and Value if you
suggest simple macro
Thanks
Chandru
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread