transferring

Hey all, I am trying to transfer data with this formula =IF(ROWS('Destination Sheet'!$B$5:B5)<=$A$1,INDEX('Reference Sheet'!$B$2:$B$23,AGGREGATE(15,3,('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)/('Reference Sheet'!$A$2:$A$23='Destination Sheet'!$I$1)*(ROW('Reference...

Hi, I've created a userform with text boxes and check boxes but struggling to work out how to get the data transferred onto a spreadsheet via a submit button.

=COUNTIFS($CA:$CA,$CA3,CR:CR,"<"&CR3)+COUNTIFS($CA3:$CA3,$CA3,CR3:CR3,CR3) with this, which I'm using to rank numbers within a range, it works very well, except for the fact that the errors in column CR are not appearing as errors Currently they are appearing as numbers (the total number of...

Hello All: I have a question regarding how to automatically transferring data from one excel workbook to another one. I have 2 workbooks, one of them saves all the trans-action that we have made over the last 5 years. the workbook contains 20 columns, including invoice numbers, invoice amount...

Hi, I have about 30 tables that hold prices of goods in categories. I have use the Append function to create a master price list by combining all the tables. When I add new items to the individual tables the Appended table updates nicely with the additional items. The problem I have that any...

Hi Guys, I need to create a spreadsheet with worksheets for individual people and a summary worksheet listing everyone with the latest entry from their worksheet showing. I'm struggling to work out how to pull across just the latest entry in their lists - can you help? For example; Person A...