table column manipulation

Hi Team, I need some option or solution to my query. I have dataset which define with table and given table name and total column consists of 10 and this is not fixed tomorrow when I get fresh data the number of columns may get increase to 11 or 12. I created few formulas based on the table...

I have a table with a large amount of data. I am wanting to change the format of individual columns so that they have their own unique style from the rest of the information in the table. Most of my table is format in an orange color. Darker for header and then the rows with an alternating a...

I have a table that daily updates from an SQL server, this is then pulled into a new excel document through a Microsoft query. The rows of data can be deleted or updated daily on the SQL server. In the final excel document I added a few columns where where specifications are input using a data...

Hi everyone, I am pretty new to using VBA code (four weeks) and I have tried to teach myself as much as possible. There are several sites I have found but nothing that answers the specific situation I am dealing with. I have a list that I get from HR each week and the list might change each...

HI, suppose you hear this allot but I do not have an in depth knowledge of excel. I have search extensively for an answer to my problem but cant find one. Problem: I have a excel workbook which contains all the different products that I stock in my shops. I want this sheet to populate each...

Hello All, I do order management for my company along with 7 others. We have 2 or 3 digit codes that represent each of our customers. Our PO's have 6 numerals, followed by the 2 or 3 digit customer code. We get daily reports that have hundreds of orders on them, The excel template we use is...

Hi I was hoping someone could help me come up with a formula or macro that will take data that looks like the top table and turn it into the bottom one. Thanks in advance. <TBODY> Name</SPAN> Number</SPAN> Country</SPAN> Color 1</SPAN> Percent</SPAN> Color 2</SPAN> Percent</SPAN> Color...

I'm having difficulty reorganizing a set of tables and their columns within. I currently have close to 14K rows of data. As simple as it sounds, I cannot seem to find a fix to go from its vertical layout to a horizontal. Your help would be much appreciated. Below is an example of what my data...