Search results

Hi Prasad I have 30 tables across 30 sheets. I would like to be able to pull up a table when I change cell B47. I just type =Table2 into a cell A3 it will pull up A3 in Table2 I want to be able to dynamically change it.

Good Afternoon Right now when I try this formula I am able to drag down and across and return my desired table when I change cell B47. =IFERROR(IF($B$47=2,Table2,IF(B47=3,Table3,"")),"" ) However I have 30+ tables and a nested if wont be able to handle them. Any other suggestions on how...

Hey Guys The code below keeps telling me that the date I entered is not a valid date. I checked the cells and everything matches up. Anyone have an idea of what might be wrong. Sub Macro1() ' ' Macro1 Macro ' Dim dtStart As Date, dtEnd As Date With Worksheets("Pivot") dtStart =...

Hey Luke I figured it out the code is below. Thanks for all your help Sub copypaste() Dim lastrow As Long lastrow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Worksheets("AllData").Range("A2:A" & lastrow).Copy Worksheets("SelectData").Range("A2:A" &...

Hey Luke It is still not working should I tried taking out the semi colon with no avail. When I take out the semi colon it doesn't error out but what it does not give the intended result.

[/CODE]Thanks Luke. I gave it a shot but I am getting a run time error Sub copypaste() Dim lastrow As Integer lastrow = Cells(Rows.Count, "A").End(xlUp).Row Range("A2:&lastrow").Copy End Sub

Hi Everyone I was looking for some help on creating a macro with the following functionality. I have two sheets AllData and SelectData. AllData has numerous columns that are unnecessary and I would like to copy and paste the necessary data into Select. The issue I am having is that because...

Hi Faseeh Due to the sensitive nature of the file I am not able to upload it. However the issue persists with many of my other array formulas that seek a unique value then sum the content of another cell. I know I can replicate what I am doing with a Pivot table however it is not as flexible...

Hi Guys I have this array fomula I am using to count unique values on certain dates. It is dynamically connected to a date cell. When I change the date cell the sheet take a very long time to calculate. I was looking for suggestions as to how I may speed up the calculation time. I have...

Hey Luke A quick followup to this. I have working with this formula and I am finding the indirect function to be taking quiet a long time. Do you have any suggestions as to what I may be able to use that is less volatile and will speed up the processing time?

you were correct. Alt Shift Enter did the trick! Thank you very much Luke you of were great assistance. Have a wonderful remainder of the week.

Hi Luke Indirect is exactly what I was looking I was sucessful in using the indirect in the index portion of the formula however it does not seem to be working for last part of the match function. =INDEX(INDIRECT("'"&$Q$5&"'!"&...

Hello Friends of Chandoo First off I hope I named the thread right. If I have made errors please do let me know and I will ensure it will not happen again the next time I post. I am long time follower first time posting on the forum. Normally I solve my problem through sifting through the...

So here is what the bulk of my formulas look like =IF(ISERROR(VLOOKUP($VV$4,INDIRECT("'"&$B6&"'!$d:$as"),WQ$3,FALSE)),0,(VLOOKUP($VV$4,INDIRECT("'"&$B6&"'!$d:$as"),WQ$3,FALSE))) Again this pulling costs from other sheets which are populated and used for reporting.

Had quick question just looking to grasp a better understanding of indirect formulas the advatages and disadvantages. I have been tasked with deconstructing a sheet that uses alot of indirect formulas. When I mean alot I mean alot. The indirect formulas reference costs which is then used for...