ST Alpha - "excel help needed. " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

excel help needed.

Posted by Truman Oct 2 '13, 08:16

so i have a excel workbook with like 100 tabs (Summary and tabs 1-99). the first tab is a summary of what is on the other 99, except the name of the organiztion, those will be entered on the first tab.

is there a way to setup something on a tab that looks at what row the previous tab pulled the name from and increases that amount by 1?

so if tab 1 pulls from B13, is there a way to make tab 2 look that up, add 1, and pull from b14?

Responses:

you would have to write a macro to do it I believe -- nm - decline Oct 2, 08:28
so you will have a list on the summary page and you want it to drop those entries into basically a title cell on each of the other tabs? -- nm - zork Oct 2, 08:26 2
- yes -- nm - Truman Oct 2, 08:28 1
  - I made a couple of macros for amanda some time ago that did this (except it was changing the tab names) that could be modified for this. - zork Oct 2, 08:32
don't think so. -- nm - znufrii Oct 2, 08:18 6
- hmm, damm. -- nm - Truman Oct 2, 08:19 5
  - if I'm understanding you correctly, that is. -- nm - znufrii Oct 2, 08:22
  - note, if I had to work with 100 tabs, I might shoot myself. nm -- nm - groiny Oct 2, 08:21 3
    - its not my idea. its what the manager and the partner on this project want. - Truman Oct 2, 08:28 1
      - sorry, that sucks. nm -- nm - groiny Oct 2, 08:29
    - and, this. -- nm - znufrii Oct 2, 08:23
not that I am aware of. nm -- nm - groiny Oct 2, 08:17

Post a message top

excel help needed.

Replies are disabled on threads older than 7 days.