Currently, I am working on the project with 7 different pivot tables stored on 7 seperate work sheets and the main sheet where i keep data extract. So I decided to use VBA that every time when I update my data extract to automate this process with the help of macros and VBA. I could...
I have a table inside my excel document.
The table is pretty large, and has bounds/data range of ($J$1:$BN$3073).
I am trying to record/write a macro that will
1. Find the end/bottom of this table
2. Copy the 12 rows that are at the bottom of the table
I have been searching for a solution to this issue for quite some time with no luck, some findings get me a portion of the way but not quite what I need. I do not have any VBA experience but I am very competent with formula writing.
I need to pull data ranges from closed, excel sheets...
I have trouble with format of the data area from external data import.
I do properly the connection to the external data and I proceed up to regular point (pasting the data into excel sheet), where I can choose to format the data as a table or pivot table or pivot chart.
But I do not want...
When selecting Source Data for a chart in Excel there's a "Chart Data Range" field. But in the "Legend Entries (Series)" there are also one or more series ranges. What is the point of the "Chart Data Range" if you have to explicitly define the series ranges anyway? If there are some columns in...
I have a requirement where I need to add a macros button to execute a VBA code that will read the string value from a "cell" that contains a "data validation list" with three options ( No Revision, Revision 1, Revision 2) and based on the option selected for that cell from the...
Hello I will first explain how this process works and then ask my question. OK, the serial number is entered via a scanner. The part is then hooked up to a test meter and 8 values are taken from various areas, and the information is entered by hand. When a name is entered in to the last box the...
I am trying to make both a graph (probably line(multiple lines) or bar) and data range (ie row 1 is independent var (time in months), columns are dependent then just proceed) of a set of data that is overall statistics from other data.
My data is able to filtered based on a single...
While trying to put together a few basic functions, I am having difficulty with conflicting approaches.
I would like to create Macros/buttons that create charts based on high lighted data, placing them in certain location/sheets etc. Hence an excel sheet with multiple lists of data, user...
So i have sets of data ranging from a certain year. What I want to do is run a yearly column from min to the max, with the sum of the rainfall next to that.
It looks like below
<colgroup><col span="8"><col><col><col span="3"></colgroup><tbody>
This might be a workaround for my problem in getting the last value in a bar chart to toggle between being displayed and not displayed. The bars on the x-axis represent the 4 previous quarterly averages, a 12 month average, and a summary average that is manually entered on the same datasheet...
If I have a list of cells, is there any way that Excel VBA can make this into a range?
i.e. if I have "B6, B7, B8, B10, C6, C7, C8, C10" it would shrink it down to "B6:C8, B10:C10"
Anyone got any ideas?
I want to ask about excel problem.
How to add local scope of data to series value?
This is my step how to create local data range
Clik "formulas" tab >> clik data manager
I fill name, fill refers to with
Then i choose Sheet1 scope...
I tried searching through the forum for a problem/solution already posted similar to mine and while I found a few, the solutions posted either give me an error or don't return the value I need.
So, specifically, I'm looking to combine the first and last dates to form a date range in a separate...
I am trying to make a large spread sheet that will automatically fill in the 1's under the number if it appears between the start-stop columns; as shown in the example.
It will have many start stop columns filed in, for hundreds of numbers.
I can get it to work for the number if it is...
I have a worksheet that I am trying to count 2 criteria and thought I could use COUNTIFS. The worksheet is set up as such
A B C D
1 Blue Joe Dave Jeff
2 Green Jeff Dave Bob
3 Blue Steve Pete Dave
I want to find the occurances of when...
This should be so simple that I am embarrassed to ask for help. I imported my data and I have a macro that updates the data. Nothing new until new items were added, creating new rows at the bottom and now the Table Format does not include these rows. There are so many formats available that I...
Hopefully someone can help with my question. I am creating a chart in Excel. The data from the chart will be based on a selected range (ex. A1:G1). Not every cell will always have data. How do I set it up so that the times where no data is entered, it does not default to $0, which then...
I have a range of data which is repeated after a break in row X. I need help setting up a VBA macro to select the top range of data and remove it.
This is exported data from another programme and one worksheet contains both "pre" and "post" data for the same data set, displayed as mentioned...