By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Excel Help

P: 3
I have a very basic issue in excel and I can't for the life of me find the solution. I have a dense worksheet of data and I want to distill some of the information into a much shorter list. The data is ordered and the information I want to pull out from the big sheet and put in the little sheet occurs in the same column in every 30th cell. In my new sheet, I want my column of information to refer to every 30th cell. In other words, I want h28, h58, h88, h118, etc. Unfortunately, I don't know how to make excel automate this process (there's too much info for me to do it by hand). Does anyone know how to do this? Thanks.
Apr 24 '07 #1
Share this Question
Share on Google+
6 Replies


100+
P: 175
are you saying you want to copy every thirtieth cell into the other sheet? or copy groups of 30 cells at a time?

you can use a macro...it will make this very easy. Do you know anything about macros or programming in Visual Basic?
Apr 24 '07 #2

P: 3
i want to copy every 30th cell into one column. i don't know much about macros, but i'm going to spend some time tonight going through some online tutorials.
Apr 25 '07 #3

P: 31
You can download SCAR, it was built by Kaitneiks for games, it works best on a game, which i=I will not give out the name, and that'll be pretty easy if you can script well...
I, myself, have no idea how to script in SCAR, but there are places for tutorials. The scripts are scarce, the most valueble place for scripts is scar-scripts.com or something, but they're all mostly game macros.
Apr 25 '07 #4

100+
P: 175
I was actually referring to Microsoft Excel. Macros are built in to it. Read up a little on it. It will make what you're doing much easier.
Apr 25 '07 #5

P: 3
i'm trying to write a macro to do the job, but i'm not very familar with the syntax of the programming language. i tried writing the following macro, but there's a bug in line where i try to assign values to the cells. can someone tell me what error i'm making? thanks.

Expand|Select|Wrap|Line Numbers
  1. Sub assassin()
  2. '
  3. ' assassin Macro
  4. ' Macro recorded 4/25/2007 by User
  5. '
  6. ' Keyboard Shortcut: Ctrl+j
  7. '
  8.  
  9. j = 0
  10.  
  11. For i = 1 To 30
  12.  
  13.  Cells(i, 3) = Cells(j, 1)
  14.  
  15.     j = j + 5
  16.  
  17.     Next i
  18.  
  19. End Sub
Apr 25 '07 #6

100+
P: 175
try j = 1, instead of j = 0 ... the way you start it, the part with ( j, 1 ) is referring to cell ( 0, 1 ), and that cell doesn't exist
Apr 26 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.