Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Topcat04

    Convert Horizontal Data to Vertical Data

    Awesome!! Thank you for your patience and help, we have the desired result!! really appreciate it, - TC
  2. Topcat04

    Convert Horizontal Data to Vertical Data

    Hi Skip I was hopeful this was going to work and in theory it should do, however trying to normalize the data, it breaks down at step 6, as values is set to Count of Value and the data is the same as it was on the previous work sheet, other than it has blue shading on row 3 and 4 and a dropdown...
  3. Topcat04

    Convert Horizontal Data to Vertical Data

    Hi Skip the data is inherited and I am looking to make a table of it so that it will be in a better structure. I cant change the source as its a one off inherited. As described the dates go from Column D to Column LH the products go from row 3 to 130 I'm looking to get it so that it looks...
  4. Topcat04

    Convert Horizontal Data to Vertical Data

    Hi Skip Thanks for the response, I expected it to be a VBA as it is 317 columns of data. For each column of data the product identifier, description, weekly sales needs to be copied under each other and the date pasted for each entry that week. With 127 products by 317 columns, that's quite a...
  5. Topcat04

    Convert Horizontal Data to Vertical Data

    Hi There I'm looking for help to convert horizontal data entered in a workbook for recording sales to vertical data please. I'm hoping someone with VBA expertise will be able to help. In row 2 are the weekly dates recorded in Column D to Column LH In row 3 to 130 are products with their sales...
  6. Topcat04

    LEFT Function with a specific Character

    Jonsi thanks for both solutions, both worked really well. The Text to columns is something that was so simple, but completely overlooked! Thanks for the post and advice, cheers!
  7. Topcat04

    LEFT Function with a specific Character

    Hi All I am looking for the correct formula to return the data to the LEFT() from a specific character in this instance a : Im guessing its a combination of either FIND or LEN or both with the LEFT() but haven't been able to get it to work. using one of the previous posts, I tried using FIND...
  8. Topcat04

    Current Exchange Rate

    any conversion site that doesn't charge. I usually use fxtop.com but they want 400 bucks a year im guessing there are other options such as xe or yahoo?
  9. Topcat04

    Current Exchange Rate

    Hi all Is there a way of being able to pull in the current exchange rate for a currency conversion from one of the conversion sites, so that each time I open up excel it represents the latest exchange rate? Thanks for your help,
  10. Topcat04

    Dynamic Sum from One sheet to another

    Skip Sorry been away from keyboard for the evening as out. The 12weekSales is the summary sheet as far as the data is concerned. It has more development but until I can get the sales summing from one sheet to another, it's still developing. Sorry for the confusion.
  11. Topcat04

    Dynamic Sum from One sheet to another

    Hi Zelgar No the master sheet does not have daily data. It is an accumulation of a lot of data - some needed such as Weekly sales, but some not needed so much at the moment such splitting out stock between DC's and UPC codes etc I have added a snippet of the Master Sheet to give an idea - as...
  12. Topcat04

    Dynamic Sum from One sheet to another

    Skip I have taken snippets of the spreadsheets and hope that this will help explain. I have 3 main sheets at the moment Link Master - this has the 'source' data in it. This is pre formatted and provided as is from another source - so without touching and editing that data regularly which I...
  13. Topcat04

    Dynamic Sum from One sheet to another

    Thanks Skip I do appreciate your help! Ill post back again tomorrow - (its late here now and I have an early start)
  14. Topcat04

    Dynamic Sum from One sheet to another

    Skip your second post came in as I was posting my response above - apologies. I think I have confused you with the notation of the 'Summary Sheet' - that's going to be used for something different, its just currently where the 'control date' is situated. Im going to give this formula a go and...
  15. Topcat04

    Dynamic Sum from One sheet to another

    Those GM numbers are on the unit sales.... The GM Numbers are the product codes.... the 4 columns of numbers are the unit sales (these are just a snippet as they are weekly sales figures) there are currently 61 columns of sales (2014 and 9 weeks this year) but I want to dynamically sum up the...
  16. Topcat04

    Dynamic Sum from One sheet to another

    Skip I believe the answer to your question is yes... Appreciate your help,
  17. Topcat04

    Dynamic Sum from One sheet to another

    Any help on why this formula will not work across sheets will be much appreciated. Thanks.
  18. Topcat04

    Dynamic Sum from One sheet to another

    Skip this is the preserved snippet although the dates still are not lined up with the figures....but you get the idea. 03-Jan-15 10-Jan-15 17-Jan-15 24-Jan-15 GM - 302962 725 319 294 232 GM - 345407 GM - 303056 1073 373 148 124 GM - 302958 1174 681 733 573 GM - 303054 1220 544 265 215 GM -...
  19. Topcat04

    Dynamic Sum from One sheet to another

    Hi Skip Im trying to Sum up YTD sales to the required date that is populated on the summary sheet in cell B2. Snippet of the sheet below starting in Column A and Row 4 (which has Dates along row 4, but they didn't come out very well in the sample below so I removed them) GM - 302962 725 319...
  20. Topcat04

    Dynamic Sum from One sheet to another

    Hi All Im trying to get the following formula to work across sheets without any luck. =SUM(BB5:(INDIRECT(ADDRESS(ROW(),COLUMN(OFFSET($B$4,2,MATCH(Summary!$B$2,$B$4:$DA$4,1))))))) This works fine when its located on the same sheet as the data (sheetname is UnitSales) I want to use it on a...

Part and Inventory Search

Back
Top