Okay, I found this bit of code from a post back in 2010, and I am hoping that somebody can please help me figure out what kind of variable "hb" should be, and what it should be pointing to because the original person that posted this code never included them at all. I know this code was intended...
I have around 250 sheets in a workbook all with a unique sheet name. I have 250 unique pictures (custom border templates) that correspond to the sheet name which I would like to insert into the header. How could I do this without manually going into each sheet inserting the picture and...
I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :)
I currently have the following Dashboard:
Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
Apologies ahead of time for the ugly code. I am a complete novice at this and have used inputs for forums like yourself to kludge together something that appears to work, except that I can't get it to run successfully when I push play. I've seen a lot of posts about only working when...
Hello friends and community,
I am very new to vba and trying to figure out how to do below.
I need to copy a pivot table's data from one workbook to another
Copy from the highlighted header (Week number)
Paste to the highlighted header in another sheet
Difficulty & Concern:
1. the header...
Hello Brave Excel Lovers and Helpers
I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached)
I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then...
I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this.
I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
We keep a server list in Excel ready for any dinosaurs still lurking who want to read it.
I'd like to show at the top of the spreadsheet (C2, D2, E2)
last modified cell (highlighted would be a nice touch)
I am looking for some VBA code to help me with the problems, it would be great if one can help.
I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
So I need to get some names and make userform inputs
so heres what i need,
I have 5 Cells with headers and 5 cells which need readings
I have userform1
I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes
Below the header boxes I have Input...
Just wondering if there's a more clean and condensed solution to this macro I'm working on. I'm trying to map data from a client's payroll file onto our template in order to upload it to our system for record keeping. I need to copy the data (all rows in the column directly below...
I have some vba code that copies rows from a table to another table on another sheet.
The headers for columns D, F and G on the destination table keep being replaced with column1, column 2 and column 3, instead of being left the as they are.
I can't see where it is doing it in the code. Could...
How can i change the above formula to count if the date under the header name Date in sheet Raw_Data matches the date in D2 or withing the week of the date under the calculation Sheet and the if the header named Count of assets in BU have data (if...
=SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE))
Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria
I have the below code copying data from multiple worksheets on to a master worksheet without the header row. It works fine if data is entered however if no data is entered on a sheet it copies the header row. How can I change it so that the header row is always ignored even if it is the only...
I am currently picking cells from another spreadsheet (MasterSheet) which is a flat row by row data set Column A to F 600+ rows.
The Slave sheet I am using to create a more user friendly layout of the Master Sheet so same data but with a slightly different layout, with headers created from date...
how to get data based on header and joint them
my target that cell contains data
here this below :
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
I have a spreadsheet that has about 100 Items in which there is a Header Row for each item and then sub items that breakdown these Items into smaller items by areas. Each sub item total equals the Header Item total. Is there a way for me to filter this spreadsheet so I can get summaries of each...