Tagged Questions
0
votes
3answers
26 views
Merge the cell values if duplicates exist
I want to merge the values in column B if Duplicates exist in Column A
A B
123 A
123 B
123 C
456 D
456 E
789 F
My output should look like this
A B
123 A B C
...
0
votes
1answer
37 views
How to send a post request via excel to a RESTful Web Service without using XML?
Here's the deal: I had a excel table that fulfills a MySQL table. I already made a procedure in server side who receives the sheet, read it and put it on the database. Saddly the sheet and data table ...
-1
votes
0answers
44 views
How do I use the offset function for cells that contain text?
I would like to know how to use the offset VBA function (1,0) for cells that contain text (or at least I think this is the function that I need).
Here I am trying to get the "Freddies's Fish Fryers ...
0
votes
1answer
30 views
Application.filesearch in Excel 2007 w/loop
I've done several searches and I'm having trouble to find the right code when using the now non-existent .filesearch - I've looked into using both Dir and FileSystemObject but with nothing short of ...
-1
votes
1answer
32 views
How to apply weighted factors in two-dimensional data in excel [closed]
I have a large set of staff traveling expense data for the whole year: It records, for each staff traveler, the number of tickets and the price per tickets.
Now the challenge is that company wants ...
1
vote
2answers
43 views
VBA; Invalid procedure or argument error
A little background;
I have to run a weekly reports for my job on Monday for the previous week, however I need to consolidated the material, I did and made a pivot table and I have to do this for ...
0
votes
2answers
39 views
macro to delete rows between named ranges in excel
How do I delete all rows between named ranges?
I have a scenario below
Name Range 1 : SUBHEADER_001 (A1:E1). Displays Headers
Name Range 2 : SUBFOOTER_001 (A40:E40). Displays legends and dates.
...
0
votes
1answer
23 views
Stopping NULL Rows and Columns to get imported from excel to access
I am importing some table from excel to access.Sometime some blank columns also are imported as field13 or field-x .
Whats the reason for that.
Also sometimes some blank rows are imported also.Is ...
0
votes
1answer
50 views
VBA Macro If cell found in multiple cells then
i need help with the below if then statement. will try and explain as best as i can.
cells E21 and F21 is merged and the value varies. i have a list of numbers underneath each other from o1 to o100 ...
0
votes
1answer
23 views
excel: generate missing years of year range into one cell
I have a script that generates the 'gap' years within a year range (year_start <-> year_end - separate inputs) i.e. for 1997-2002, the script generates the following:
1997,1998,1999,2000,2001,2002 ...
1
vote
3answers
45 views
Import and Run Macro from text file
I'm trying to simply import a test macro into my current Excel Workbook. And then run the macro. I'm on Excel 2007. I'm getting the error:
Run-time error '1004':
Cannot run the macro 'DoKbTest'. The ...
1
vote
1answer
19 views
excel: generate missing years in year range either in VBA or function
I've been searching for hours for a function / vba macro solution to my problem - unfortunately to no avail... Maybe you guys can help?
I need to generate the 'gap' years within a range (year_start ...
0
votes
3answers
28 views
Ms Excel “Next without for”
I no this question has come up numerous times, I have read through them all and have come across this problem in my code before and have been able to solove it.
If count > 1 Then
For ...
0
votes
4answers
72 views
Delete entire row if cell contains the string X
I am new to VBA and I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and ...
0
votes
1answer
13 views
Excel importing from CSV adding additional column
Hi I have a CSV file and the first field is date.
I'm imprting this csv file using Data->Import from Text
When I do that it's adding an additional column at the left.
I do not want it to add ...
