sheet

I have a simple workbook with two sheets. Sheet 1 contains: <tbody> NAME AGE HEIGHT WEIGHT JOHN 34 52 23 PETER 23 12 62 LUCY 45 23 86 DANIEL 23 42 34 </tbody> Sheet 2 contains a message: Choose a person I then has a dropdown/combo box (data validation list, the source being the list...

Hello, I am trying to export a specific range of cells (A1:E18 for one and I1:M18 for another) on a specific sheet and save it in a HTML table, separately. The code I have below is what I found and have been working with to try to modify but as I make changes I don't seem to be affecting...

Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days. What I need to do is copy data from 1 of...

Good afternoon all, I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value ! I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3...

Hi guys, 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...

Hello everyone. I am trying to piece meal my VBA where I need it to select all sheets in the workbook and delete the last row in each sheet. Each sheet has the same headers but varies in row so as long as it is the last row being deleted it will work. Any pointers would be greatly...

I have 2 columns on Sheet 2 In column 1 it says Mon all the way down to A10 Then Tues for a few more cells below, then Weds for a few cells and so on. The list is sorted in order To the right in Column B some cells have numbers in them and some are blank On Sheet 1 I want a summary, so it...

I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter Your assistance is most appreciated Book1AB12Financial Year(blank)34Row LabelsSum of Capital Cost5(blank)6Grand...

I have a pivot Table on sheet "summary" Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year It would be appreciated if some could provide me with code to do this Book1AB12Financial Year202034Row...

Hi This should be simple but I am finding it baffling The formula that works: =Match(B4,'\\network address\folder\[file.xlsx]sheet'!$E:$E,) I get the result 12. My understanding is that this is the row which the value of B4 on the current sheet is found in column E on the specified...

Hi Everyone, Here i am trying to calculate the value based on the headers which are in the "sum" sheet and their names will only be A,B,C......, and my inputs are in "main" sheet but in my input those columns will be renamed as Sum of A,Sum of B,Sum of C..........., and my preferred output...

I have been tasked with a extracting some data from a spreadsheet not being that good i would like some help with VBA all the data is on sheet 1 and there is duplicated through out. the way it is layed out is where ever there is a part number there is a serial number in the right hand cell...

Hello Lovely peoples! I have found my self in the wonderful world of VBA and learning everyday that i use it. However, i have found i have hit a brick wall. I'm trying to create a Commissions spreadsheet for the sales staff and i want them to be able to export their data from the system that...

how to not copy a sheet with specific name please, thanks!

I have a list of 150 formulas in Column B I want to put the formula in B1 on the second sheet and extend it from A1:H200 Then I should grab the next formula in B2 and put in on the third sheet And so on Any pointers? Thanks for your suggestions, will help me out a lot

Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...

=SUMPRODUCT((Data[Column1]=TRUE)*(Data[Counts of Assets in BU])*(Data[Region]=A17)) I have the above formula but for some reason is returning as #VALUE ! Not sure what i did wrong I just need the formula that if column1 is true in the sheet data and Region in sheet Data matches region in A17...

I have an issue. I told my wife I could write a script for this. Well its a bit out of my range. I thought it was easy but its not for me because I dont do this enough. I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the...

Hi all, I'm after some suggestions. I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will...

Hi All, I have a workbook with 3 different sheets - (Sheets1 & 2) are data sheets where I enter in various data which both start on A1 and only go as far as row I, depending on criteria will depend on which sheet I update. On sheet 3 I would like an overall master sheet which pulls the data...