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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple inputs and one output
Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this and vary in quantity of sector and MAIO. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1...- westex96
- Thread
- Replies: 12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Multiple inputs to one output
Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1 TX00023 0 TO the following. SECTOR...- westex96
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Multiple inputs into one output
Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1 TX00023 0 TO the following. SECTOR MAIO TX00021 3 2 1 0 TX00022 0 2 1...- westex96
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Select Non Blank cells.
Hi, I would like to select the nonblank cells in a row using the select command. This row contains several different items I need to select. How do I do that? Thank you in advance for your help! If you use excel then you can filter by nonblank cells but my file has too many data points to... -
UNION THEN SAVE QUERY AS TABLE
HI EXPERT, I AM COMPLETING THE FOLLOWING COMMAND TO UNION 50 TABLES. THE DATA POINTS EXCEED 1.5 MILLION AFTER THE QUERY COMPLETES. I NEED TO GET THIS NEW DATA INTO A TABLE. ANY SUGGESTIONS? IF I TRY TO USE THE MAKE TABLE QUERY WITH THE UNION COMMAND IT STILL CHANGES BACK TO A UNION QUERY... -
Alter Table Add New Column
Hi Expert, I am new at sql so go easy. : ) I have 2118 tables I need to update with a new column name of "SECTOR". In each new Sector column I need to fill down all the blanks with the same value. I can accomplish this separately by running the following commands one at a time. Is... -
DISTINCT ROW MAXVALUE HELP
I AM A BEGINNER AT SQL. : ) IF THE X COLUMN HAS EQUAL DATA ENTRIES (10...10 EXAMPLE) AND THE Y COLUMN HAS EQUAL DATA ENTRIES (7...7 EXAMPLE) THEN I WOULD LIKE TO SELECT OUT THE LARGEST VALUE IN THE POWER COLUMN. I APPRECIATE YOUR HELP IN ADVANCE. ORIGINAL DATA ID X Y Power SECTOR 1 10 7 1...
