Somthing like this? Sub CopySort() Worksheets("Table 1").Range("a1").CurrentRegion.Copy Worksheets("Table 2").Range("a1") Worksheets("Table 2...
Hello Akansh Nothing attached have you tried freeze panes? Purfleet
Sorry Bandi,i have no idea what your workbook does or what you are really after. Can you add more detail and be more specifc with your questions
Hussain If i have read your questuion right do you just need to compare one long list against another? If so you could just use the match funtion -...
Something like the attached? A percentages of the team allocation based on the previous years percentage 1 product will need a MAX formula to deal ...
Please attach a workbook with examples and not screen dumps.
Set tbl = ActiveSheet.ListObjects("Table1") - is just setting tbl as a short cut for the next line tbl.Resize tbl.Range.CurrentRegion - this resets...
As you have a further form under the first form i think you will need VBA simular to last time. If there was only 1 form or they were side by side...
Yes it worked, so the original formula just needed -2 and the wind speed was a right function
Needs a bit more work but you could do it with a small Macro Sub UpdateFormula2() Dim LastRow As Integer Dim tbl As ListObject ActiveSheet.Un...
Craig Did you look at the worksheet i uploaded? I think it answers the question
Can you add a worksheet with the examples so that we don’t have to waste time recreating the data and potentially getting the layout wrong? From what...
Sorry work keeps getting in the way of more important stuff Have a look at the attached and see what you think, its a bit rough and ready but i thi...
From what you have wrtitten the process seems fairly straight forward, but the different sheets and locations make it very complex without seeing it. ...
Not sure if it is a typo but the percentage in the list is more than 100.So i re-calc'd the percentage based on the points - see attached Btw is al...