autosum | Summarize Publications Automatically | REST library

I wish to grab the value from another sheet where the cell reference will change, it changes because im using the lastrow function to enter a autosum into the last row as the data will always change from day to day.

I'm stuck on how i can reference the cell required from another sheet.

This is the code which creates the auto sum in my sheet named "A" and i want to display the result of this autosum in another sheet.

From within the first modal (opened from the first table row's 'Edit' button) the autosum is triggered no problem - in the modal window linked to the first row.

But if I click on any other row's 'Edit' button to launch it's modal - and then I change number the 'select' input value, the alert(x1) shows data from first row table(id=27) - as if the javascript function is not being processed but the id(28) is passed to the modal.

I tried find the solutions in stackoverflow..but i don't find any solutions..please helps me.

i will show the codes

Button to Modal

I got three number values for which all the three are interconnected. So on using formulas to interconnect all the three I am having this circular reference error. Although the formulas work out in giving interconnected answer, on using other formulas over these values, lets say doing autosum on one of those three columns, it returns wrong answer. The situation could only be sited better with an example.

In this sample situation, values in columns B, C and D are interconnected.

I have workbook contain multiple worksheets. I want a function which display the autosum of the current worksheet as well as previous not all. For example If I am on the sheet1 it and it has the value in the cell "E12" = 1 then I will write the function =autosum(E12) which will display result in E13 = 1. Then in the sheet2 if the same cell range E12 = 2 and I applied the function "=autosum(e12) it should display on the sheet2 E13 = 3. But when I go back to the sheet1 it should be displayed same as 1 not should display total for all.

I am using this function but it display same total on all the sheet. The function is as under.

could someone give me a hand with this I have this function to sum cells from multiple sheets. However I also have some hidden sheets that I don't want to be sum. How can I disable my function from reading the values from the cells in hidden sheets? My code:

I'm new in VBA and hope someone can help me with this. I have create a custom function to sum the value of a cell from multiple sheets. However the cell in the sheet that I have to use the function is not the same that I need to sum. For example I need to sum B2 from all sheets but the place where I need to use the function is the cell C2. Could someone help? My code:

Ok so I'm using SQL in phpmyadmin trying to calculate the difference from 2 columns and add that value to a 3rd column. I've imported my data by CSV into the database. I'm trying to "autosum" like excel and Access in SQL database.

My columns are "Tax Collected" - "Tax Paid" = "Tax Gain"

Imported CSV

I'm really new to VBA and have been working section by section on a number of pieces of code to format a worksheet (I've been doing it piece by piece so that I understand how each works, and using a final macro to Call all the macros into one long process).

Issue is sometimes the worksheets I work with are not exported with columns in the same order from month to month (out of my control), thus to autosum a particular column I have to Find the column header, then autosum that column, but this makes the column letter(or number) completely variable. I know how to work with rows as variables, but I'm stuck on column. I've been scouring forums to try and find a concise explanation, but to no avail, yet.

This code DOES work for column Y specifically, but I'm trying to figure out how to get it to use a variable for the column. For example, I'm using a separate Macro called "FindInvoiceColumn" to select the 1st cell in the column that contains the string "invoice_amount", then I'd like to use something like I wrote below to set "ColumnAddress" as the column value of that cell. As far as I know .Column returns the column number, which is fine, but I'm assuming I'd have to use with Cells() instead of Range(), I just don't know how to get here.

(Part of the code also shows Adding the word "Total" to the left of the cell containing the autosum value, and making both bold).

Here's what I have so far: