formulae variables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Formulae with variables

Formulae with variables

resolvedResolved · Medium Priority · Version 2007

Tom has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel VBA Advanced course
Access Introduction course

Formulae with variables

I want to fill a column with formulae relative to either a cell or a sheet reference; in other words to include Cells(i, 2) or Sheets(i) in the formula. Can you advise how I can construct the formula please?

RE: formulae with variables

Hi Tom,

Thank you for your question.

Sorry for the delay in responding.

Can you please provide some more detail into what you are trying to achieve.

Regards

Simon

RE: formulae with variables

Hi Simon.

Here is the example:

Sheet 1 column A is a list Flat 1, Flat 2 .......Flat 192.

Sheet 1 column B is intended to show, via formulae, the value in cell (3, 5), (fixed), in the corresponding Sheet called Flat 1, Flat 2 ....Flat 192.

I am sure this can be done by a formula relative to the value of cell (i, 1), but get very confused on the syntax for formulae, and how to write it to accommodate the relative sheet references.

Can you help?

Many thanks,

Tom

RE: formulae with variables

Hi Tom

I work with Simon and we have discussed your requirement. We are reasonably confident that we can create a solution for you however it is beyond the capabilities of this forum. What we would need to do is have you send us your working files along with a summary of key features you require.

We can then confirm duration of work (we reckon 2-3 hours) and related rates. If you then want to proceed just let us know.

Kind regards

Jacob

Mon 17 May 2010: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
microsoft+excel+course and other training courses.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.07 secs.