Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2023, 01:33 AM
Mauri Mauri is offline Drag and Drop from fields and nummering? Windows 10 Drag and Drop from fields and nummering? Office 2016
Novice
Drag and Drop from fields and nummering?
 
Join Date: May 2023
Posts: 11
Mauri is on a distinguished road
Default Drag and Drop from fields and nummering?

Hello all


I am stuck, I need some help please.

I would like to build in some automatism for my process. created this document. I have some difficulties with the automation of the consecutive numbering, as a formula as well as text.

For example, if I select the fields "H4-H11" and then drag them down the logical sequential numbering does not match the numbering in the with this in the document. From an Excel logic perspective I have to agree with the numbering of the fields, but I need them need it numbered accordingly as I know it from 1-49.

I have an identical problem in rows "A8-A10". I have created the first three lines "manually", hoping that the numbering numbering from the pattern with the drag down automatically.

=TEXTKETTE("int"&B2&"01") <<-- Created manually
=TEXTKETTE("int"&B2&"02") <<-- Created manually
=TEXTKETTE("int "&B2& "03") <<-- Manually created, selected and dragged down 3 fields.
=TEXTKETTE("int"&B5&"01") <<-- Why is line B5 and the numbering starts again at 1?
=TEXTKETTE("int"&B5& "02")
=TEXTKETTE("int "&B5& "03")



Thanks and Greetings
M
Reply With Quote
  #2  
Old 05-14-2023, 12:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Drag and Drop from fields and nummering? Windows 10 Drag and Drop from fields and nummering? Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet ( no pics please). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 05-14-2023, 12:46 AM
Mauri Mauri is offline Drag and Drop from fields and nummering? Windows 10 Drag and Drop from fields and nummering? Office 2016
Novice
Drag and Drop from fields and nummering?
 
Join Date: May 2023
Posts: 11
Mauri is on a distinguished road
Default

sorry this post was a wrong post, if you will go to the right post, please follow this Link: --> https://www.msofficeforums.com/excel...-counting.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drag and Drop from fields and nummering? automating drag & drop rob171171 Excel 9 04-23-2016 07:09 AM
Drag & Drop between fields is sketchy? johnlondon Outlook 1 03-26-2014 03:31 AM
Drag and Drop from fields and nummering? Drag and drop macro Amanoo PowerPoint 2 06-15-2012 04:01 AM
Drop and drag macro Jamtart PowerPoint 3 04-15-2012 11:05 PM
Drag & Drop problem nickywave Outlook 0 04-12-2011 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft