Get instant free expert help with Excel and Google Sheets

I have one sheet (Sheet1) that's listing several values in the A and B column. On another sheet (Sheet2) i have two cells (for example D1 and E1) that simply gets the two first values in sheet 1 with the formula "=sheet1!A1" and "=sheet1!B1" . I want to have a button on sheet 2 that when pressed, updates the values in D1 and E1, so that it increments the formula by one. In other words I need it to update the formula to "=sheet1!A2" and "=sheet1!B2".

I would like to add sale price to a table I already made with you

i want to do some things in excel automatically which i am doing currently by manual process with dates i want them to be auto generated and the copy and paste please tell me easiest way to do this i have asked this earlier but not got proper solution.

I am trying to make a cell that references a sheet from another excel document but is used in another cell in same document so I can edit the export file name at will.

incompatibility with excel 2010.i had help from someone before .

I am trying to add a column of cells but also have "IF" formulas. for example: A6=SUM(A1:A5),IF(A1>1,A6=500,""),IF(A2>1,A6+1000,"")

I'm using a formula to reference a closed spreadsheet but I only want it to return the data in the column not repeat the data from the start

I'm creating a payroll spreadsheet that says if X employee is working go to a table and pull the rate and multiply the hours time their rate and then also if they had overtime go to that same rate table and multiple their rate by the overtime hours and 1.5.

I have a table of species detections over time, it has multiple species and multiple times (hh:mm:ss). I have another table that I want to use to tally up the first table. For example, how many of Species A were detected during the 12:00 hour. How do I automate the second table to draw its information from the first?

if both first letters are capital, excel will keep only the first one capital