Search results for query: *

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

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

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,

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

Hi I was previously posting in Microsoft Office, but it would seem that this forum is more appropriate for my requirements. Im looking to open up 52 individual workbooks and copy out the data that is in Column N and put it into a master sheet against each of the appropriate sku numbers from...

Hi All I have a need to open up 52 weeks worth of individual workbooks and perform the same function on each workbook. The workbooks are named GMWK01.xlsx, GMWK02.xlsx etc Once open, I need to Insert a column between Column A and Column B, then perform a Right(A1,6) - this goes all the way...

Hi all I recently had to install Office 2010 on my laptop and now when I receive an email from some people that are HTML emails, they no longer show in my preview pane or my 'opened' email, but instead is a HTML attachment. Previously this type of email would be displayed as a html page inside...

Hi Forum Can you please advise how to modify the Sumifs variable to include multiple criteria on the same range. Eg. =SUMIFS(Sales, Variant,"="&$O$6, Variant,"="&$O$12, Variant,"="&$O$13, Variant,"="&$O$16, Variant,"="&$O$28, Format,"="&$Q7) Cell O6,O12,O13,O16,O28 all contain variants that...

Hi Forum Looking for some help please. Twice a month we receive a new pre formatted data file that contains product information and pricing updates. This file is currently over 2000 rows. Included in the rows are merged cells to the width of the data so Column A to Column E. Out of the 2000...

Hi There I have a challenge that I am sure someone can help me with. I have 52 weeks of data by 9 different regions to sort by format. Please see a sample of the data below. This represents 4 weeks of data by 2 regions - as noted above there is 52 weeks by 9 regions. xxx Hardware xxx...

Hi There Can you help me with a solution that will highlight my complete row when using the Top 10 conditional formatting in Excel 2007. Currently it only highlights the cells in the column the top 10 is being based on. Thank you in advance,

Hi there I currently use the following formula to gain an average of the data. =AVERAGE(BI21:(INDIRECT(ADDRESS(ROW(),COLUMN(OFFSET($H21,2,MATCH(Summary!$B$1,$I$5:$DI$5,0))))))) However, this does not give a true reflection of the average qty per week when the data starts at a later date from...

Hi there I have been asked to help a friend with a solution for recording hours worked and pay calculations. They get sent a sheet each week with data corresponding to Employee number, Hours worked, holiday pay, sick pay, Total hours, Total Pay and Date. What they want to achieve is to each...

Hi There The system in the office is very old! Unfortunately when it produces reports it produces it as a text file in Excel, but ALL the data on a row is in a single Row (Row A) It is able to manage the line breaks and place them in additional rows but there are approx 10 'columns' of data...

Hi There Im hoping this is possible. We have a file that is produced each week that contains shipment details. Column A uses the sku number to identify the product. Column D has the qty being shipped Column H has the departure date (The other columns contain additional data that is not...

Hi There I have recently moved to Excel 2007 and am having teething trouble with the new formulas and enhanced options. I would like to turn the row A:V black background with red writing based on b containing the word "Delisted" I see there is an option now with specific text, but I was...

Hi There I am after a best practice solution please. I have 25 graphs in a dashboard report. Each month, new data is added and I need to expand out the data series to include the new column reference with the new data. Eg a1:m1 Next month it would move to a1:n1 Im sure there is a best...

Hi all I have just inherited a sheet with dimensions of boxes for a complete product list. The challenge I have is that the dimensions for Length, Width and Height are all contained in one cell, rather than in individual cells. EG :: 6.5"x17"x4.25" whereas I need them in seperate cells EG ...

Hi There Hope you can help with my compare query. Is there an easy way to use conditional formatting to highlight in red numbers that have changed in the appropriate cells. I have two worksheets of data (Descriptions, Dates, qty's to name a few columns) and I would like to easily compare the...

Hi all Is there a way to do a sumproduct on word or number contained in cell So instead of finding a cell that is equal using = and only has one word in the cell, is there a way to find all those that contain the word Licensed in the description? LIKE "Licensed" To the same extent, we use...