Automate updating cells in a row on a weekly or monthly basis
Hi community,
I am a newbie here and also to excel except for a few copy-paste/data entry work. I am asked to automate the process of updating the cells, marked in yellow, in the attached sheet. The value in these cells has to be updated automatically with new data without much typing work. Like auto populating new data from images, files, etc. I am not sure of how to do this. I am using Excel 2010 version. Please help!
To get you started.
G5=SUM(C5:F5) and drag down.
K5=SUM(H5:J5) and drag down.
L5=G5-K5 and drag down.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you for your response oeldere. But this is not the solution what I am looking for. Those columns which are marked yellow in my sheet, has to be updated with new values on a weekly or monthly basis. For example, consider those are the values for the month of June, the sheet will have to be updated with new entries for the next month. Currently, I am manually typing new values under each column every month. I would like to know if there is any other way instead of manually entering the values. Is there any option to create a form or formula or code where I will be able to enter new values for the particular tenant without going to the cells to update it every time?
Maybe you could add an extra column to determine the month.
See the example.
You could design a Userform BUT that is still manual entry. You cannot update automatically unless there is a "source" of the (new) data.
And what happens to the "old" values .. are they just overwritten and no record kept?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Exactly this is what my problem is. I would need to fetch these new data from a source file like images or a text file. These old values need to be overwritten.
Then provide an example with a source file (images will not work!) e,g TXT or CSV
Here is the sample file. Please take a look! The new values are highlighted in yellow.
Can anyone help me with this please?
I used the data in csv file of #8, and added the result below the data of my file in #4.
After that a pivot table to analyse the data.
See the attached file.
I see no difference between the CSV file and the original XLSX you posted so it is no clearer to me what you require.
There is a difference in the values in both the files (same column name but different values). I want to replace the values in the excel file for the columns C, D, E, H, I, J to the values present in the csv files. (same column name)
Is there a specific reason you do not anwer my offered solution in #10?
In XLSX
in C5
=SUMIF('Test (1).csv'!$B:$B,$B5,'Test (1).csv'!$C:$C)
Copy down
Change highlighted to D,E,H,I,J for other columns
Change file name as required
sorry i missed that! thank you so much. and also am sorry to say that was not my requirement.
ok thank you so much!!!! i will try this and let you know
If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @Oeldere).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks