Search results for query: *

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

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...

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...

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...

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...

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!

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...

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?

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,

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.

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...

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...

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

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...

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...

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

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

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 -...

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...

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...