Hi All
I am new to Excel /VBA and have been asked to create a excel workbook that takes data from a SQL table and the user then updates the spreadsheet and then clicks a button to update the table.
I seem to be unable to get the update to work and to me its a very simple task! (Or Should be)...
Hello there, whats the best wAy to do this.
For example i have a list of 4000 students.
The details include I gathered from them where name, email address, courses and their certificate numbers)
Is it possible to pull their data using vlookup,
Then from the retrieve infos. (Name, email...
I almost done with my userform and when i try to update the first row, it doesn't update correctly instead it will use the data 1st row (No8) and update it in the 11th row (No18). Refer image for references. But when i try to update the other row, it works perfectly, only the 1st row is the...
I have two worksheets named "Sheet1" and "Template" I want a few cells (Rate column in a table) to update their values based on the values of a column in Sheet1 (Company Name column) For instance when I select SAGT company from the dropdown menu, I want the Rates in the Template worksheet change...
Hi,
Hopefully someone on here is able to help, i am not familiar with VBA .
i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a...
I would like to create a simple graph that changes according to the current date.
So I have two values that are added in a "Total" cell, lets say for example : B4 = 75 and B5 = 50, so the the "Total" cell would be 125. And the graph I want would show the time evolution of this "Total" value, but...
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...
Hello there!
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...
Hi everyone,
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...
Hello,
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)...
Greetings,
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...
Hello,
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:
Time
Desc
Temp
Prg_Freq
Meas_Freq
Test 1
Test 2
Test 3
1/0/1900 0:00...
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
Supplier
Amount
Owner
status
Date
AVT
500
John
4/22/2020
ABC
1000
Peter
4/21/2020
NAC
600
John
4/22/2020
BAT
10001
Andrea
4/23/2020
Workbook B, sheet 1
Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...
Hey everyone,
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...
Morning all
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
//Changeable-Text-Starts-Here
This text can be changed by macro
//Changeable-Text-Ends-Here
This is also permanent
I want to be able to remove...
Hi,
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...
Hi,
I have the weirdest bug. I have a simple macro that goes like this:
Sub Update()
Application.Calculation = xlManual
ActiveWorkbook.RefreshAll
Range("A20").Select
Application.Calculation = xlAutomatic
End Sub
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
Sub Refresh_Formula()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Calculate
Next ws
End Sub
It would be appreciated if someone...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.