I need to do a complicated lookup on very big Excel file and was hoping someone could provide either with the VBA Code or even a formula.
My problem is this:
Sheet 1 has this information:
Account # Contact Name
1234 Mike
1234 Dave
1234 John
5678 Amy
5678 Joe...
I need to do a complicated lookup on very big Excel file and was hoping someone could provide either with the VBA Code or even a formula.
My problem is this:
Sheet 1 has this information:
Account # Contact Name
1234 Mike
1234 Dave
1234 John
5678 Amy
5678 Joe...
I need a unique Macro for Excel and I cant seem to find the solution in VBA Help.
Basically what I need to do is reference a cell and automatically insert a number of rows according to the number in the cell.
EG
Column R
5
1
2
6
8
4
3
This means if cell R1 contains the number (5) I need a...
floridagunner (MIS) 13 Jul 07 9:37
I have a complex problem WITH EXCEL
I have a datasheet with number in one work sheet (sheet 1).
EG:
Account#
12345
45678
52314
In another worksheet (sheet 2) I have have the same account numbers recurring multiple times like this:
12345
12345
12345
45678...
I have a complex problem.
I have a datasheet with number in one work sheet (sheet 1).
EG:
Account#
12345
45678
52314
In another worksheet (sheet 2) I have have the same account numbers recurring multiple times like this:
12345
12345
12345
45678
45678
What I need to do is write a macro that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.