I have 3 IDENTICAL workbooks (say WB-A,WB-B,WB-C) with 4 sheets in each workbook (say WB-A1,WB-A2,WB-A3,WB-A4 / WB-B1,WB-B2,WB-B3,WB-B4 / WB-C1,WB-C2,WB-C3,WB-C4). These 3 workbooks are basically reports for 3 different projects, which are updated individually on a monthly basis...
Hello all - I am hoping someone may have some input on this, please:
I have created 5 named ranges from a table. Each named range is simply one column of data.
Then created a lookup for the (names of) these named ranges (names match exactly, etc.)
Once I had a lookup list, I then created a...
Similar to the bookmarks function in word, I would like to have values in powerpoint linked to excel (not a graph) and automatically update as the numbers change.
In powerpoint in textbox:
Revenue for the last fiscal year was 1,234,567...
I have built an extensive program for my organization which periodically needs to be updated.
I have tried having a macro that deletes all the old macros except itself and then reimports from a central repository but I run into a naming problem.
Source code below. I have reference...
I am not new to Excel, but I have never messed with formulas or documents with large amounts of information.
However, I am now faced with doing weekly and/or monthly updates on a master spreadsheet/workbook that has names, case numbers, completion dates, and other personal data.
Is it possible to create a data entry form update in real time just like MS Access, also it should retreive and edit data from the table aswell.
Or do I have to use MS Access or another software for this?
I have a database tracking whether employees attend their meetings. For every meeting they attend they get paid. The attendance sheets get submitted by an upload form into my database as a Form with checkboxes for each employee. Now I want my VBA code to see that if the "AttndMeeting1" value is...
When we get an updated spreadsheet my job is to update the sheet to the new sheet but still have all our data we added to the old sheet. This involves checking any adds or drops. We use the address column to check.
If the new sheet doesn’t have an address from the old sheet I cut the...
I'm trying to write a formula to check for new data added each day with certain criteria. One worksheet has data added to it, and the other worksheet runs the calculations. So Worksheet 1 will have x number of lines of new data added to the top of the list, and each new...
Hi I am trying to add a rent amount to a total on a weekly basis.
I have a dashboard that is used by the boss and he wants to have it updated weekly.
Is there a formula that can automatically reference an amount cell and add that amount to the total on a weekly basis. Say every Monday.
We have a register keeping track of all our counselling referrals and I need to keep track of numbers of unallocated patients based on differing sets of criteria, as below:
Seeing if there is a way of a source range being "updated" such that once a value is selected from that source, it can not be selected again? An example being something like a bingo game where once B14 has been pulled, it is out of the pool of remaining selections?
I want to copy sheet1 to a new sheet2 and then when the data changes on sheet1 I want sheet2 to automatically update. The reason is I want to able to hide some rows and columns on sheet2 to obtain a better print format.
I was going to use INDIRECT however it appears I would need to manually...
Good Morning All,
I'm trying to make a macro that links an excel list of meetings with an outlook calendar.
I have created a macro so far that is able to create the entries and check to see if the entry exists by a specific date (which doesn't allow for any flexibility).
I now need to make it...
I am creating a summary sheet for all the worksheets in a workbook. For example, I want to be able to sum E3 from all worksheets. I have been using something like: =Sum('*'!E3). This works fine, but each week I am adding a new worksheet to the workbook and the formula does not update with the...
I am looking vba code in order to get desire output. I have several columns which contains product details, there is column called "Qty" we get request from customer and will order the goods based on available qty in our store. If available in store then will get it otherwise will get...
After two hours trying to find this over internet, I finally gave up and I'd like to asf for your help!
Say that in one sheet I've a table with say 500 columns and 6000+ lines.
In other two sheets of the same workbook, I've made 50+ charts to get the information I want from the...
I am looking 2 formulas. Cell R5 contains data and cell R15 tells me if this data is true. I therefore want cell R16 to check if Cell R15 is True and therefore show the data that is contained within cell R12. If Cell R15 is false I don't want cell R16 to show anything. The 2nd...
I have a workbook where I have several summary worksheets; each worksheet records the progress of several students on an achievement (i.e., "Complete", "Partial" as each student achieves the goal). The students are organized in columns - student 1 is tracked in column A, student 2 is tracked in...
· User must open the word document (attached)<o:p></o:p>
· A Input box must appear (all read text fields ) <o:p></o:p>
· User will type in the multiple information<o:p></o:p>
· Then user click on Update & Save button<o:p></o:p>
· Must update information from...