column field

  1. F

    Adjustable Transparency VBA by Column

    So here are the basics: I am working on a large coordination/ scheduling document and want the ability to write a code that would turn certain columns (to be specified in the code by both ranges and single column references) transparent to a certain degree (again specified by code) This...
  2. D

    Formula Help!!!!

    Hello, I hope someone can help me with this issue. 1 sheet has all of my data. The other sheets have a custom template. I am trying to get Excel to populate a cell based on certain criteria. I have the formula.... =IF(AND( Data!B40>=DATE(2011,3,1), Data!B40<=DATE(2011,3,31)),Data!B40,"")...
  3. L

    Moving cells around in a worksheet

    I have a worksheet with the word "Provider:" in column C that appears in ramdon rows. I need to move the contains of the cell in column D that follows the word "Provider:" in column C. I need to move it column B and down one row. Appreciate any assistance!
  4. K

    Insert Column with heading "Detail" and autofill with date and workbook file name until last row

    Hi, I'm trying to find the commands to create a column with the heading "Detail" and then autofill the rows below to say "List Upload-"filename"_"current month & year". For example, let's say I'm working with a file named 'ExecutiveManagers.csv' in March 2011, how can I create a column that...
  5. A

    Use VBA to find column and replace data?

    How do I use VBA to find a field name (Column header?) and then replace its data (row 2 to the end of the table) using a Vlookup table. I already have the lookup table built. Column names and table lenght are not always the same. Thank you. Alex
  6. L

    Pivot Table Repeat Row Names

    Hi again, I was wondering if there is any way to create a pivot table so that it repeats the row name rather than leaving blank space. As an example: If I make a pivot table and A is divided in to 3 subsections, the pivot table looks like A in a box, with 1,2,3 next to that box, with A listed...
  7. R

    Check if forfields present in pivot table, then remove

    Hi guys I've got a pivot table setup. The user can then play around with it i.e. drag and drop page fields into rowfields and columnfields and vice versa. Now I want to write a macro that checks if there are any rowfields or column fields present in the pivot table, and if so then relocate...

Some videos you may like

This Week's Hot Topics