vb code

Hello, I have this code that is not working exactly right. I am attempting to get some values of one sheet, and post them to a table on a second sheet. On the first sheet they are copied from specific cells each time. They are being copied to a table on the 2nd sheet in which i need the values...

Hello i could you some help with my VB code. I am having a bit of trouble figuring out how to post values from specific cells in one sheet, say (A5, C10, D15, and E20) to a table on a second sheet on the click of a button. Values in the 2nd sheet will post to the first available row in a table...

Need some help with vb coding. What I have now is If Target >= 101 Then Target = Target * 1.14 If Target <= 100 Then Target = Target * 1.25 What I really need is If Target >0 but <=100 then Target = Target * 1.25 If Target >100 but <500 then Target = Target * 1.14 If Target >=500 but then...

Hi Everyone, Im using the following code to insert multiple data in a single cell. For example: I choose a from a drop-down list (data validation cell) and it inserts the clicked item in the same data validation cell. '------------------ Data Validation add in same cell...

Hello, I created a macro that inserts a copy of the last row's format to make a new record (row). I would like to some how run the macro without a shortcut key. Instead I would like to be at the last record (row) and once I start typing something on any cell in the next empty row it will...

Can't think of any other way to describe this. I Have Excel 2010 and a voter registration list in 1 sheet. A blank sheet will contain a random selection from the VR sheet. Since it only pulls the name, I am trying to write VB code to: 1. Loop through the random sheet, picking the next name...

Dear VB-experts, I have 5 worksheets that are updated regularly in a folder and then brought into a new summary workbook using vb code. This works all fine. My problem is when I try to merge the 5 sheets to one summary sheet in the summary workbook using vb code. Code: Sub Step_5() Dim ws...

Hi I don’t really know anything about Macro or VB. I just started learning recently because I started working on this project, and it requires the use of VB. I have sheet 1 where users will input data, such as selecting from drop down list, inputting some other information, and etc. This...

I have a file that generates a report automatic using the Auto_Open macro and the scheduler .. at 6 am the file open and imports data from other files and generates report, then, the report is auto save as a file with at date code added. Problem ... when the file is rename it still contain the...

Hi, Have some pivot tables, linked to charts which refresh automatically upon opening. Only problem is the table's loose the color formats from the bars, and sometimes the scales are not correctly adjusted. Does anybody know the code for an event macro which will cause the graphs to be...

I have two procedures in two different access forms. First procedure executes fine. It ends up with creating a Table1 by importing the data successfully from the Excel file. But after that later when I call procedure 2, it throws the below error when it is trying to import the data in to Table2...

Hello, I have the following code, attempting to change the color of a data point based on a condition. If a certain value in a "named range" (used as source data for the chart) is 2 then the data point should look "green" on the graph. Sub Chrt() Charts.Add ActiveChart.ChartType =...

Can any one please let me know how I can hide all the tool bars/ Menus in Excel, except the one I created for myself. The tool bars must remain hide untill I close this workbook.

Hi all terrible Title I know but didn't know how better to explain it. It's actually very simple but unfortunately I am not yet good enough at this to work it out. I have a "master table" set up with staff names in Column A and dates in Columns D - DF Underneath I have the same staff names...

I have a spreadsheet that I download from a database that has thousands of combinations. I know that on a small scale I could create named ranges and create a conditional autofilter, but that will not work in this case because there are so many combinations and the spreadsheet updates all the...

I use the following vb code every day in excel: Sub prop() Dim rng1 As Range, c As Range Set rng1 = Intersect(ActiveSheet.UsedRange, [A:G,I:O,Q:IV]) If Not rng1 Is Nothing Then For Each c In rng1 c.Value = WorksheetFunction.Proper(c.Value) Next End If [P:P].Replace "non", "" [P:P].Replace...