main

Hi...I have several excel applications and I'd like to create a new one just for like a main menu. I can open the target workbook without issue...I have a button in the target the save and close, after closing the target application it then asks to save the main menu application, if you click...

Hi I have table like below, user will enter age and I want excel to return the name, so I did match/index function like this =INDEX(A2:D7,MATCH(G4,D2:D7,0),1) G4 = age Now if user enter G4 = 40 excel will return john, how can I ask excel to return linda as well. I am thinking it must be array...

Hi guys, Have a file that is shared (lucky me... not) but always having troubles cause people at this company are a bit dummy when it comes to use excel books... I was thinking of having a copy for each user that everytime they make changes, it will show at the Main File. Any simple way of...

Hi All, I have been given a data set that was poorly converted from a pdf file which I'm left trying to clean up. All of the data is in column A and each line of data is in a single cell. Example: A1: A1A# ST. JOHN'S NL STN MAIN B1G DOMINION NS STN MAIN B3Z TANTALLON NS STN MAIN A2: J1S...

I have a macro enabled workbook. The main worksheet, Year 2019, is made up of rows for the complete year. 01Jan19 to 31Jan19 . . 01Dec19 to 31Dec19 Each day of month e.g. 01Jan19, may have one or more rows. The format of this date field is nnmmmnn i wish extract all rows for a given month...

hi,i want a solution of my problem in VBA:I have a main page (a directory for all the sheets) which is hyperlinked to numerous sheets and all have hyperlinks to take me back to the main page and the sheet hide automaticaly . My problem is when i protect workbook (structure protection) the...

How it is possible for every "main", "sub" and "sub-sub" Cases set number before Heading. Numbers should be entered starting from one. Main -> 1 Main -> 2 Sub -> 2.1 Sub -> 2.2 Sub-Sub -> 2.2.1 Sub-Sub -> 2.2.2 Sub-Sub -> 2.2.3 Main -> 3 Main...

Hello everyone, I have Excel workbook where I have the data. My current code is running through worksheet and is creating good looking pdf document (looks like it was created in Word). The problem is that I would like to built the same document in Word with proper formatting. Converting from...

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the result based on a cell on the main sheet. Currently it is just returning regular text, but I need it to return bold text if…. italic text if…...

I have 2 work sheets "Main" and "CheckList". The "Main" work sheet has selections in cells B14:B29 and in cells E14:E21 (by selections i mean i have made is so that when these cells are activated they auto fill with an X) I also have a button on the page labeled "Print" The "CheckList" page...

I created a simple count down to delay the display of my math result. The strange thing happen was, one of my math input (Sub1) not get to display before the count down. Can anyone help me with what's wrong in the code below? ' Function: Making Number from 3 to 10, with count downSub...

Hi I want to do reverse lookup (multiple criteria - returning multiple results). In this case user will enter Address in H3 and dept in H4 then excel will return ph# in cell H6 and name in cell H7. I highlighted cells H6 and H7 and then wrote the following formula in cell H6...

Dear all Having received help already so please could some one indulge me one last time. I have Workbook A in which I have a series of macros that will cleanse a downloaded CSV file from my bank that I have imported into my main spreadsheet. However I would prefer to run the macro without...

Hi everybody, Hope you can help me with the following. In a spreadsheet I have a main listing. The parameters are entered in a different sheet and are set to different codes. In each row of the main list, there are checkboxes when they are selected, and when clicking on the print button will...

I have a dashboard type workbook that has buttons I press which I use to navigate between sheets. On the main dashboard there are a few numbers which I have used vbscript to type. For some reason when I navigate to other sheets these numbers show through from the main dashboard sheet. I dont...

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory. for example main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

Currently I have a pretty basic commandbutton that copies a range of data from my "import" sheet to a row in my "Main" sheet. What I am trying to now do is have the row on my "Main" sheet increase by 1 each time I click this button. So the first time I press this button the data will copy and...

Excel 2010 32 bitABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF1Main LengthMax Length250382.0345678Main LengthSection LengthsTopBottomFinal...

Hi I want to use Flash fill to separate street number from street name. I know how to do it column by column. For example I type 1000 in b1 and the Ctrl+E and that will Flash Fill all the column. I can do the same thing with column C. I type main street then Ctrl+E My question can I fill both of...

I copied the full macro at the bottom of this post, but here's the snippet of it that I'm struggling with. If Not IsError(Application.Match(x, ws1.Range("A:A"), 0)) Then '//Copy and paste Name, TLD#, & Dates...