bring

Hi everybody, I've been doing some research on how to bring my excel spreadsheet to the foreground whenever it goes into the background. I've stumbled across 'AppActivate Application.caption' but it doesn't work. The excel spreadsheet simply flashes orange in the taskbar and doesn't come to...

Dear Friends I am new to this forum and need a solution to my problem: I have a large sheet and have about 50 headers on coloumn on right side. I need not to scroll to right side and need to bring each coloumn in front of me with one click. At the same time I need some fixed cells always in...

Hi, I have two columns with Entry no and TRansferred from entry no and would need to calculate a column Expected initial Entry no, that brings the initial entry no if an item has transferred ( it's differnt than zero). It is easy to bring the value if we have one transfer for example entry 2...

Hi all, i am just started to use macro recently , and i face issue after creating the macro it worked fine for few days then it bring Debug error message although i didn't make any change in it, any advice?

Hi, I created a macro today to rename two tabs. Since then, when I tried to launch excel, it doesn't bring a blank worksheet but it asks me if I want to open a new sheet or one of my most recent files. Is there anything under options>Advanced that i need to tick? to bring me to a sheet 1...

Hi Lovely people, Can someone please help me with this I need a formula in I14 to match the I12 with row2 AND I13 with row 3 and E14 with A4:A9 and bring me the corresponding value. Please have a look at the small screenshot I've attached in the below link. Cheers...

I am trying to write a formula that look at the header on the main tab for example AC6 contains a date 11/01/2020. I want it to look at the date in this tab, then go to tab titled Care Design and look the dates in column C and when it finds a match bring back the value in column I. The problem...

Hi. I've got a chart with several thousand data points (all of which must be plotted). The problem is that the data with a zero value (for either the x or y axis) are being displayed in front of the axis line, whereas I would like it the other way round. Is there some way I can select the axis...

Hello I have two spreadsheets in the same workbook, I need to pull information from each into a third worksheet. The worksheets are labeled ASV, IAR, Combined. The two worksheets have alot of columns (not necessarily the same columns). The number of rows vary between the two Is it possible to...

I am trying setup an index match but I have 2 of the same value. How can I setup my index match to bring back the second match? thanks

Hi there, Hoping someone can help, if my question makes sense. I have a formula (in B4) to look up the first value which appears in a row and give me a date from the matching column (apologies I dont know how to add formula and screenshots) =IFERROR(INDEX($D$3:$L$3,1,MATCH(A4,D4:L4,0)),"") A4...

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

I have a spreadsheet in which I need to report the deposit date for transactions. However, the spreadsheet has separate columns to enter deposits dates. For example, cc deposit dates are entered in column A, check deposit dates are in column B, and EFT deposit dates in column C. For the...

Hello, if I understand this correctly, Power Pivot is only good if one works with large data. So, I cannot bring data into excel (after I do connection) other than using Power Pivot? If I drill down, will it only bring 1000 lines? If that is the case, what's PowerPivot is good for? Doing just...

Hi, I have columns with values a b c d etc, and i have to bring them all to one cell with a comma(,) after each of the values in the cell. Please help on this. Regards, Nik

Thank you for your time in reading this< I've done my share of searching, but I think I don't know how to ask this question. I have a workbook with multiple connection queries, but I don't want to bring all the tens of thousands of lines of data into the table. Is there a way to look at the...

Hi, I want formula to bring sets of four columns into one set of long columns. I have 1000+ columns vertically located so want to bring in one series. Please assist. Current layout a b c d e f g h I j k l a b c d e f g h I j k l a b c d e f g h I j k l a b c d e f g h I j k l Desired layout...

I have a spreadsheet (please find attached), where in I want to pull out all Specific cells containing certain text to a whole new column. The idea is that certain values which should be found in one column are spread in multiple columns. thus i want to bring them all under one column.. Thank...

I have a pivot table which has various fields, including Serial #, Date, and Revenue. The Revenue appears fine as long as I don't have a date, but when I bring in the date field it somehow gets messed up. The Revenue column disappears, and instead seems to somehow become a row on top of Serial...

Dear All, I have a file created by an external in which the toolbar is hidden. I have no options to bring it back. Do you have any ideas. Thank for he support. regards Klaros