answersLogoWhite

0

A formula cannot change the contents of a different cell to itself.


Here's a method that might fill the bill:

  1. Paste an object into the spreadsheet. I selected a smiley face from the auto shapes. It can be anything. All it will do is function as a button...heck, there are even buttons that you can paste in.
  2. Next, right click the object and select assign macro.
  3. When the macro screen comes up, you select "Record Macro"
  4. Select the cell that you want to provide data.
  5. Copy the data
  6. Paste the data where it is supposed to go.
  7. Turn off the macro recorder.
Every time you click the object it will repeat the above action.

The macro will look something like this:

Sub SmileyFace1_Click()
'
' SmileyFace1_Click Macro
'

'
Range("C4").Select
Selection.Copy
Range("E4").Select
ActiveSheet.Paste
End Sub

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

When using the Insert Function button or the AutoSum list arrow it is necessary to type the equal sign?

Not in Excel.


What is user generated formula in Excel?

It is a formula that the user creates themselves, instead of using the built-in functions.


Where can I find the option for using a data pivot table in Excel?

In versions up to Excel 2003, it is on the Data menu. From version 2007 onwards, you can find it on the Insert tab on the ribbon.


How do you add a graph in word on a mac?

To add a graph in Word on a Mac, you can insert a chart using the Excel app. Simply go to the "Insert" tab in Word, click on "Chart", and choose the type of chart you want to insert. You can then enter your data in the Excel spreadsheet that pops up and customize the chart as needed.


In Microsoft Excel functions can be entered using what?

You can enter them by just typing them in with the keyboard. You can also use the Insert Function facility.


Formula could be edited in excel using?

You can click on it in the Formula Bar near the top of screen, or you can press the F2 key.


A predefined formula a formula that excel has already built for you. that performs calculations by using specific values in particular order?

It is a function


When you copy a formula using the copy and paste buttons on the standard toolbar Excel uses what to temporarily store the formula?

The Clipboard.


Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called?

what-if analysis or sensitivity analysis Its What-if Analysis


What best describes the result of using the fill handle on a cell containing a formula in Excel?

It is used to copy the formula down or across.


Can you create formulas in Excel using the mouse?

Not entirely, but you can use a mouse to select ranges you include in a formula.


How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?

You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.