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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel software training - macro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Macro

excel software training - Macro

ResolvedVersion Standard

James has attended:
Excel Advanced course

Macro

How can I create a spreadsheet that has interactive macro buttons running data from a static data worksheet (i.e. historical information only rather than realtime)

RE: Macro

Yes go to View then Toolbars then Forms and select the type of button you want

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.