column and row headers

Hello All, I want to convert column headers and then insert rows for usd, eur and other currencies, when transpose this data i will calculate x currency with f/x rate. I want to transpose with formula because i need to do this transpose each month. Thank you very much for your help in advance...

Hi, I have a table and I am trying to get ALL values (duplicated or not) from a column in a different sheet based on criteria. The criteria are the highlighted columns in the first image below. The raw date looks like the other image. I have came up with the formula below but that only...

Hi Team Looking for some help here.....I have Rawdata in sheet2 and column headers info in sheet1 (as mentioned below) ....in required columns data I need it in Sheet3 ....I need help in automating this process via vba.... I need formula to get the columns headers names in sheet1 based on...

Hi Team, Hope anyone can help me, I have column heading fields like New, Old, Exist, Duplicate and each column has its own values and require vba code to get each line separately. For example for product A, if you have value in New and Duplicate amounting $1000 and $2000 respectively then it...

I am trying to see if I can use the column header name "What Fruit" instead of like "E"? Here is a part of my code that I am changing about 15 times but I want to be able to add columns to my sheet with out Messing up my VBA code. Range("d5").Select With ActiveSheet LastRow =...

Hello All, I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet. I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the...

I have a workbook with multiple sheets, with a few hundred rows and about 50 columns. I am trying to make a new spreadsheet with a list of the row and column headers if the intersecting cell has a value >0. Ideally one for each sheet on in a new workbook. This...