Hi I have been trying to search for a solution for days to no avail. Basically below code should take a specific value (C2) from ThisWorkbook and find if it exists in Sample Db (Column D), if it doesn't exist, it will populate a range of data (Column A to AI) from ThisWorkbook to Sample Db, if...
How are you? I hope you can help me. I'm new in VBA and I have an issue I can't resolve. I'll try to explain what I need.
I have Workbook A and Workbook B.
Data in Workbook A is updated by clicking a button. It takes information from another Workbook B that is generated by an...
I have a worksheet called DATA TABLE which has some 30+ columns. Located in column A is the specific site name. I have another worksheet called DATA AMEND which I am able to populate specific cells with information from DATA TABLE. I wish to then alter any of the cells in DATA...
Any help appreciated. I tried finding an existing thread on it but could not find one close enough. Long story short, I have two excel files. One is called "Item Impact and Cause" and stores a list of 4 columns which are (1) Item Number, (2) Root Cause, (3) Recovery Week, and (4)...
I've been using this spreadsheet for years. It has been working fine.
But today I'm getting this message;
In the lower left-hand corner was the cell reference. I've tried to delete that cell, but it would give the next below that one I just deleted. I deleted the rest of the...
I have a few sheets in an Excel workbook. Each sheet contains a pivot table. I then have a summary sheet that contains columns from each of these pivot tables. An example of the original data looks like this:
I have a code that changes the range of data for a chart as more values are entered. I want the user to enter their values and the chart to automatically update but am unsure how to do this. The code works fine when i manually run it, so the only challenge is making it run by itself. Any help...
Workbook A,sheet 1
Workbook B, sheet 1
Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...
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...
I was very kindly provided the code below which produces a message should the value of one cell (row 39) exceed the value of another (row 41) as users change data in a column. That works great.
What I would like to do is change it ever so slightly in that I would like the message...
I have the following stored in a string (can be in a cell as well, if needed). Let's say s_String1(2,1) or cell A2:
This text is permanent
This text can be changed by macro
This is also permanent
I want to be able to remove...
I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox.
base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...
I have the weirdest bug. I have a simple macro that goes like this:
Application.Calculation = xlManual
Application.Calculation = xlAutomatic
When I use this code, all goes well, but I later get a...
I have written code to update my formulas instead of manually updating using F9
It is not updating all sheets, only the current sheet
Dim ws As Worksheet
For Each ws In Worksheets
It would be appreciated if someone...
I get two different types of messages when opening certain files with a macro, that I don't want to get.
One of them says
"This workbook contains links to one or more sources that could be unsafe.
If you trust the links, update them, to get the latest data...."
Then it gives you...
I have the following formula but want to use INDIRECT function on the column name within the table GANNT so becomes easier to update
Have tried the following but get a #REF...
Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before:
Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen...
Right now, once a week I need to open a file, refresh the table, save and close the file.
Is it possible for excel to automatically update itself without opening it once per week?
Thanks in advance.
I have a query that retrieves information from multiple excel files in a folder
The problem I am running into is that those files have formulas that depend on the current date
Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first
This results in incorrect...
I have two columns in an excel file A - contains the web link B - contains the data to be updated in opened browser as per A.
While opening in the web browser (1 as per image) there is drop down option comes at a particular section (2 as per image) > select an option > it will open up...