multiple sheet

Hello everyone, I am trying to compile an audit sheet in which I am collating individual spreadsheets from different auditors in a pre-defined format. The "Main" tab in my attachment shows how I want the final output to look like, and the "Audit Sheet" tab contains the data that will be provided...

Hello, I am a complete newbie to vba and learning it on my own. I am trying to automate a very tedious process of monthly reporting using excel. The code below is what I have got using the Record Macro function and tweaking it quite a bit to suit my needs. I need to run a similar macro on...

Hello, Can someone help me to sort out myproblem, please? I created pivot tab;e from 10 sheets (all formatted exactly the same), however the pivot table field only contains row, column and value even though it has 17 column headers that I need to do analysis. Is it usual or am have I...

I would like to have a macro which displays in one spreadsheet when sections of other worksheets were updated. So for example in sheet A in cell B4 I would like it display when any cells in between A3:10 and C3:10 in sheet C were last changed, in Sheet A cell B5 I would like it to display when...

Here's my challenge: I have 100 sheets in my workbook that are all identical in layout but contain unique information within each sheet, all based on the same parameters. I've got cells in B14:B18 that contain label information (Earnings by Outlet) and cells in F14:18 that contain numeric...

Hi all, I have looked here a lot in the past for help but this is the first time I have had to post a problem as I just can't figure out how indirect functions work. I have a workbook with two sheets, one with raw data (named RAW) and one in which I would like to have average values etc...

I have 9 worksheets and i would like to Vlookup across all the sheet and return a value from any sheet it finds a value. The range is same for all the sheets. I think there can be a UDF function created but i am not too familiar with VBA. Any help will be appreciated. thanks

Hi I have a spreadsheet with many different tabs, i want to make it so that the user is unable to select multiple tabs at one time. I tried using the below code in the indiviual sheets code Private Sub Worksheet_Change(ByVal Target As Range) if activewindow.selectedsheets.count > 1 then...

Hi all, Below is the snapshot of a portion of my excel worksheet. There are multiple sheets of the same format (different row counts, column counts remain) in the workboork. 070SSM07001(3) <TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 12pt; FONT-FAMILY: Arial,Arial...

I have a workbook with 15 different sheets. Each sheet has a different job name in cell A1 after that everything is identical except for the tab name which is the job number example "TN964" . I want to create a form that will put all the information I enter into ONLY the JOB sheet that would...