“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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".

Solved by I. J. in 19 mins

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

Solved by A. J. in 23 mins

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.

Solved by V. J. in 20 mins

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.

Solved by Z. U. in 30 mins

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

Solved by B. S. in 26 mins

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,"")

Solved by C. H. in 30 mins

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

Solved by A. H. in 25 mins

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.

Solved by K. L. in 27 mins

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?

Solved by D. W. in 14 mins

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

Solved by O. F. in 13 mins