I'm trying to create a macro to edit/format pivot tables on one of my worksheets.
This is the macro I have so far (there are 5 pivots):
' EDIT_PIVOTS Macro
Selection.EntireRow.Hidden = False...
This is my first post here. I was sure I would be able to find what I was looking for without posting however I didn't.
I would like to add a thick border around rows that share a common value
I have Column B titled Group ID and I would like to have a thick border placed around all the...
I am currently sitting with the following material overview file in Excel:
I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
This forum has been wonderful helping me learn about macros and vba. I come back to the group to see if I can get assistance on how to fill down a border to the last row.
On a pre-designed template with the All Borders around each cell beginning row 6 - row 27 to column H. My macro brings data...
I created a macro that is pulling in data from another sheet and pastes it into a new spreadsheet. It pulls in 3 main sections of data. It pastes it all, does a VLOOKUP on the corresponding columns it needs information based on what it pulled in. After it's done that, I have a "Remove" macro...
I've looked at a couple other posts, but haven't been able to make this work for my situation using VBA.
I want a thin border along the bottom of the cells in columns A:K whenever the value in column A changes.
I am currently trying to create a spreadsheet, it contains several sheets. I have written a formula so when you enter 1 in column A it looks up the remainder of the row from a master sheet.
My problem is depending on the month of the year depends on how many rows will be...