macro - formats

Hi I have the following line in my VBA, ActiveSheet.Range("G206").Formula = "=(F206 - D206)/F206". What I am trying to achieve is format the output as a percent. I have tried wrapping my code in Format() and I have also tried adding, .NumberFormat("Percent") on the end with no joy. Do I have...

I am trying to create a macro that will highlight cells already selected. Below is the code I used but that is only working for the active cell. How can I alter the code to highlight all the cells I selected. Example: Cell C15 is the active cell and cells C15:C20 are selected. When I run my...

Hi Guys, I've made research about this but can't find the right one. So I have this excel sheet named "Subject" with multiple sheets (sheet A to D). What I need is to find the codes wherein the macro will copy the entire format of Sheet A to Sheet B,C & D. Any help will be much appreciated.

This is the Current Code I am running for my "Next Invoice", the only problem I am Having it only save one of the two work sheets I am using...Can you give a not so smart guy a little help and saving both "Invoice" worksheet and CustomerCopy" worksheet? Sub NextInvoice() Range("J1").Value =...

I have a spreadsheet with 20+ worksheets. Throughout each sheet there are cells formatted for either "Currency" or "Accounting", depending on how I wanted the cell justified. The cells are currently set to show the USD symbol, but I would like for my users to be able to set the symbol to...

Hello All, I am new to the forum and have been using VBA in a limited fashion for about half a year. However, it is my goal to get a lot better at it so here I am. My first question involves comparing values between two different workbooks using a macro. Specifically I would like to: Look in...

I extracted data from another database. I want to make this data in pivot table formatting, which means fill Country and Product Column in every row so I can do analytics by country or by product type. There are 15000 rows. How can I do it using Macro? <tbody> B C D Country Product Product...

This is a code that creates a value in a cell based on the previous line number, it then hyperlinks this cell to the associated file folder for that Inspection number Range "G" is the cell to receive the hyperlink. =SUM(R[-1]C[-6]+1)" Takes the previous line number in from one row above...

Hello, I need to transform a table like table 1 in a table 2. I need to do this in a very repetitive way. Each calculation output is something like Table 1 and in fact I need the data in a Table 2 format. Honestly I don't have many clues in how to do it. Table 1 <tbody> x y z a b c aaa bbb...

So I have three sheets "Yard", "Available spaces", and "Yard configurations" If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of...

Hey Guys, I'm running macros off a checkbox that hides a certain number of rows, but when the rows are being shown again, all the drop down boxes are bunched at the top of the range. Here's my VBA code so you can understand what's going on. Sub CheckBox1696_Click() Dim mode As Boolean...

Hello everyone, I have an difficult problem and i do not even know if this is possible in MS Excel. The question is as follows: The Excel file should automatically calculate the amount of palletlocations needed for storage. <tbody> Boxes Monday Tuesday Variation 1 0 0 Variation 2 140...

Hi, I have a master sheet with Columns dated across starting from 01/07/16 in Cell B1, 02/07/16 in Cell C1 and so on across. I have charts that are connected with the master sheet and I want it to update each day with only data that is entered so that the charts arent showing loads of empty...

Hi Everyone i found this template online and was using it perfectly until i updated to 2013. Can anyone help me modify the code so it works with 2013. Cheers Option Explicit Sub CallAB() ActiveSheet.ChartObjects.Delete ActiveSheet.Shapes.AddChart AssignBubbleSource...

I work in Advertising Sales and when I send clients their daily logs in excel, some need to have day parts added to the corresponding time slots. An example of this is: Date Scheduled Time Aired Program Name 7/4/2016 6:48:08 AM Early Morning 7/4/2016 6:50:08 AM Early Morning 7/4/2016...

Hi All, :confused:Im struggling with this, any ideas will be much appreciated. I have a table A1 to M500. I need to switch columns L and M values Then delebte columns B, C and I Then replace...

Hi All, In an excel sheet after I select the empty cell I need to select from the next cell to it and start reading A B C 1 2 3 empty 3 4 2 4 5 If I put in the code below it goes fine but it goes to the empty cell then starts back again from B2 Public Sub proIterate()...

I am wanting to format 3 columns of data in the comma style like I would if I used the Alt+H+K shortcut would format. Instead I cannot find any method that works. I have used "#,###.##" & "Comma" and still the values do not look at all like they would if I used the comma icon on the Home ribbon...

I am wanting to format 3 columns of data in the comma style like I would if I used the Alt+H+K shortcut would format. Instead I cannot find any method that works. I have used "#,###.##" & "Comma" and still the values do not look at all like they would if I used the comma icon on the Home...